Learn T-SQL With Erik: Derived Tables скачать в хорошем качестве

Learn T-SQL With Erik: Derived Tables

In this video, I dive into the world of T-SQL and specifically focus on derived tables-a topic that often gets overshadowed by Common Table Expressions (CTEs). Derived tables are my go-to method for simplifying complex queries because they can significantly reduce the amount of syntax needed. I explain why derived tables are superior to CTEs, not just in terms of query readability but also in how they can annoy those who zealously advocate for CTEs. The video delves into logical query processing and demonstrates how derived tables can make it easier to handle expressions within the 'SELECT' list without needing to nest queries or rewrite complex expressions multiple times. I illustrate these concepts with practical examples, showing that while derived tables don't alter the physical query plan, they do enhance code hygiene by making queries cleaner and more maintainable. CHAPTERS 00:00:00 - Introduction 00:00:29 - Derived Tables Overview 00:01:29 - Query Processing Explanation 00:02:15 - Pipeline Syntax Critique 00:03:48 - Simplifying Queries with Derived Tables 00:04:55 - Using Derived Tables for Order By 00:06:02 - Query Plan Analysis 00:07:36 - Benefits of Derived Tables 00:08:03 - Summary and Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-... SQL Server Performance Engineering Course https://training.erikdarling.com/sql-... Learn T-SQL with Erik https://training.erikdarling.com/lear... Everything Bundle: https://training.erikdarling.com/?cou... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlc... ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member    / @erikdarlingdata   ━━━━━━━━━━━━━━━━━━━━━━━━━━