This SQL Server Query Tuning (Performance Tuning) course 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 | |
---|---|---|
Description | Query Tuning | SQL Server, T-SQL, Query Tuning |
Applicable For | Experienced Dev | Starters, Experienced |
Course Duration | 1.5 Week | 4.5 Weeks |
SQL Server, DB Architecture | ![]() |
![]() |
Query Architecture, Client Stats | ![]() |
![]() |
Basic to Adv. Query Design, Joins | ![]() |
![]() |
Basic to Adv. Stored Procedures | ![]() |
![]() |
New Features: SQL 2017, 2019 | ![]() |
![]() |
Real-time Project with Solution | ![]() |
![]() |
Query Tuning & Execution Plans | ![]() |
![]() |
Partitions, Locks and Isolations | ![]() |
![]() |
Temporal Tables and Memory Tables | ![]() |
![]() |
Query Statistics, LIVE & Client Statistics | ![]() |
![]() |
Execution Plan Analsyts, Query Costs | ![]() |
![]() |
Tuning Tools : DTA, Profiler, Perfmon | ![]() |
![]() |
XEL Files, Extended Events, Logs | ![]() |
![]() |
Index Management | ![]() |
![]() |
Statistics Management | ![]() |
![]() |
Resource Optimization | ![]() |
![]() |
DOP and Resource Governor | ![]() |
![]() |
MCSA 70-761 Certification | ![]() |
![]() |
Total Course Fee* | INR 5000/- USD 68 |
INR 10000/-USD 136 |
Azure SQL Database - TRAINING HIGHLIGHTS :
✔ In-depth Tuning | ✔ In-Memory Data |
✔ Schema Migrations | ✔ DB Documenation |
✔ Memory Tables | ✔ Temporal Tables |
✔ Execution Plans | ✔ XEL Graphs, DTA |
✔ Query Costs | ✔ Statistics Management |
Module I: SQL Queries & T-SQL ProgrammingApplicable for Plans A, B, C |
||
Video 1: SQL SERVER INTRODUCTION
|
Video 7: JOINS, T-SQL Queries : Level 1
|
Video 13: STORED PROCEDURES Level 2
|
Video 2: SQL SERVER INSTALLATIONS
|
Video 8: Group By, T-SQL Queries Level 2
|
Video 14: STORED PROCEDURES - Level 3
|
Video 3: SSMS Tool, SQL BASICS - 1
|
Video 9: JOINS, T-SQL QUERIES Level 3
|
Video 15: XML,BLOB,FUNCTIONS Level 2
|
Video 4: SQL BASICS - 2
|
Video 10: View, SPs, Function Basics
|
Video 16: Server, DB Architecture
|
Video 5: SQL Basics - 3, T-SQL INTRO
|
Video 11: Triggers & Transactions
|
Video 17 - 20: REAL-TIME PROJECT (BANKING) Includes 2500 Lines of Code (COMPLETELY SOLVED). Phase 1: DATABASE DESIGN
Phase 2: QUERY DESIGN
Phase 3: PROGRAMMING
Project Solution Explanation Resume Points from the Project Interview FAQs from Project |
Video 6 : CONSTRAINTS,INDEXES BASICS
|
Video 12 : ER MODELS, NORMAL FORMS
|
|
Real-time Case Study - 1 (Sales & Retail)
Objective : DB Design, Table Design, Relations Involves Purchases, Products, Customers and Time Data with Various Data Types. |
Real-time Case Study - 2 (Sales & Retail)
Objective : Query Writing, Excel Integration Excel Pivot Tables, Pivot Charts, Data Formatting, ODC Connections & Labelling |
Module II: Performance Tuning & MCSA - 70 761Applicable for Plans B, C |
Module II: Performance Tuning & MCSA - 70 761Applicable for Plans B, C< |
Video 21: QUERY TUNING 1 - AUDITS, INDEXES
|
Video 23: QUERY TUNING 3 - TUNING TOOLS, LOCK MANAGEMENT
|
Video 22: QUERY TUNING 2 - PARTITIONS, INDEX MANAGEMENT
|
Video 24: QUERY TUNING 4 - FULL TEXT SEARCH, MOT TABLES
|
Video 25 : MCSA 70 761 Exam Pattern, Examples, Guidance |
Above Course Curriculum is applicable for registrations from July 6th, 2019