Course

SQL -- University Course (30 Lessons)

30 lessons covering SQL from first SELECT to production query optimization, each with a real-time e-commerce/banking example.

Swarnil Singhai self-paced Updated Jul 2026 Beginner

30

lessons

—

total runtime

Free

access

About this course

SQL -- University Course (30 Lessons) is a hands-on course with real-time, real-world code examples in every lesson, not toy snippets.

Real-time example

This course walks through SQL -- University Course (30 Lessons) the way it's actually used on the job -- production-style examples over abstract theory.

-- start here, then work through the lessons in order

What's happening

Each lesson below stands alone but builds on the ones before it -- concept, a real-time example, working code, and a takeaway.

Work through all 30 lessons in order for the full course.

Syllabus

Lesson by lesson

  1. 1 Lesson 1: Introduction to Relational Databases Introduction to Relational Databases preview
  2. 2 Lesson 2: SELECT, WHERE & Basic Filtering SELECT, WHERE & Basic Filtering preview
  3. 3 Lesson 3: ORDER BY, LIMIT & Pagination ORDER BY, LIMIT & Pagination preview
  4. 4 Lesson 4: Aggregate Functions: COUNT, SUM, AVG, MIN, MAX Aggregate Functions: COUNT, SUM, AVG, MIN, MAX preview
  5. 5 Lesson 5: GROUP BY & HAVING GROUP BY & HAVING preview
  6. 6 Lesson 6: INNER JOIN INNER JOIN preview
  7. 7 Lesson 7: LEFT JOIN, RIGHT JOIN & FULL OUTER JOIN LEFT JOIN, RIGHT JOIN & FULL OUTER JOIN preview
  8. 8 Lesson 8: Self Joins Self Joins preview
  9. 9 Lesson 9: Subqueries Subqueries preview
  10. 10 Lesson 10: Common Table Expressions (WITH) Common Table Expressions (WITH) preview
  11. 11 Lesson 11: Window Functions: ROW_NUMBER, RANK, LAG/LEAD Window Functions: ROW_NUMBER, RANK, LAG/LEAD preview
  12. 12 Lesson 12: INSERT, UPDATE & DELETE INSERT, UPDATE & DELETE preview
  13. 13 Lesson 13: Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL Constraints: PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL preview
  14. 14 Lesson 14: Indexes & Query Performance Indexes & Query Performance preview
  15. 15 Lesson 15: Normalization: 1NF, 2NF, 3NF Normalization: 1NF, 2NF, 3NF preview
  16. 16 Lesson 16: Views Views preview
  17. 17 Lesson 17: Transactions & ACID Transactions & ACID preview
  18. 18 Lesson 18: Isolation Levels & Locking Isolation Levels & Locking preview
  19. 19 Lesson 19: String Functions String Functions preview
  20. 20 Lesson 20: Date & Time Functions Date & Time Functions preview
  21. 21 Lesson 21: CASE Expressions CASE Expressions preview
  22. 22 Lesson 22: NULL Handling: IS NULL, COALESCE, NULLIF NULL Handling: IS NULL, COALESCE, NULLIF preview
  23. 23 Lesson 23: UNION, INTERSECT & EXCEPT UNION, INTERSECT & EXCEPT preview
  24. 24 Lesson 24: Data Types & Choosing the Right One Data Types & Choosing the Right One preview
  25. 25 Lesson 25: ALTER TABLE & Schema Migrations ALTER TABLE & Schema Migrations preview
  26. 26 Lesson 26: Stored Procedures & Functions Stored Procedures & Functions preview
  27. 27 Lesson 27: Triggers Triggers preview
  28. 28 Lesson 28: Query Optimization & EXPLAIN Query Optimization & EXPLAIN preview
  29. 29 Lesson 29: Preventing SQL Injection (Database Side) Preventing SQL Injection (Database Side) preview
  30. 30 Lesson 30: Real-Time Analytics Query (Capstone) Real-Time Analytics Query (Capstone) preview

Hands-on

Every lesson ends with something working. No theory marathons.

Battle-tested

Built from real production mistakes — you get the shortcut.

Questions answered

Ask in the discussion below — I reply to every comment.

Your instructor

Swarnil Singhai
Swarnil Singhai

I’m Swarnil, exploring and documenting my life, sharing my learning, experiences, stories, and lessons through videos, blogs, films.

About me

Frequently asked

Do I need an account?

No — this course is free and open. Signing up just adds progress across devices, email updates and an ad-free experience.

How is progress tracked?

In your browser — the player tracks where you are, the last lesson ends with a small confetti ceremony, and completed lessons show a green badge in this syllabus.

Is there a certificate?

No certificate — just the skill. Which, between us, is the part interviews check.

I'm stuck. Where do I ask?

The discussion at the bottom of any lesson — I answer every comment. For anything longer, the contact page.

Made with this gear

Everything used to record, edit and ship this course. Affiliate links keep the lessons free.

My setup Product Name — 3 Generic product 3 — I use it, I like it, affiliate link inside. My setup Product Name — 2 Generic product 2 — I use it, I like it, affiliate link inside.

Advertisement

Keep learning

More courses