Course with Evita
Evita — SQL Window Functions for Analyst Interviews
SQL window functions for analysts who still export to Excel, marked 1:1 against a real orders and customers schema. Five sessions on partitions, frames, rank versus dense rank and lag, ending when you answer eight interview questions in under ten minutes each.
What you’ll master — Outcomes you can use
- I answer eight interview-style questions in under ten minutes each with no Excel workaround
Your tutor
An analytics lead who has interviewed hundreds of analysts and can tell from one query who understands frames.
Brisk · Precise about vocabulary
Questions about this course
How do I write SQL window functions for running totals and rank?
SQL window functions for analysts who still export to Excel, marked 1:1 against a real orders and customers schema. Five sessions on partitions, frames, rank versus dense rank and lag, ending when you answer eight interview questions in under ten minutes each.