well, it's not all that easy^^ The probably most important aspect are the skills of the artists, you can have the greatest technology, but it won't turn out without their talent

About your questions how to use shaders, you should take a look to the
manual, more precisely in the
How to use Shaders - Section. For even more information take a even deeper look into it.