Advanced SQL for Web Apps
Write faster, safer SQL for web apps: indexes, query plans, transactions and window functions.
What you'll learn
- Read EXPLAIN ANALYZE output in PostgreSQL
- Choose and create indexes
- Write window functions and CTEs
- Use transactions and isolation levels
- Find and fix N+1 query problems
About this course
You work with a database of a million rows and learn why queries slow down. You read query plans, add indexes, use window functions and handle concurrent writes. A reviewer checks your final tuning report.
Course curriculum
5 modules and 15 lessons over 4–5 weeks. Plan for about 16 learning hours.
01Query plansWeek 1 · 3 lessons
- EXPLAIN and EXPLAIN ANALYZE
- Sequential and index scans
- Reading costs
02IndexesWeek 2 · 3 lessons
- B-tree indexes
- Composite and partial indexes
- When indexes hurt
03Advanced queriesWeek 3 · 3 lessons
- CTEs
- Window functions
- Upserts
04ConcurrencyWeek 4 · 3 lessons
- Transactions
- Isolation levels
- Locks and deadlocks
05N+1 queries and tuning reportWeek 5 · 3 lessons
- Spotting N+1 queries in ORM logs
- Fixing them with joins and eager loading
- Tuning report and written review
Project
Query tuning report. You speed up the slowest queries in a sample app and document each change with plans and timings.
Who this course is for
Developers who write SQL in production and hit slow queries or locking problems.
Prerequisites
You write joins, subqueries and GROUP BY queries with confidence.
What's included
- 180-day course access
- Structured lessons
- Project files
- Code templates
- Checkpoints
- One instructor review
- Support during the program
- A digital completion certificate
Learning format
Guided project course, part of our guided project courses. Checkpoints and one instructor review.
Access and delivery
- Enrollment access is activated within 15 minutes after payment.
- Instructor review is normally completed within 2 business days per submitted checkpoint, and the final certificate is issued within 2 business days after completion.
Certificate
You receive a digital completion certificate. Instructor review is normally completed within 2 business days per submitted checkpoint, and the final certificate is issued within 2 business days after completion.
Frequently asked questions
When does access start?
Enrollment access is activated within 15 minutes after payment.
Is payment taken on this website?
No. After you submit your enrollment request, we reply by email with payment details and enrollment confirmation.
Does this course guarantee a job or income?
No. It is an education and training service and does not include employment, income or placement guarantees.
Can I cancel?
Our Refund and Cancellation Policy lists the terms for guided project programs.
