Transact SQL Advanced Certificate for James Rodi

Analytical Functions

• Use of advanced summary functions
• Use of hierarchical queries
• Use of analytical summary functions, e.g. moving averages, running totals
• Use of ranking functions

Useful Database Objects

• Principles of using indexes
• How to create and maintain an index
• Use of clustered tables
• Use of partitioned tables
• Use of metadata in the master database

Query Performance Tracing

• Principles of query execution and optimisation
• Use of Execution Plan
• Use of table & index statistics
• Use of hints

Basic Data Warehouse Techniques

• Use of Indexed Views
• Use of Dimension & fact tables
• Use of Star & Snowflake designs