One lesson
An individual lesson
This track has no lesson ready to buy yet. Each lesson becomes available only after it is built and reviewed.
$5.00Not available yet
All course tracks
Databases and SQL · 30 lessons · up to 10 minutes each
SQL Foundations
A planned SQL path from SELECT statements through joins, updates, and transactions.
Coming Soon
One-time purchase · USD
Choose what to unlock
Access is attached to your account after payment is verified. No subscription.
Full category
SQL Foundations
Permanent access to the lessons published in this track when you buy. Future lessons are not included. 0 of 30 lessons are published; 0 are in owner review and 30 are Coming Soon.
$29.0030 lessons still in progress
Beginner
Lessons 1–10
01 SQL Foundations: Sketch SELECT and result columns
Topic: SELECT and result columns
Draw a small map of SELECT and result columns in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner4 minComing Soon02 SQL Foundations: Name the parts of WHERE filters
Topic: WHERE filters
Label the main pieces in WHERE filters in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner5 minComing Soon03 SQL Foundations: Trace an example of sort order and pagination
Topic: sort order and pagination
Follow one input through sort order and pagination in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner6 minComing Soon04 SQL Foundations: Compare choices for joins and keys
Topic: joins and keys
Write down one practical difference between joins and keys in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner7 minComing Soon05 SQL Foundations: Find the boundary in aggregate functions
Topic: aggregate functions
Mark where aggregate functions in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner8 minComing Soon06 SQL Foundations: Inspect an example of grouping and HAVING
Topic: grouping and HAVING
Annotate a minimal example of grouping and HAVING in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner9 minComing Soon07 SQL Foundations: Connect INSERT, UPDATE, and DELETE to a neighboring concept
Topic: INSERT, UPDATE, and DELETE
Show how INSERT, UPDATE, and DELETE in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner10 minComing Soon08 SQL Foundations: Spot a failure mode in NULL and three-valued logic
Topic: NULL and three-valued logic
Describe one likely failure for NULL and three-valued logic in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner3 minComing Soon09 SQL Foundations: Read an official example of subqueries and CTEs
Topic: subqueries and CTEs
Summarize an official example of subqueries and CTEs in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner5 minComing Soon10 SQL Foundations: Choose a use case for constraints and transactions
Topic: constraints and transactions
Match one small use case to constraints and transactions in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Beginner6 minComing Soon
Intermediate
Lessons 11–20
11 SQL Foundations: Build an example with SELECT and result columns
Topic: SELECT and result columns
Create a small working example that uses SELECT and result columns in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate4 minComing Soon12 SQL Foundations: Compose WHERE filters with another component
Topic: WHERE filters
Combine WHERE filters in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon13 SQL Foundations: Configure sort order and pagination for a small case
Topic: sort order and pagination
Set up sort order and pagination in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon14 SQL Foundations: Validate inputs around joins and keys
Topic: joins and keys
Add a check around joins and keys in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate7 minComing Soon15 SQL Foundations: Use aggregate functions in a short workflow
Topic: aggregate functions
Add aggregate functions in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate8 minComing Soon16 SQL Foundations: Refactor grouping and HAVING into a reusable unit
Topic: grouping and HAVING
Extract grouping and HAVING in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate9 minComing Soon17 SQL Foundations: Exercise INSERT, UPDATE, and DELETE with sample data
Topic: INSERT, UPDATE, and DELETE
Run sample data through INSERT, UPDATE, and DELETE in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate10 minComing Soon18 SQL Foundations: Observe NULL and three-valued logic outputs
Topic: NULL and three-valued logic
Capture the result of NULL and three-valued logic in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate3 minComing Soon19 SQL Foundations: Recover from a subqueries and CTEs failure
Topic: subqueries and CTEs
Handle one expected failure from subqueries and CTEs in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon20 SQL Foundations: Document constraints and transactions behavior
Topic: constraints and transactions
Write a short usage note for constraints and transactions in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon
Advanced
Lessons 21–30
21 SQL Foundations: Test a boundary around SELECT and result columns
Topic: SELECT and result columns
Add an edge-case test for SELECT and result columns in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced4 minComing Soon22 SQL Foundations: Harden WHERE filters
Topic: WHERE filters
Add the relevant access, safety, or validation control to WHERE filters in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced5 minComing Soon23 SQL Foundations: Measure sort order and pagination
Topic: sort order and pagination
Record a small baseline for sort order and pagination in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced6 minComing Soon24 SQL Foundations: Reduce cost in joins and keys
Topic: joins and keys
Change one measurable cost in joins and keys in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced7 minComing Soon25 SQL Foundations: Diagnose a aggregate functions failure
Topic: aggregate functions
Use an observable signal to explain a failure in aggregate functions in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced8 minComing Soon26 SQL Foundations: Make grouping and HAVING repeatable
Topic: grouping and HAVING
Show that rerunning grouping and HAVING in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced9 minComing Soon27 SQL Foundations: Review trade-offs in INSERT, UPDATE, and DELETE
Topic: INSERT, UPDATE, and DELETE
Compare two documented approaches to INSERT, UPDATE, and DELETE in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced10 minComing Soon28 SQL Foundations: Improve NULL and three-valued logic maintainability
Topic: NULL and three-valued logic
Refine NULL and three-valued logic in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced3 minComing Soon29 SQL Foundations: Verify subqueries and CTEs end to end
Topic: subqueries and CTEs
Check that a complete small flow using subqueries and CTEs in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced5 minComing Soon30 SQL Foundations: Audit constraints and transactions against its source docs
Topic: constraints and transactions
Check the implementation of constraints and transactions in the context of portable relational SQL queries and data integrity; save a short example or check that demonstrates the result.
Advanced6 minComing Soon
Reference documentation
References support the selected track topics while its lesson content is built and reviewed progressively.
This track is a catalog outline only. Each lesson remains unavailable until it is built and personally reviewed.