English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 40m | 286 MB
SQL has been the dominant data processing language for the past five decades. This course takes you beyond the syntax fundamentals, and into a new world of understanding how relational database management systems process SQL queries, and how that impacts your coding practices. Learn about logical query processing, and avoid most common pitfalls and processing limitations. Discover advanced JOIN techniques and how to deal with missing data. Understand the subtleties of ternary logic, SELECT expression evaluation, grouping logic, and how to implement efficient paging and ordering. By the end of the course, you’ll be able to take advantage of the nuances of logical query processing to easily troubleshoot and solve daunting SQL challenges elegantly and efficiently.
Topics include:
- Query logical processing order
- Advanced join processing
- Filtering rows with ternary logic predicates
- Grouping and aggregating data efficiently
- Advanced group filtering
- Ordering and paging result cursors
Table of Contents
Introduction
1 Course introduction
2 Course agenda
3 Tooling
4 Introducing the demo database
5 Using the code files
Constructing Query Source Data Sets
6 Single data source queries
7 Dual source query processing
8 Joining multiple source data sets
9 Challenge Hybrid multi-table join
10 Solution Hybrid multi-table join
Row Filters
11 Filtering source rows
12 Missing information and ternary logic
13 Dealing with ternary logic in SQL
Grouping
14 Grouping
15 Dealing with NULLs and elimination duplicates
16 Group filters
17 Challenge Filtering and grouped query
18 Solution Grouped query with Distinct
Ordering and Paging
19 Presentation ordering in multitier architecture
20 Ordering result sets
21 Paging result sets
Conclusion
22 Course review and takeaway
23 Feedback and additional resources
Resolve the captcha to access the links!