This SQL Server Performance Tuning From SQL School includes In-depth Query Tuning and Troubleshooting concepts in SQL Server 2019, 2017, 2016 including Histograms, XEL Files, In-Memory Tables, Temporal Tables, IO Costs, CPU Costs, Opertor Costs, Execution Plan Analysis and DOP Settings with Resource Groups & Workload Groups. Memory Optimization Techniques, CPU Utilization and IO Monitoring Processes, Query Audits with Dynamic Management Views (DMVs), Dynamic Management Functions (DMFs), Procedure Cache are included in this course. This SQL Server Performance Tuning also includes a Real-time CaseStudy that helps you to understand master Query Analytical skills with Workload Analysis, Peak - Hour metrics, Understanding various levels of Query Statistics, Index Management Techniques. Register Today for Free Demo
PLAN A | PLAN B | PLAN C | |
---|---|---|---|
Applicable For | Azure SQL Dev | SQL Dev + Azure Dev |
SQL Dev + Azure Dev + Power BI |
Course Duration | 2 Weeks | 6 Weeks | 10 Weeks |
Course Content | Chapters 21 to 30 | Chapters 1 to 30 | Chapters 1 to 48 |
Completely Real-time, Practical | ✔ | ✔ | ✔ |
Mock Interviews, Case Studies | ✔ | ✔ | ✔ |
In-depth Query Tuning | ✔ | ✔ | ✔ |
Performance Tools, Locks | ✔ | ✔ | ✔ |
Complex SPs, MCSA - 70 761 | ✔ | ✔ | ✔ |
Azure SQL Database (Cloud) | ✔ | ✔ | ✔ |
Azure SQL Database Migrations | ✔ | ✔ | ✔ |
Stretch Databases, MCSA 70-762 | ✔ | ✔ | ✔ |
SQL Basics and Query Writing | ❌ | ✔ | ✔ |
SQL DB Design, Table Design | ❌ | ✔ | ✔ |
Normal Forms, Joins, Queries | ❌ | ✔ | ✔ |
Indexes, Stored Procedures | ❌ | ✔ | ✔ |
Excel Integration, Pivot Charts | ❌ | ✔ | ✔ |
Advanced Stored Procedures | ❌ | ✔ | ✔ |
CTE, PIVOT, XML and BLOB Data | ❌ | ✔ | ✔ |
Real-time Project [Banking] | ❌ | ✔ | ✔ |
Power BI: Report Design, Visuals | ❌ | ❌ | ✔ |
Power BI: M Lang, DX for ETL | ❌ | ❌ | ✔ |
Power BI: Report Server, Admin | ❌ | ❌ | ✔ |
Total Course Fee* | INR 8000 USD 109 |
INR 13000 USD 176 |
INR 21000 USD 284 |
Query Tuning & Azure SQL Training Highlights
✔ In-depth Tuning | ✔ HA - DR Issues |
✔ Queries, Joins | ✔ Dynamic SQL |
✔ Query Tuning | ✔ CTEs, TVPs |
✔ Excel Imports | ✔ In-Memory Tables |
✔ Excel Pivot Charts | ✔ Azure SQL Migration |
✔ Complex joins | ✔ Azure Elastic Queries |
✔ Linked Servers | ✔ Azure DB Tuning |
All Session Are Completely Practical & Real Time