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
Language
English
About Book
Who Is This Book For?
This book is for database administrators, database developers, data analysts, data scientists, and T-SQL practitioners who want to get started with writing T-SQL code and troubleshooting query performance issues with the help of practical examples. Previous knowledge of T-SQL querying is not required to get started with this book.
Learn T-SQL Querying
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 16h8m total length
Anatomy of a Query
Understanding Query Processing
Mechanics of the Query Optimizer
Exploring Query Execution Plans
Writing Elegant T-SQL Query
Easily Identified T-SQL Anti-Patterns
Discovering T-SQL Anti-Patterns in Depth
Building Diagnostic Queries Using DMVs and DMFs
Building xEvent Profiler Traces
Comparative Analysis of Query Plans
Tracking Query Performance History with the Query Store
Troubleshooting Live Queries
Managing Optimizer Changes With the Query Tuning Assistant
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!