1 FREE LESSON PER SECTION (3 FREE CHALLENGES)
Beginner to Intermediate
4.97 (510 Reviews)
SQL & Relational Databases Masterclass
Query databases with confidence: master SELECT, WHERE filtering, INNER/LEFT JOINs, GROUP BY aggregations, and schema design.
Instructor: Kavita Sundaram
Duration: 6.0 Hours
Lessons: 8 Lessons
Enrolled: 6,200 Students
Course Overview
Data powers every modern business. In this course, you will write real SQL queries against actual database tables. Learn how to extract insights, connect related tables with JOINs, calculate totals with GROUP BY, and design high-speed relational schemas.
What You'll Learn & Build
Querying columns, renaming with AS aliases, and removing duplicates with DISTINCT
Filtering rows using WHERE, AND/OR, IN, BETWEEN, and LIKE pattern matching
Sorting with ORDER BY (ASC/DESC) and limiting results with LIMIT/OFFSET
Aggregation functions: COUNT(), SUM(), AVG(), MIN(), MAX(), and GROUP BY
Joining relational tables with INNER JOIN, LEFT JOIN, and table aliases
Inserting, updating, and deleting records safely with primary/foreign key constraints
Prerequisites
- No previous database experience required
Who This Is For
- Backend developers, full-stack engineers, and data analysts
Course Curriculum & Lessons
3 Modules • 8 Total Lessons • Lessons 1-4 are Free to Solve-
1. The SELECT Statement, Column Aliases & DISTINCT
-
2. Filtering Data with WHERE, AND/OR & Operators
-
3. Sorting Results with ORDER BY & Limiting with LIMIT
-
4. Aggregations: COUNT, SUM, AVG & GROUP BY
-
5. Multi-Table INNER JOIN and LEFT JOIN
-
6. Subqueries and Common Table Expressions (WITH CTE)
-
7. Modifying Data: INSERT, UPDATE, DELETE & Transactions
-
8. Capstone: Relational Schema Architecture & Indexing
Your Instructor
KS
Kavita Sundaram
Database Architect
Senior software architect with extensive production engineering experience. Builds clean, modern curriculum and interactive web playgrounds for developers.
