Learn To Code Ninja

Free technical booklets — download and learn.

Part 2 of 7 in the Data Engineering with SQL Server path

Advanced T-SQL booklet cover

Advanced T-SQL

DOCX 1.1 MB Advanced Sep 2026

This book is a comprehensive guide to advanced T-SQL programming and SQL Server optimization, designed for database professionals, developers, and architects who want to master complex SQL concepts and best practices for enterprise environments. It goes beyond basic querying to cover performance tuning, security, automation, and governance in both on-premises and cloud deployments.

What you'll learn

  • Executive Summary
  • Advanced Joins and Set Operations in T-SQL
  • Mastering Window Functions in T-SQL
  • Performance Optimization Techniques in T-SQL
Download booklet (DOCX, 1.1 MB)

Table of contents

  1. Executive Summary
  2. Advanced Joins and Set Operations in T-SQL
  3. Mastering Window Functions in T-SQL
  4. Performance Optimization Techniques in T-SQL
  5. Transaction Management and Concurrency Control in T-SQL
  6. Programmability in T-SQL – Stored Procedures, Functions, and Triggers
  7. Security and Governance in SQL Server
  8. Advanced Performance Optimization and Query Tuning in SQL Server
  9. Jobs, Scheduling, and Automation in SQL Server
  10. Security and Governance in Distributed SQL Server Environments
  11. Advanced Troubleshooting and Diagnostics in SQL Server

You may also like

The Enterprise Architects Compendium booklet cover The Enterprise Architects Compendium Mastering Power Query booklet cover Mastering Power Query Master Class On AI Prompting booklet cover Master Class On AI Prompting