Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Module 1. Query Tuning
- Query Tuning Tools
- Cached Query Execution Plans
- Clearing the Cache
- Analyzing Execution Plans
- Hints
- Utilizing the Database Engine Tuning Advisor
- Index Tuning
- Table and Index Structures
- Index Access Methods
- Indexing Strategies
Module 2. Subqueries, Table Expressions, and Ranking Functions
- Writing Subqueries
- Using Table Expressions
- Using Ranking Functions
Module 3. Optimizing Joins and Set Operations
- Fundamental Join Types
- Join Algorithms
- Set Operations
- Using INTO with Set Operations
Module 4. Aggregating and Pivoting Data
- Using the OVER Clause
- Varieties of Aggregations (Cumulative, Sliding, and Year-To-Date)
- Pivoting and Unpivoting
- Configuring Custom Aggregations
- Utilizing GROUPING SETS Subclause
- CUBE and ROLLUP Subclauses
- Materializing Grouping Sets
Module 5. Using TOP and APPLY
- SELECT TOP
- Employing the APPLY table operator
- TOP n at the Group Level
- Implementing Paging
Module 6. Optimizing Data Transformation
- Inserting Data with Enhanced VALUES Clause
- Using the BULK Rowset Provider
- Using INSERT EXEC
- Sequence Mechanisms
- DELETE with Joins
- UPDATE with Joins
- MERGE Statement
- OUTPUT Clause with INSERT
- OUTPUT Clause with DELETE
- OUTPUT Clause with UPDATE
- OUTPUT Clause with MERGE
Module 7. Querying Partitioned Tables
- Partitioning in SQL Server
- Writing Queries on Partitioned Tables
- Writing Queries on Partitioned Views
Requirements
A solid understanding of SQL in the Microsoft SQL Server 2008/2012 environment is required.
14 Hours
Testimonials (3)
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
Being human and talking to us as understandable possible
Sorin
Course - Database Administration Fundamentals for MS SQL Server
Lot of content and exactly the requested one.
