Articles & Tutorials

Additional educational materials on SQL, not included in the main course

All articles

Fundamentals

SQL in practice

Performance

SELECT *

Fundamentals

7 min read

SQL from Scratch: A Step-by-Step Learning Plan for Beginners in 2026

A 6-week roadmap — from your first SELECT to the interview

Database Normalization: Normal Forms Explained Simply

1NF, 2NF and 3NF on a single running example

ROW_NUMBER vs RANK vs DENSE_RANK in SQL: The Difference in One Example

Three ranking functions, one query — and the difference is visible

ACID: The 4 Properties of Database Transactions Explained Simply

Atomicity, consistency, isolation, durability — through a money transfer example

SQL COALESCE: What It Is and How It Works — Examples | SQL Academy

The first non-NULL argument, and why NULLIF belongs nearby

CTE in SQL: What a Common Table Expression (WITH) Is — Examples

Subqueries with names, chains of steps, and recursion

DATEDIFF in SQL: How to Calculate the Difference Between Dates (MySQL, PostgreSQL)

Days, hours, months and age — each DBMS does it differently

SQL Query Optimization: 10 Ways to Speed Up a Slow Query

From EXPLAIN to proper pagination — a practical checklist

SQL String Functions: CONCAT, SUBSTRING, TRIM, REPLACE — Cheat Sheet

Join, cut, clean and search — with live examples

TRUNCATE vs DELETE vs DROP in SQL: The Difference and What to Choose

The three deletion commands people confuse most often

PIVOT in SQL: How to Turn Rows into Columns

Building pivot tables with pure SQL

SQL SEQUENCE in PostgreSQL: one ID generator for multiple tables

Solving the shared document numbering problem

November 14, 2025