BloomTech’s Downfall: A Long Time Coming

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

Go to class Write review

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
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.9 rating at LinkedIn Learning based on 174 ratings

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

Go to class

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.