PostgreSQL Foundations: Tables, Data Types & Queries
Work through a fictional bike-rental database in PostgreSQL: psql, data types, identity columns, numeric, dates, :: casts, constraints, INSERT/UPDATE/DELETE, NULL, GROUP BY, generate_series and transactions, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
PostgreSQL Foundations teaches you to read and predict real PostgreSQL. You work with the fictional bike-rental company Velora Bikes and in every lab you play the database server: you work out what a query returns, which INSERT a constraint rejects and what is finally stored. You learn psql, the main data types and their storage, identity columns and sequence gaps, varchar and numeric limits, integer division and :: casts, date and timestamp arithmetic, CREATE TABLE with constraints, INSERT, UPDATE and DELETE with foreign keys, NULL and COALESCE, GROUP BY with FILTER, CASE, generate_series calendars and transactions. Every answer is checked instantly, and the first lesson is free.
Lessons
- psql and Your First PostgreSQL QueryFree
- Data Types and How Much Space They Take Locked
- serial, Identity Columns and Sequences Locked
- text, varchar(n) and String Functions Locked
- numeric(p,s): Exact Decimals and Overflow Locked
- Integer Division, % and :: Casts Locked
- date: Days, Differences and Intervals Locked
- timestamp, EXTRACT and Half-Open Ranges Locked
- CREATE TABLE with NOT NULL, CHECK and DEFAULT Locked
- INSERT: Multi-Row VALUES, DEFAULT and RETURNING Locked
- UPDATE: Change Rows Safely Locked
- DELETE, Foreign Keys and ON DELETE CASCADE Locked
- WHERE with IN, BETWEEN, AND and OR Locked
- ORDER BY, NULLS LAST, LIMIT and OFFSET Locked
- LIKE, ILIKE and Concatenation with || Locked
- NULL, COALESCE and Aggregates Locked
- GROUP BY, HAVING and the FILTER Clause Locked
- boolean and CASE Expressions Locked
- generate_series: Numbers and Dates on Demand Locked
- Calendars with generate_series and LEFT JOIN Locked
- Transactions: BEGIN, COMMIT, ROLLBACK and SAVEPOINT Locked
- Final Project: The March Report Locked