top of page

SQL Tutorials

The Basics

This chapter discusses the basics of SQL and relational data.

Defining a Database

This chapter shows how we can define a database schema with associated constraints.

Loading and Updating Data

This chapter shows how we can load data into a database and make changes and deletions.

Simple Analysis

This chapter introduces simple data analysis with SQL, including filtering and projections.

Joins

This chapter discusses the join operator, an operation that combines data from multiple tables.

Aggregates, Grouping, Sorting

This chapter shows how to calculate aggregates, partition data, and sort rows.

Sub-Queries

This chapter shows how to use correlated and uncorrelated sub-queries.

© 2025 by Immanuel Trummer. All rights reserved.

bottom of page