It's a simple wrapper around GLSL functions. sf::Shader will load your vertex and pixel shaders (beginning with SFML 2.0) and allow you to apply them to other stuff being drawn. You don't have to hassle with OpenGL's shader objects, shader programs, etc.
Also keep in mind that SFML uses OpenGL on Windows too, so you can't use HLSL, only GLSL.