Book

Learn T-SQL Querying

T-SQL is an extension of the SQL language which allows you to tackle advanced querying and query-tuning challenges in SQL Server and Azure SQL Database. This book will be a perfect reference for you to write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis.

Offered by

Difficulty Level

Intermediate

Completion Time

16h8m approx.

Language

English

Certification

Not available

About Course

Book Content

chapters • 16h8m total length

1. Anatomy of a Query

2. Understanding Query Processing

3. Mechanics of the Query Optimizer

4. Exploring Query Execution Plans

5. Writing Elegant T-SQL Query

6. Easily Identified T-SQL Anti-Patterns

7. Discovering T-SQL Anti-Patterns in Depth

8. Building Diagnostic Queries Using DMVs and DMFs

9. Building xEvent Profiler Traces

10. Comparative Analysis of Query Plans

11. Tracking Query Performance History with the Query Store

12. Troubleshooting Live Queries

13. Managing Optimizer Changes With the Query Tuning Assistant

On this page

Ready to Train Your Team?

Need training for your whole team? Get bulk pricing, LMS integration, and dedicated support.

Trusted by Leading Organizations Worldwide

Join thousands of companies that trust Calibr to power their learning and development initiatives.

Request Access For Your Organization

Start training your team in minutes!

Related Resources