Skip to content
Topic

SQL

Master SQL and Databases fundamental to handles data for organizations to interpret and analyze data and make data easy to understand.

26 guides

SQL INNER JOIN Explained SQL SQL INNER JOIN Explained Learn SQL INNER JOIN with real PostgreSQL examples: match rows with ON, use table aliases, join three or four tables, and avoid… November 8, 2026 · 13 min read
SQL Order of Execution: Why Aliases and Aggregates Fail in WHERE SQL SQL Order of Execution: Why Aliases and Aggregates Fail in WHERE The SQL order of execution explained: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, LIMIT. See why aliases and aggregates fail in… November 8, 2026 · 11 min read
SQL GROUP BY and HAVING SQL SQL GROUP BY and HAVING Learn SQL GROUP BY and HAVING with real PostgreSQL examples: group by several columns, fix the "must appear in the GROUP BY… November 8, 2026 · 11 min read
SQL Aggregate Functions: COUNT, SUM, AVG, MIN and MAX SQL SQL Aggregate Functions: COUNT, SUM, AVG, MIN and MAX Learn SQL aggregate functions COUNT, SUM, AVG, MIN and MAX: COUNT(*) vs COUNT(DISTINCT), NULL handling, COALESCE and FILTER, with real PostgreSQL output. November 7, 2026 · 11 min read
SQL CASE WHEN, CAST and Common String and Date Functions SQL SQL CASE WHEN, CAST and Common String and Date Functions Learn SQL CASE WHEN, CAST and the string and date functions you use daily (UPPER, TRIM, ||, EXTRACT, date_trunc, AGE), with real… November 7, 2026 · 14 min read
SQL ORDER BY: Sorting, NULLS FIRST/LAST and Paging with LIMIT/OFFSET SQL SQL ORDER BY: Sorting, NULLS FIRST/LAST and Paging with LIMIT/OFFSET Learn SQL ORDER BY: sort by several columns, place NULLs with NULLS FIRST/LAST, and page with LIMIT/OFFSET without losing rows. Plus TOP… November 7, 2026 · 13 min read
SQL NULL Values: IS NULL, COALESCE and Three-Valued Logic SQL SQL NULL Values: IS NULL, COALESCE and Three-Valued Logic SQL NULL explained with real PostgreSQL outputs: why = NULL fails, IS NULL, three-valued logic, the NOT IN trap, COALESCE, NULLIF and… November 6, 2026 · 13 min read
SQL WHERE Clause: Filter Rows with AND, OR, IN, BETWEEN and LIKE SQL SQL WHERE Clause: Filter Rows with AND, OR, IN, BETWEEN and LIKE Learn the SQL WHERE clause with real PostgreSQL outputs: comparison operators, AND/OR precedence, IN, BETWEEN, LIKE and ILIKE, plus MySQL and SQLite… November 6, 2026 · 12 min read
SQL SELECT Statement: Columns, Aliases, DISTINCT and LIMIT SQL SQL SELECT Statement: Columns, Aliases, DISTINCT and LIMIT Learn the SQL SELECT statement: pick columns, name them with AS, remove duplicates with DISTINCT and limit rows with LIMIT, with real… November 6, 2026 · 11 min read
Install PostgreSQL and Load a Sample Database for SQL Practice SQL Install PostgreSQL and Load a Sample Database for SQL Practice Install PostgreSQL on Windows, macOS or Linux, then load a sample database with createdb and psql -f. Includes the full practice script… November 5, 2026 · 17 min read
PostgreSQL vs MySQL vs SQLite vs SQL Server: Which SQL to Learn First SQL PostgreSQL vs MySQL vs SQLite vs SQL Server: Which SQL to Learn First PostgreSQL vs MySQL vs SQLite vs SQL Server for beginners: licences, how each runs, dialect differences like LIMIT, TOP and ILIKE, and… November 5, 2026 · 12 min read
What Is a Relational Database? Tables, Rows, Columns and Keys SQL What Is a Relational Database? Tables, Rows, Columns and Keys What is a relational database? Learn tables, rows, columns, primary keys and foreign keys with real PostgreSQL examples from a small online… November 5, 2026 · 12 min read