Skip to Content
PROGRAMMING

SQL

Practical courses for the work we actually do. Pick one, finish it, and apply it.

Any category Programming6 Python 1 JavaScript 1 TypeScript 1 SQL 2 HTML and CSS 1 DevOps1 Docker 1
Any topics Databases 3 Performance Optimization 2 Testing and Debugging 1
Any level Intermediate 1 Advanced 1
SQL Performance Optimization Clear filters 2 results
0 likes
SQL Intermediate: Queries That Survive Real Data

Window functions, CTEs and schema design for tables other people also write to. You will join three tables without double counting, rank and total rows with window functions, design tables that protect themselves, and read a query plan to see why a query is slow. If you skip the checks on duplicates, time zones and concurrent changes, your queries will pass on test data and give wrong answers on real data.

2h 20m 16 lessons
0 likes
SQL Advanced: Queries That Hold Up Under Load

Read query plans, choose the right index and change live tables safely. You will read an EXPLAIN ANALYZE plan line by line, pick between B-tree, GIN, GiST and BRIN indexes, understand MVCC, locks and deadlocks, and run migrations and backups that you have proved on a copy. If you skip the plans, the locks and the restore test, your queries will pass on a small table and fail when the table is large and busy.

2h 30m 17 lessons