How Duolingo Plans to Reach 100M Users

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Advanced SQL: Logical Query Processing, Part 2

via LinkedIn Learning

Write review
Simplilearn Ad

Earn a Michigan Engineering AI Certificate — Stay Ahead of the AI Revolution

Learn More → Corporate Finance Institute Ad

Learn Excel & Financial Modeling the Way Finance Teams Actually Use Them

Learn More →

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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
1. Subqueries and Set Operators
  • Subqueries
  • Set operators
  • Challenge
  • Solution
2. Advanced Joins
  • Self and inequality joins
  • Lateral joins
  • Challenge
  • Solution
3. More on Grouping
  • Ordered set functions
  • Grouping sets
  • Challenge
  • Solution
4. Recursions and Cursors
  • Recursions
  • The cursors curse
Conclusion
  • Conclusion

Taught by

Ami Levin

Reviews

4.8 rating at LinkedIn Learning based on 427 ratings

Start your review of Advanced SQL: Logical Query Processing, Part 2

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.