Ravi Kulkarni · Data engineer
SQL & Databases for Developers
Practical SQL for backend and full-stack developers: SELECT mastery, joins, indexes, transactions, and designing schemas that do not fall over.
What you'll learn
- Write complex SELECTs with joins and aggregates
- Design normalized schemas with clear keys
- Use indexes to speed up slow queries
- Understand transactions and isolation basics
Skills
- SQL
- PostgreSQL
- Indexes
- Joins
- Schema design
Curriculum
Query skills4 lessons
- SELECT, WHERE, ORDER BY · Free previewReadable queries that answer real questions.12 min
- JOINs without row explosions · Free previewINNER, LEFT, and diagnosing fan-out.16 min
- GROUP BY and window functionsRanks, running totals, and partitions.17 min
- Subqueries and CTEsBreak hard questions into clear steps.13 min
Design & performance4 lessons
- Primary keys, FKs, and normalizationSchemas that match the domain.15 min
- Indexes and EXPLAIN basicsSee why a query is slow.14 min
- Transactions and ACIDCommit, rollback, and concurrency pitfalls.12 min
- Capstone: e-commerce schema + queriesOrders, items, and reporting SQL.20 min