← Programming & Computer Science Foundations
SQL
SQL from first query to window functions, joins, and query optimization
Start with core commands and fundamentals — sorting, filtering, and logical operators — then move through aggregate functions, all six join types, case statements, and date functions. You'll master subqueries, CTEs, views, and window functions, plus normalization, ACID properties, and query optimization, capped off with a full ecommerce analytics project.
per level · 3 levels · complete programme ₹10,500
- Duration
- 3 mo
Fees by level
Start at any level, or take the complete programme. The fee you pay for a level is locked for you.
| Level | What it covers | Duration | Fee |
|---|---|---|---|
| Beginner | Start from zero | 1 mo | ₹2,500 |
| Intermediate | Build working projects | 1 mo | ₹3,500 |
| Advanced | Get job-ready | 1 mo | ₹4,500 |
| Complete programme (all levels) | ₹10,500 | ||
All fees are in Indian Rupees and include applicable taxes. See our pricing & payment terms.
The complete curriculum
This is the entire syllabus — all 16 modules and 27 lessons, in the order you'll learn them. Nothing hidden.
↓ Download full curriculum (PDF)01 Introduction to DBMS 1 lesson ▶
- 1.1DBMS
02 SQL Commands 2 lessons ▶
- 2.1Overview of SQL Commands
- 2.2Detailed Study of SQL Command Types (DDL, DML, DCL, TCL)
03 SQL Fundamentals (Sorting, Filtering, Logical Operators, String Operators) 1 lesson ▶
- 3.1SQL Basics
04 Aggregate Functions 1 lesson ▶
- 4.1Aggregate Functions (Common Aggregate Functions, Group By and Having Clauses, Use of Coalesce and Other Functions)
05 Joins (Inner Join, Left Join, Right Join, Full Join, Self Join, Cross Join) 3 lessons ▶
- 5.1Theoretical Understanding of Different Types of Joins
- 5.2Practical Implementation of Joins
- 5.3Practice Exercises on Joins
06 Case Statements 1 lesson ▶
- 6.1Working with CASE Statements
07 Date Functions 1 lesson ▶
- 7.1Date and Time Functions in SQL
08 Set Operators 1 lesson ▶
- 8.1SET Operators (Union, Union All, Intersect, Minus/Except)
09 Sub Query 1 lesson ▶
- 9.1Sub Queries (Correlated, Non Correlated)
10 CTE & View 1 lesson ▶
- 10.1Common Table Expressions (CTEs) and Views
11 Window Functions 2 lessons ▶
- 11.1Rank Functions and Running Total
- 11.2Lead and Lag Functions, Working with Window Frames
12 Normalization 1 lesson ▶
- 12.1Database Normalization
13 ACID Properties 1 lesson ▶
- 13.1ACID Properties in Database
14 Query Optimization 1 lesson ▶
- 14.1Query Optimization Techniques(Indexing, Other Optimization Strategies)
15 Advanced Topics 5 lessons ▶
- 15.1Import and Export ERD
- 15.2Users & Privileges
- 15.3Locking and Unlocking Tables
- 15.4Variables
- 15.5Stored Procedures
16 Final Project: Ecommerce Store -- Insights and Analytics 4 lessons ▶
- 16.1General Sales Insights
- 16.2Customer Insights
- 16.3Product and Order Insights
- 16.4Temporal Trends, Regional Insights, Return and Refund
Tools you'll use
Every course includes
Related courses
C++
Master C++ fundamentals — OOP, STL, and file streams — with hands-on practice
Competitive Programming
Sharpen your competitive programming edge with STL, graphs, and dynamic programming
DBMS
Database fundamentals through Oracle SQL, PL/SQL, and transaction management