ViewTube

Reason about the sorts and partitions a window function requires, on real PostgreSQL 16 plans. On the module's 11-row sales ...

Compute cumulative metrics with ordered windows. On a real PostgreSQL 16 database with the module's sales table, ...

Does it matter whether you write a subquery, a join or a CTE? On real PostgreSQL 16 plans over 20000 generated customers and ...

Your frontend can be rewritten. Your API can be rewritten. Your data is forever. In this video we open the box under every app ...

Control which rows each window sees, and in what order. On a real PostgreSQL 16 database with the module's 11-row sales ...

Find missing values the right way. On real PostgreSQL 16 we put = NULL and IS NULL side by side and watch one return ...

Why does 1 / 8 return 0 in SQL? On real PostgreSQL 16 we convert values with CAST and PostgreSQL's :: shorthand, see which ...

Explain the three join algorithms and when an optimizer picks each. We trace a nested loop, a hash join and a merge join by hand ...

Turn a group of rows into one readable list. On real PostgreSQL 16 we build a list of customers per city with STRING_AGG, see ...

Group consecutive runs with the row-number difference technique. On a real PostgreSQL 16 database with a small logins table, ...

Get detail rows, subtotals and a grand total from one query. On real PostgreSQL 16 we build a total row the long way with UNION ...

Window functions compute a value over a set of rows and return it on every row, instead of collapsing the rows like GROUP BY.

The date and time essentials every SQL query needs. On real PostgreSQL 16 we meet the four types (DATE, TIMESTAMP, ...

Find the typical value when the average lies. On real PostgreSQL 16 we compute a median with PERCENTILE_CONT(0.5) ...

Fetch boundary values in a window correctly. On a real PostgreSQL 16 database with the module's 11-row sales table, ...

Define exact window frames and predict the default frame's surprises. On a real PostgreSQL 16 database with the module's ...

Learn to build a React dashboard from scratch in this full stack project. We will focus on implementing search, sort, and pagination ...

A login at 10:30 pm in New York counted on the wrong day, months sorted April before January, and a dashboard filter that scans ...

One pass over the table, many answers. On real PostgreSQL 16 we put a CASE inside SUM to total paid and refunded orders per ...

Pick the ranking function whose tie behaviour matches the requirement. On a real PostgreSQL 16 database with the module's ...