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

AI, Data Science & Cloud Certificates from Google, IBM & Meta

Learn More → DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.