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 | Query Tuning | Query Tuning + Azure SQL |
SQL Dev + Query Tuning + Azure SQL |
No of Videos | 5 Videos | 10 Videos | 30 Videos |
Completely Real-time, Practical | ✔ | ✔ | ✔ |
Mock Interviews, Case Studies | ✔ | ✔ | ✔ |
In-depth Query Tuning | ✔ | ✔ | ✔ |
Performance Tools, Locks | ✔ | ✔ | ✔ |
Complex SPs in T-SQL | ✔ | ✔ | ✔ |
Azure SQL Database (Cloud) | ❌ | ✔ | ✔ |
Azure SQL Database Migrations | ❌ | ✔ | ✔ |
Stretch Databases | ❌ | ✔ | ✔ |
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] | ❌ | ✔ | ✔ |
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
Register Now for Performance Tuning Selfpaced Learning
Ch 1: DATABASE INTRODUCTION
|
Ch 7: JOINS & LINKED SERVERS
|
Ch 13: STORED PROCEDURES & TVP
|
Ch 2: SQL SERVER INSTALLATIONS
|
Ch 8: VIEW, SPs, FUNCTIONS BASICS
|
Ch 14: STORED PROCEDURES & Triggers
|
Ch 3: SSMS Tool, SQL BASICS - 1
|
Ch 9: Triggers & Transactions
|
Ch 15: STORED PROCEDURES & Cursors
|
Ch 4: SQL BASICS - 2
|
Ch 10: DB Architecture & Group By
|
Ch 16: STORED PROCEDURES & CTEs
|
Ch 5: SQL Basics - 3, T-SQL INTRO
|
Ch 11: TSQL Queries: Group By, Joins
|
Ch 17: FUNCTIONS Level 2, XML & JSON
|
Ch 6 : CONSTRAINTS, INDEXES
|
Ch 12 : ER MODELS, NORMAL FORMS
|
Ch 18 - 20: REAL-TIME PROJECT (BANKING) Includes 2500 Lines of Code (SOLVED). Phase 1: DATABASE DESIGN
|
Case Study 1 - For Database, Table Design (Constraints, Keys) |
Case Study 2 - For Query Writing + Window Functions (Rank, RowNumber) |
Module II: Performance TuningApplicable for Plans B, C |
Module III: Azure SQL Database DevelopmentApplicable for Plan C |
Ch 21: Tuning 1 - Audits, Indexes
|
Ch 26: CLOUD, AZURE CONFIG
|
Ch 22: Tuning 2: Index Management
|
Ch 27: AZURE SQL SERVER CONFIG
|
Ch 23: Tuning 3 - Tuning Tools
|
Ch 28: ELASTIC DTUs, DB MIGRATION
|
Ch 24: Tuning 4 - Lock Management
|
Ch 29: AZURE SQL DATABASE TUNING
|
Ch 25: FULL TEXT SEARCH, MOT
|
Ch 30: Real-time Project - 2
|