From the course: Advanced SQL: Logical Query Processing, Part 2
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Conclusion - SQL Tutorial
From the course: Advanced SQL: Logical Query Processing, Part 2
Conclusion
- [Instructor] Oh, wow, another chapter of our SQL adventure is ending. We learned about subquery processing and the extremely powerful set operators. Don't worry too much about the subtleties of all versus distinct. You'll likely only use these for unions, which is what most databases support anyway. We learned how and when to join tables to themselves, how to use non-equality join qualification predicates, and how lateral joins are processed. I hope you enjoyed the challenge of finding breeding candidates and I kindly ask you again to consider donating to your local animal shelter. We learned how to use grouping sets, and I can tell you, I was blown away by it when I first learned about this feature. I hope you are, too. Many of you will use the string ordered set functions and don't worry if the hypothetical and inverse distribution ones aren't fully clear yet. It takes some time and practice. We moved on to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.