From the course: Advanced SQL – Window Functions
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Review, conclusion, and next steps - SQL Tutorial
From the course: Advanced SQL – Window Functions
Review, conclusion, and next steps
- [Instructor] And so here we are, at the end of our short but intense journey. I can't believe we started it just two hours ago. Our first step was an introduction to the general concepts of Window Functions and the OVER Clause. We learned about partitioning, Framing subtleties, and frame Exclusions. Then, we covered the three types of Window Functions in-depth. We saw how Aggregate Window Functions differ from group aggregate functions, the one you know and love, and how both can live together in harmony. I bet that the Rank and Distribution Functions blew the minds of the analysts among you. For you developers, I promise that you will learn to appreciate how useful they are for solving numerous types of challenges as you get comfortable with them, and the same is true for Offset Window Functions. They too, have numerous use cases and will come in handy no matter what type of obligations you're working on. If…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.