Data · Beginner

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.

★ 4.830K learners2h 59m8 lessonsEnglish

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