
Retype an invoice table so money is exact to the cent, quantities are whole numbers, product codes are length-bounded and descriptions stay free-form.
Rework a shipment event table so event times are absolute instants, scheduled days carry no time of day, the signed-for flag is a yes/no value, and the shipment state is one of four values that sort in life-cycle order.
Let the orders table mint its own keys and money columns: a database-assigned id, a time-ordered UUID reference, and line total and tax columns the database computes instead of callers.
Design a clinic appointments table end to end: exact money, whole minutes, bounded and free-form text, absolute instants and plain dates, a yes/no flag, a life-cycle status, a defaulted creation stamp, database-assigned keys and two derived amounts that can never disagree with their inputs.
Master PostgreSQL from your first query to production, with hands-on SQL, analytics, indexing, transactions, security, performance tuning and replication, all tested against a real database.
This path starts with the SQL foundations of PostgreSQL: data types and table design, constraints and keys, querying, and joins and set operations. It helps to know what tables and rows are, but no earlier PostgreSQL experience is needed. The joins module shows how to combine tables to answer questions a single table can't.
4 modules: Data Types & Table Design, Constraints & Keys, Querying Fundamentals and Joins & Set Operations.
12 exercises, all easy.
Challenges run on PostgreSQL.
No. Every challenge runs in a browser-based IDE with everything already set up, and your code is graded automatically against a test suite.