SQL Fundamentals · PostgreSQL
SQL Foundations for Operators
A four-week start for IT staff stepping into database administration — readable queries, safe writes, and a working mental model of how relational engines plan work.
About this cohort
This cohort grounds you in the SQL idioms a junior DBA actually uses on day shifts. You will write SELECT statements that survive code review, learn how the planner reads your joins, and practice the small habits that prevent accidental table locks. We work in PostgreSQL because its tooling rewards careful thinking, but every concept is restated in the dialect of MySQL and SQL Server so you can move between estates without translation guilt. Expect a steady cadence: short live walk-throughs on Tuesdays, lab work in your own time, and one mentor review of your scripts each week.
Inclusions
- Two live mentor sessions every week, recorded for replay
- Sandbox PostgreSQL instance with a 14-table sample retail schema
- Weekly written feedback on your submitted queries
- Reading list curated from production-grade documentation only
- Cheat sheets for joins, window functions, and EXPLAIN output
- Slack-style channel access to instructors during weekday hours
By the end you can
- 01 Write reliable SELECT, INSERT, UPDATE, and DELETE statements that pass review
- 02 Read EXPLAIN ANALYZE output and identify the obvious slow paths
- 03 Speak the vocabulary of indexes, transactions, and isolation in standups
Programme lead
Kim Da-eun
Lead SQL Instructor with twelve years of platform experience across retail and operational SaaS. She still rotates through on-call so the labs stay grounded.
Common questions
From the cohort
-
The week-three feedback on my UPDATE statements caught a join condition I had been quietly carrying in my head wrong for a year. Worth the seat.
Han J.Han J.
Junior Operator 4.7/5 · survey
-
Pacing felt comfortable, though I wish the week on isolation levels had its own afternoon.
Min-seoMin-seo
4.4/5