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
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → TrainSec Ad

Learn EDR Internals: Research & Development From The Masters

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates 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 495 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.