Duration of training：
1 day (split into 2 sessions of 3 hours each)
Training content:
Session 1
Analytical Functions (1 hour)
Use of 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 and other window functions
Useful Database Objects part 1 (1 hour)
Principles of using indexes
How to create and maintain an index
Use of clustered tables
Lab & practice (1 hour)
SQL Query with advanced features
Performance tuning with Index and Join for SQL Query
Session 2
Useful Database Objects part 2(1 hour)
Use of indexed views
Use of partitioned tables
Use of metadata in the master database(DMV)
Query Store
Query Performance Tracing (1 hour)
Principles of query execution and optimization
Use of SQL Profiler
Use of Database Tuning Advisor
Use of Execution Plan
Use of table & index statistics
Use of hints
Lab & practice (1 hour)
Find slow queries with Query store and DMV
Performance tuning with Hints for SQL Query
Database design introduction (Optional)
Database design(3NF)
Data warehouse design(star schema & snowflake, data vault)