Advanced SQL: Logical Query Processing, Part 1

Gain a deep understanding of how the database processes SQL queries, improve your programming skills, and learn to effortlessly read, write, and troubleshoot SQL queries.

Introduction

• Course introduction
• Course agenda
• Tooling
• Introducing the demo database
• Using the code files

1. Constructing Query Source Data Sets

• Single data source queries
• Dual source query processing
• Joining multiple source data sets
• Challenge: Hybrid multi-table join
• Solution: Hybrid multi-table join

2. Row Filters

• Filtering source rows
• Missing information and ternary logic
• Dealing with ternary logic in SQL

3. Grouping

• Grouping
• Dealing with NULLs and elimination duplicates
• Group filters
• Challenge: Filtering and grouped query
• Solution: Grouped query with Distinct

4. Ordering and Paging

• Presentation ordering in multitier architecture
• Ordering result sets
• Paging result sets

Conclusion

• Course review and takeaway
• Feedback and additional resources