EssentialSQL: SQL Window Functions for Business Analytics
SQL Window Functions for SQL Server, MySQL, SQLite & PostgreSQL, for Data Analysis, Business Analytics and Intelligence
4.49 (104 reviews)
517
students
3.5 hours
content
Feb 2024
last update
$54.99
regular price
What you will 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.
Loading charts...
Related Topics
4987158
udemy ID
20/11/2022
course created date
24/02/2023
course indexed date
kokku
course submited by