Welcome. In this course, we're going to talk about window functions.

What are window functions? They make building complex aggregations much simpler. They are so powerful that they serve as a dividing point in time: people talk about SQL before window functions and SQL after window functions. After window functions and Common Table Expressions were introduced to SQL, SQL has become Turing complete!

This course is designed for beginning database analysts, developers who want to keep their knowledge of SQL current, students taking classes in relational databases and anyone who wants to learn SQL window functions. Do keep in mind, however, that this course in not intended for complete SQL beginners. We assume you already know how to:

• query a single table,
• query multiple tables with JOIN data from multiple tables,
• sort and group rows,
• and use the HAVING statement.

If you have not written a single SQL query before, we recommend that you go through another course first: SQL Basics.