EssentialSQL: SQL Window Functions for Business Analytics

SQL Window Functions for SQL Server, MySQL, SQLite & PostgreSQL, for Data Analysis, Business Analytics and Intelligence

Created by: Kris Wenzel
Let me teach you SQL using simple to understand English.

Created by: Essential Sql
Learn everything you need to use SQL in your next project

What Will I Learn?

• Learn how to incorporate window functions into your SQL queries.
• Understand how partitions and windows work together within a query.
• Apply window functions so you can avoid using cursors in your SQL.
• Understand the difference between window function mechanics and GROUB BY summaries.
• Create complex queries involving joins using window functions.
• Apply aggregate, analytic, and ranking functions to perform common business tasks such as calculating running totals or comparing one row’s value to the next.
• Create queries using either MySQL, PostgreSQL, or SQL Server.

Requirements

• You should already be familiar with SELECT, GROUP BY, and ORDER BY clauses
• Knowledge of joins and subqueries isn't required, but recommended.
• If you can write a simple GROUP BY statement with HAVING, then you are ready for this course.
• No special equipment needed, all exercises are done online.
• Optional: Install a MySQL, PostgreSQL, or SQL Server learning lab on your own computer.

Target audience

• Advanced Beginner to Intermediate SQL query authors curious about window functions.
• If you're having a hard time understanding the ins and outs of window functions, then this course is for you as I explain it to you in simple to understand English.
• Business analysts looking more ways to write queries.
• Data Engineers needing more tools to deal with dirty data, such as an easy means to deduplicate incoming rows.
• Recent college graduates looking to hone their SQL skills.
• Job applicants looking for that extra edge with their next interview!