sql to study

Basics:
 
·       Understanding of concepts like Tuning Methodology
·       SQL Statement Processing,
·       SHOWPLAN,
·       Introduction to the Optimizer
·       Indexes and Basic Access Methods,
·       GatheringStatistics,
·       Optimizer Hints,
·       Monitoring queries,
·       Optimizing queries
 
Adv SQL:
 
·       COMPUTE Clause,
·       Advanced INSERT,
·       Transact-SQL conditions and expressions
·       Dealing with collation sequences