Advanced SQL: Logical Query Processing, Part 2
2h 3mAdvanced2020-09-21
Authors
Ami Levin
Data Educator, Speaker, and Practitioner, SQL and RDM enthusiast
Course details
Without an understanding of the underlying concepts behind SQL, developers will encounter a number of challenges that slow down their workflow. This course—the second installment in a series—was designed to help you avoid these common pitfalls and understand SQL's processing limitations. Join instructor Ami Levin as he continues to delve into logical query processing. Learn how expression, table, and row subqueries are processed. Discover self joins, their unique requirements, and when you might use them. Plus, learn how to use lateral joins, recursive WITH clauses, and more.
Skills covered
SQLDatabase AdministrationAdvancedDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Course introduction
- 02 - Agenda
- 03 - Setting expectations
1. Subqueries and Set Operators
- 04 - Subqueries
- 05 - Set operators
- 06 - Challenge
- 07 - Solution
2. Advanced Joins
- 08 - Self and inequality joins
- 09 - Lateral joins
- 10 - Challenge
- 11 - Solution
3. More on Grouping
- 12 - Ordered set functions
- 13 - Grouping sets
- 14 - Challenge
- 15 - Solution
4. Recursions and Cursors
- 16 - Recursions
- 17 - The cursors curse
Conclusion
- 18 - Conclusion
Related courses
- Advanced SQL: Logical Query Processing, Part 1
- Advanced SQL for Data Scientists
- C#: Advanced Practices
- Complete Guide to Oracle Database 23ai: From Beginner to Advanced
- Advanced SQL: Solving Interpolation Challenges
- Advanced SQL for Query Tuning and Performance Optimization (2019)
- Advanced SQL for Data Science: Time Series
- Advanced SQL for Query Tuning and Performance Optimization