Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Advanced SQL Series: Window Functions

Course Summary

The Advanced SQL Series: Window Functions training course is designed to demonstrate how to systematically approach solving tough challenges in SQL.

The course begins with a quick review of query processing and a look at the OVER clause. Next, it explains how window functions 'break' the processing model. The course concludes with a deep dive into aggregate window functions, ranking window functions, offset window functions and analytical window functions.

Purpose
 Empower students with the knowledge and skills for how to systematically approach solving tough challenges in SQL.
Audience
 Experienced SQL developers who want to take their skills to a new level. Data analysts and data scientists who are often stumped with challenges that seem too hard to solve in SQL.
Role
Business Analyst - Data Engineer - Data Scientist - Software Developer - Web Developer
Skill Level
Advanced
Style
Workshops
Duration
2 Days
Related Technologies
SQL

 

Productivity Objectives
  • Describe window functions and how window functions are processed
  • Explain how to use window functions to solve SQL challenges
  • Write queries using window functions
  • Approach SQL challenges with a proven, easy methodology
  • Improve performance, readability, and scalability of your SQL queries

What You'll Learn:

In the Advanced SQL Series: Window Functions training course, you'll learn:
  • Query Processing review
    • How SQL engines evaluate and process your queries logically
    • The order of execution for the various clauses
    • How intermediate data is moved between them
    • Why this is important
  • The OVER clause
    • ORDER BY
    • PARTITION BY
    • FILTER
    • ROWS and RANGE
  • How window functions 'break' the processing model
    • Logical processing order
    • Where are window functions allowed, and why
  • Aggregate window functions
    • How GROUP BY query lose the original detailed values
    • SUM, COUNT, MIN, MAX and AVG
  • Ranking window functions
    • RANK, DENSE_RANK, ROW_NUMBER, NTILE
  • Offset window functions
    • LEAD, LAG, and NTH_VALUE
  • Analytical window functions
    • CUME_DIST, PERCENTILE_CONT, PERCENTILE_DISC, PERCENT_RANK
real world content

Real-World Content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.
expert practitioners

Expert Practitioners

Industry experts that bring their battle scars into the classroom.
experiential learning

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.
tailored outlines

Tailored Outlines

One-size-fits-all doesn't apply to training teams. That's where we come in!
“I appreciated the instructor's technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware

Dive in and learn more

When transforming your workforce, it's important to have expert advice and tailored solutions. We can help. Tell us your unique needs and we'll explore ways to address them.

Let's chat

By filling out this form and clicking submit, you acknowledge our privacy policy.