CATEGORY

Databases and Data

Relational data, SQL, PostgreSQL, and practical data handling.

LESSONS

Choose a lesson

Open Learn, then continue with Practice and Prove.

Relational Data, Tables, Rows, and Keys

SQL Fundamentals

Open lesson

Install a Local SQL Practice Database

SQL Fundamentals

Open lesson

Create Tables and Choose Column Types

SQL Fundamentals

Open lesson

Select Columns and Rows

SQL Fundamentals

Open lesson

Filter Rows with WHERE

SQL Fundamentals

Open lesson

Sort, Limit, and Remove Duplicates

SQL Fundamentals

Open lesson

Work with NULL and Unknown Values

SQL Fundamentals

Open lesson

Insert Rows Safely

SQL Fundamentals

Open lesson

Update Rows with Targeted Conditions

SQL Fundamentals

Open lesson

Delete Rows and Protect Scope

SQL Fundamentals

Open lesson

Expressions, Aliases, and String Operations

SQL Fundamentals

Open lesson

Aggregate Functions

SQL Fundamentals

Open lesson

Group Results with GROUP BY and HAVING

SQL Fundamentals

Open lesson

Join Tables with INNER JOIN

SQL Fundamentals

Open lesson

Keep Unmatched Rows with OUTER JOIN

SQL Fundamentals

Open lesson

Subqueries and Common Table Expressions

SQL Fundamentals

Open lesson

Constraints and Data Integrity

SQL Fundamentals

Open lesson

SQL Fundamentals Capstone

SQL Fundamentals

Open lesson

PostgreSQL Architecture and Client Connections

PostgreSQL

Open lesson

Databases, Schemas, and Search Path

PostgreSQL

Open lesson

PostgreSQL Data Types and Type Casting

PostgreSQL

Open lesson

Identity Columns and Sequences

PostgreSQL

Open lesson

Transactions, Commit, Rollback, and Savepoints

PostgreSQL

Open lesson

MVCC and Transaction Visibility

PostgreSQL

Open lesson

Transaction Isolation and Concurrency

PostgreSQL

Open lesson

Index Fundamentals and B-tree Indexes

PostgreSQL

Open lesson

Read EXPLAIN Query Plans

PostgreSQL

Open lesson

Show more lessons