Triggers, Queries

http://www.youtube.com/watch?v=JNb54seLzZY
Co-related Queries: http://www.youtube.com/watch?v=SshE8qBG5aA&list=PL083E4EEC22030EAD Sub-Queries,Corelated Queries:
http://www.youtube.com/watch?v=00Vxnod-6iE
ISNULL and Coalese: http://www.youtube.com/watch?v=vi_GdJn1evI
Row number , partition , rank, dense-rank http://www.youtube.com/watch?v=QFj-hZi8MKk