01-up-and-running-with-sql

01 — Up and Running with SQL

Exercises for the Up and Running with SQL course.

This is a beginner course focused on getting PostgreSQL installed and writing your very first SQL. Only two sections of the course have hands-on SQL worth practicing; the rest are installation and tooling.

Sections

Section	What you'll practice
1 — Databases	CREATE DATABASE, DROP DATABASE, listing and connecting to databases
2 — Working with Tables	CREATE TABLE, choosing data types, NOT NULL, ALTER TABLE, DROP TABLE

The upstream course's other sections are intro, installation, and psql tooling — there's nothing meaningful to practice with SQL there, so they aren't included here.

Prerequisites

• PostgreSQL installed and psql working
• You've completed ../SETUP.md and created a sql_exercise database

Suggested order

Do 01-databases first — you'll build muscle memory around creating and dropping databases with the server superuser, then 02-working-with-tables where you start authoring DDL inside a database.