Course Outline
Module 1. Query Tuning
- Query Tuning Tools
- Cached Query Execution Plans
- Clearing the Cache
- Analyzing Execution Plans
- Query Hints
- Utilizing the Database Engine Tuning Advisor
- Index Optimization
- Table and Index Architectures
- Index Access Strategies
- Indexing Methodologies
Module 2. Subqueries, Table Expressions, and Ranking Functions
- Constructing Subqueries
- Implementing Table Expressions
- Applying Ranking Functions
Module 3. Optimizing Joins and Set Operations
- Core Join Types
- Join Algorithms
- Set-Based Operations
- Incorporating INTO with Set Operations
Module 4. Data Aggregation and Pivoting
- Utilizing the OVER Clause
- Various Aggregation Types (Cumulative, Sliding, and Year-To-Date)
- Pivoting and Unpivoting Data
- Configuring Custom Aggregations
- Employing the GROUPING SETS Subclause
- CUBE and ROLLUP Subclauses
- Materializing Grouping Sets
Module 5. Leveraging TOP and APPLY
- SELECT TOP
- Using the APPLY Table Operator
- Applying TOP n at the Group Level
- Implementing Pagination
Module 6. Optimizing Data Transformation
- Inserting Data via Enhanced VALUES Clauses
- Leveraging the BULK Rowset Provider
- Executing INSERT EXEC
- Sequence Mechanisms
- Performing DELETE with Joins
- Executing UPDATE with Joins
- The MERGE Statement
- Using the OUTPUT Clause with INSERT
- Using the OUTPUT Clause with DELETE
- Using the OUTPUT Clause with UPDATE
- Using the OUTPUT Clause with MERGE
Module 7. Querying Partitioned Tables
- Partitioning Concepts in SQL Server
- Formulating Queries for Partitioned Tables
- Formulating Queries for Partitioned Views
Requirements
A solid command of SQL within the Microsoft SQL Server 2008/2012 environment is required.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (4)
data was personalised to our organisations
Vincent Long - ASSMANG PTY LTD
Course - T-SQL Fundamentals with SQL Server Training Course
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The instructor brought his A game again as he superbly took my staff through the customized training with expert timing, knowledge, support, and rapport with my staff.
James - Shawnee Mission School District
Course - Administering in Microsoft SQL Server
The lecture about cte
