SQL Server Query Tuning & Optimization (Class Recordings)

Recording duration: 28 hours
On-demand lifetime streaming access


Friendly TitleSQL Server Query Tuning & Optimization
Class TitleSQL Server Query Tuning & Optimization
TrainerAmit Bansal
PriceRegular Price USD 799
Want discounts?
Use HAPPY60 discount code to get 60% off. New price: USD 319.
(apply the coupon code in the cart)

* GST + Internet Transaction Fee additional

* Group discounts available (write to classes@SQLMaestros.com)

* Prices are subject to change without prior notice

AccessOn-demand lifetime streaming access
LevelIntermediate to Advanced (Level 200 to 300)
Pre-requisitesAt least two years of genuine working experience with SQL Server
Key Highlights
  • On-demand lifetime streaming access.
  • Most critical topics covered.
  • 28 hours of deep practical content.
  • True level 200-300 content.
  • Gain real-world knowledge, get real-world exposure.
  • Get your own copy of SQLMaestros course material + Scripts.
  • Packed with real-world demos and examples.
  • Apply your learning into production right away.
  • Practice Labs/Demos at your own pace
Course Outline
  1. SQL Server Execution Engine
  2. Query Lifecycle
  3. Plan Cache Internals
  4. Query Optimizer & Execution Plan
  5. Better TSQL – Query Tuning Fundamentals
  6. Better TSQL – Fixing Implicit Conversion
  7. Better TSQL – Sargability
  8. Better TSQL – Rewriting Subqueries
  9. Better TSQL – OVER clause
  10. Better TSQL – Temp Tables vs Table Variables
  11. Better TSQL – Working with NULLs
  12. Better TSQL – Common Table Expression
  13. Better TSQL – Rewriting Scalar UDFs
  14. Better TSQL – TVFs Basics
  15. Better TSQL – TVFs with APPLY
  16. Better TSQL – Ranking Functions
  17. Better TSQL – Dealing with SORTs
  18. Better TSQL – Optimizing OR
  19. Better TSQL – Fixing Bookmark Lookups
  20. Better TSQL – Cardinality Fix
  21. Better TSQL – Pivoting
  22. Better TSQL – Stats
  23. Better TSQL – Aggregations
  24. Better TSQL – Joins
  25. Better TSQL – NOLOCK
  26. Better TSQL – INEQUALITY
  27. Better TSQL – Complex Expressions
  28. Better TSQL – Fuzzy String Matching
  29. Better TSQL – Things you may not know
  30. Index Tuning – Index Basics
  31. Index Tuning – Page Splits
  32. Index Tuning – Fragmentation
  33. Index Tuning – Dynamic Index Seek
  34. Index Tuning – Index Union
  35. Index Tuning – Index Intersection
  36. Index Tuning – Fragmentation Part 2
  37. Index Tuning – Indexing for AND & OR
  38. Index Tuning – Index Aggregates
  39. Index Tuning – Indexing for Joins
  40. Index Tuning – SARGability
  41. Index Tuning – Multi Column Seek
  42. Index Tuning – Multi Column Indexes
  43. Index Tuning – Missing and Unused Indexes
  44. Index Tuning – Redundant Indexes
  45. Index Tuning – Clustering Key Choices
  46. Stored Procedures – Parameter Sniffing
  47. Dynamic SQL
  48. Waits and Queues – Introduction
  49. Waits and Queues – PAGEIOLATCH
  50. Waits and Queues – CXPACKET and PARALLELISM
  51. Waits and Queues – RESOURCE SEMAPHORE
  52. Waits and Queues – THREADPOOL
  53. Waits and Queues – BUFFERLATCH
  54. Waits and Queues – SOS_SCHEDULER_YIELD
  55. Concurrency
  56. Deadlocks
  57. Waits and Queues – EXTENDED Events
  58. Automatic Tuning
  59. Intelligent Query Processing – Adaptive Joins
  60. Intelligent Query Processing – Batch Mode On Row Store
  61. Intelligent Query Processing – Interleaved Execution
  62. Intelligent Query Processing – Memory Grant Feedback
  63. Intelligent Query Processing – Scalar UDF Lining
  64. Intelligent Query Processing – Table Variable Deferred Compilation
Sample Content
Trainer’s BioAmit R S Bansal is a SQL Server Specialist at SQLMaestros (brand of eDominer Systems). He leads the SQL and BI practice with a much-focused team providing consulting, training and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences including Data Platform Summit, MS Ignite (US), SQLBits (UK), PASS Summit (US) & SQL Saturday events across the globe. Amit is also honored with Microsoft Regional Director status, MVP award and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. His videos are available on YouTube. To learn more about Amit, Click Here
SQLMaestros Contact Detailsclasses@SQLMaestros.com
FAQClick Here
TestimonialsClick Here