Skip to content
Back to Data Analytics
PricingLog in

Data Analytics

Advanced analytical SQL

Structure multi-step queries and calculate values across related rows.

With Zoonk, your plan starts at this chapter and fits your schedule.

Build my plan

Start free, no account needed.

Where this chapter sits in the course

Lessons

Chapter 20 of 30 · 7 short lessons · 30 min
  1. 1Common table expressions4 min
  2. 2Window aggregates4 min
  3. 3SQL ranking functions4 min
  4. 4SQL lag and lead4 min
  5. 5SQL window frames4 min
  6. 6Latest record per group4 min
  7. 7Challenge: Advanced analytical SQL6 min

What you'll learn

  • Structure multi-step analytical queries
  • Calculate ranks, comparisons, and rolling measures
  • Select records deterministically within groups

Your plan from this chapter

It follows the course from here, at your pace, with reviews before you forget.

Build my plan

Start free, no account needed.