Duration:
2 Days
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