Working with data in SQL.
Order by in aggregates, better string concatenation, and thorough date formatting.
Learn the basics of FerretDB - a drop-in replacement for MongoDB that uses PostgreSQL or SQLite as a backend.
Inserting and updating data with a single query.
The many faces of JOIN in SQL.
Seriously, I don't. I'd prefer SQL.
Allows executing queries without touching the table.
Calculate the difference between each record and the previous or next one.
According to the standard, we should use be using FETCH.
Assigning each record to a specific segment based on the value of one or more columns.
For those who knew SQL, but kinda forgot it.
Assigning a rank to each row based on the value of one or more columns.
Moving averages, cumulative totals and other sliding aggregates.
Comparing individual values with totals and averages.
Turn static SQL code in your articles into executable examples.
Comparing records with neighbors and boundaries.
Making ratings and dividing data into partitions.
To build great analytical reports without Excel or Pandas.
A clear and visual introduction to window functions in SQL.
Use them instead of subqueries.
Regexes, math, file IO and over 100 other functions.
Strict tables, any type and a new pragma.
CC-licensed design guide for presentations, reports, and dashboards.