Overview
-
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.
Syllabus
-
Introduction
- Course introduction
- Course agenda
- Tooling
- Introducing the demo database
- Using the code files
- Single data source queries
- Dual source query processing
- Joining multiple source data sets
- Challenge: Hybrid multi-table join
- Solution: Hybrid multi-table join
- Filtering source rows
- Missing information and ternary logic
- Dealing with ternary logic in SQL
- Grouping
- Dealing with NULLs and elimination duplicates
- Group filters
- Challenge: Filtering and grouped query
- Solution: Grouped query with Distinct
- Presentation ordering in multitier architecture
- Ordering result sets
- Paging result sets
- Course review and takeaway
- Feedback and additional resources
