Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
0
Write-Side SQL for Engineers
DDL, INSERT, safe UPDATE/DELETE, schema evolution, transactions, and MERGE upserts — with a graded load lab.
Module Progress0% Complete
85 min total
8 Lessons
0 Completed
Module Content
CREATE TABLE: Types, Keys & Constraints
Define pipeline tables with sane types and executing constraints.
3 minTutorial
Start
INSERT: Single Rows, Bulk & INSERT..SELECT
The three insert shapes; named columns; idempotent reloads.
3 minTutorial
Start
UPDATE & DELETE: The WHERE Discipline
SELECT-first ritual, soft deletes, batching large changes.
3 minTutorial
Start
Lab: Build & Load stg_orders
CREATE, load 2k rows, correct, and prove replay-safety.
61 minSubmission
Start
ALTER, DROP, TRUNCATE: Evolving Schemas
Additive-first evolution, re-runnable migrations, staging reloads.
3 minTutorial
Start
Transactions: Atomic Loads
All-or-nothing restatements; short transactions; engine differences.
3 minTutorial
Start
MERGE & Upserts: Handling Replays
Merge keys, ON CONFLICT vs MERGE, SCD-1 limits, replay test.
3 minTutorial
Start
Quiz: Write-Side SQL
8 scenario questions on DDL safety, write discipline, atomicity, and replays.
6 minTutorial
Start