ViewTube

In this video, I take you through a variety of use cases for window functions, showing how you can solve common (and sometimes ...

In this video (part 1 of a new series), I explain what a window function is, as well as the components of window functions.

In this Databricks video, I covered how to use the Databricks SQL QUALIFY with window functions in SELECT list and in QUALIFY ...

In this video, I walk through four categories of window function, plus a somewhat-related type of function in SQL Server.

This SQL Full Course is a comprehensive guide to learning SQL, covering both beginner and advanced topics. In this 2-hour ...

All JomaClass videos from 2020 are now free to watch. If you enjoy please consider donating here: https://support.joma.io/ This ...

In this video, I show you various techniques you can use to make window functions faster, including proper indexing and usage of ...

In this video, I continue a dive into each category of window function, quickly reviewing the four categories of window function ...

Get my SQL Timezone Cheat Sheet: https://databasestar.mykajabi.com/lpkj-sql-timezone-cheat-sheet?video=6v6Y7ntKt_U ...

All JomaClass videos from 2020 are now free to watch. If you enjoy please consider donating here: https://support.joma.io/ This ...

In this step-by-step SQL tutorial, I'll guide you through writing 100 SQL queries based on real business scenarios to help you ...

In this video, I take you through some of the limitations of window functions in SQL Server, including the lack of intervals and ...

In this step-by-step SQL tutorial, I'll guide you through writing 100 SQL queries based on real business scenarios to help you ...

MENTORSHIP – Applications for the March 2026 cohort are now open! Apply here → https://theanalyticsaccelerator.com/ 2026 ...

Date functions in SQL are used to handle and manipulate date and time data. Common functions include `GETDATE()` or ...

Get started: https://cnfl.io/apache-flink-sql-module-1 | Apache Flink® SQL makes it easy to implement analytics that summarize ...

In this step-by-step SQL tutorial, I'll guide you through writing 100 SQL queries based on real business scenarios to help you ...

In this step-by-step SQL tutorial, I'll guide you through writing 100 SQL queries based on real business scenarios to help you ...

The `COUNT`, `SUM`, `AVG`, `MIN`, and `MAX` functions in SQL are aggregate functions used to perform calculations on a set of ...

String functions in SQL are used to manipulate and process text data in queries. Common functions include `CONCAT()` for ...