SQL Learning Program
SQL that actually sticks
Live sessions, real databases, and an instructor who can see exactly where you're getting stuck - group cohorts or private lessons, your call.
What you'll cover
The full SQL curriculum
Six structured modules, from your first SELECT to writing stored procedures that run in production.
Foundation module
Relational databases from scratch
Most SQL courses skip the "why" and jump straight to syntax. This module starts with how relational databases actually store and retrieve data - tables, rows, keys, and relationships. You'll write your first queries against a real PostgreSQL server, not a sandbox toy. By the end of week two you'll be comfortable with SELECT, WHERE, ORDER BY, and multi-table JOINs. The setup uses MobaXterm (Moba X Term) on Windows or a native terminal on other systems, so you're working exactly as you would in a professional environment.
Module 2
Aggregation & grouping
GROUP BY, HAVING, COUNT, SUM, AVG - and when each one applies. Practice sets use realistic sales and user-event datasets.
Module 3
Subqueries & CTEs
Nested queries, WITH clauses, and when a CTE makes your code readable instead of just clever. Covers correlated subqueries too.
Module 4
Window functions
ROW_NUMBER, RANK, LAG, LEAD - the functions analysts reach for constantly. Explained through real reporting problems.
Module 5
Schema design
Normalization, indexing strategy, and foreign key constraints. Design a small but realistic schema from a written spec.
Module 6
Performance & optimization
EXPLAIN plans, slow query diagnosis, and index tuning. You'll take a poorly-written query and make it measurably faster.
How sessions actually run
Every session connects you to a shared PostgreSQL server over SSH. You run queries live, the instructor sees your screen if needed, and feedback happens in the moment - not days later in written comments.
Group cohorts meet twice a week. Private sessions are scheduled around your availability. Both formats use the same curriculum and the same server environment.
Connecting takes about two minutes. Most Windows students use MobaXterm because it handles the SSH connection and gives you a usable terminal without extra configuration. Mac and Linux users connect with the built-in terminal. Either way, the instructor walks you through it before the first real session.
-
01
Pick your format
Group cohort or private sessions - you decide based on schedule and how you prefer to learn. Switching at a module boundary is possible if your needs change.
-
02
Get your server credentials
Before the first session you'll receive SSH credentials for the practice server. The instructor confirms your connection is working - Moba X Term or terminal, your choice.
-
03
Work through modules with live feedback
Each module mixes instruction with hands-on query writing. The instructor spots errors as you make them, which is faster than debugging alone after the fact.
-
04
Practice on realistic datasets
Exercises use datasets shaped like real business data - orders, users, events, inventory. The problems are messy enough to be useful, not toy examples.
-
05
Receive a completion record
After each module you get a completion certificate documenting what you covered. It's not an industry certification, but it's a concrete record you can share.
The instructors
Darren Ulfsby
Senior SQL Instructor
Darren spent eight years writing production queries for logistics and supply-chain systems before moving into teaching. He runs the group cohorts and tends to focus on the parts that trip people up in real jobs - not just the clean textbook examples.
Petra Vandermolen
Database Engineering Lead
Petra's background is in database architecture. She handles the advanced modules on schema design and performance tuning, and takes most of the private sessions for students working through complex optimization problems.
Saoirse Ó Briain
SQL Instructor - Analytics track
Saoirse comes from a data analysis background and focuses on the aggregation, window function, and reporting modules. She's particularly good at explaining when to use a subquery versus a CTE without making it feel like a religious debate.
Common questions
No prior programming background is required for the beginner SQL track. If you can use a spreadsheet, you have enough foundation to start. The intermediate and advanced modules assume familiarity with SELECT, WHERE, and JOIN - which you'll have after the first two modules.
On Windows, MobaXterm is the easiest option - it's free, handles SSH, and gives you a proper terminal. Moba X Term also has a built-in text editor which is handy for longer queries. Mac and Linux users use their system terminal. No local database installation is needed since you connect to our server.
Group cohorts meet twice a week. Each session is roughly 90 minutes - about 40 minutes of instruction, then guided practice with the instructor available for live questions. Sessions are not recorded by default, but notes and exercise files are shared after each one.
Yes. Students can move between formats at module boundaries. If you start in a group cohort and hit a topic that needs more focused attention, you can book a private session alongside your cohort track without losing your place in the group.
Completion certificates are issued per module track. They're not industry certifications, but they document exactly what you covered and can be shared with an employer or added to a portfolio. A few students have used them as supporting material when applying for analyst roles.
The core format - live sessions over SSH on a real server - has stayed the same. What changed is the curriculum depth and the addition of private session tracks. The original program only offered group cohorts. Individual sessions were added after students kept asking for focused help on specific modules they were stuck on.