Advanced SQL: Logical Query Processing, Part 2
Offered By: LinkedIn Learning
Course Description
Overview
Take your SQL skills to the next level. Continue learning about aspects of logical query processing: from subqueries to ordered set functions, and from lateral joins to cursors.
Syllabus
Introduction
- Course introduction
- Agenda
- Setting expectations
- Subqueries
- Set operators
- Challenge
- Solution
- Self and inequality joins
- Lateral joins
- Challenge
- Solution
- Ordered set functions
- Grouping sets
- Challenge
- Solution
- Recursions
- The cursors curse
- Conclusion
Taught by
Ami Levin
Related Courses
Introduction to DatabasesMeta via Coursera Web Development
Udacity Introduction to Data Science
University of Washington via Coursera Datenmanagement mit SQL
openHPI Sabermetrics 101: Introduction to Baseball Analytics
Boston University via edX