Skip to Content
PROGRAMMING

SQL

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

Any category Programming5 Python 1 JavaScript 1 TypeScript 1 SQL 1 HTML and CSS 1 DevOps1 Docker 1
Any topics Databases 1 Performance Optimization 1
Any level Beginner 1 Intermediate 1 Advanced 1
SQL Intermediate Clear filters 1 result
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