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.
Duration 14 hours
Course Outline
Module 1. Optimizing Query Performance
- Tools for Query Optimization
- Cached Query Execution Plans
- Managing the Cache
- Analyzing Execution Plans
- Query Hints
- Utilizing the Database Engine Tuning Advisor
- Tuning Indexes
- Table and Index Architectures
- Index Access Methods
- Indexing Strategies
Module 2. Subqueries, Table Expressions, and Ranking Functions
- Constructing Subqueries
- Applying Table Expressions
- Leveraging Ranking Functions
Module 3. Streamlining Joins and Set Operations
- Core Join Types
- Join Algorithms
- Set Operations
- Utilizing INTO with Set Operations
Module 4. Data Aggregation and Pivoting
- Employing the OVER Clause
- Variations of Aggregation (Cumulative, Sliding, and Year-To-Date)
- Pivoting and Unpivoting Data
- Configuring Custom Aggregations
- Applying the GROUPING SETS Subclause
- CUBE and ROLLUP Subclauses
- Materializing Grouping Sets
Module 5. Leveraging TOP and APPLY
- SELECT TOP
- Using the APPLY Table Operator
- Top N at the Group Level
- Implementing Pagination
Module 6. Enhancing Data Transformation
- Inserting Data via Enhanced VALUES Clause
- Utilizing the BULK Rowset Provider
- Executing 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 Concepts in SQL Server
- Writing Queries on Partitioned Tables
- Writing Queries on Partitioned Views
Requirements
Proficiency in SQL within the Microsoft SQL Server 2008/2012 environment.
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 3200 € + 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
