Coursera Plus Annual is 40% Off — Ends July 13.

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

Lead AI-Native Products with Microsoft's Agentic AI Program

Learn More → Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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 493 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.