BTech / BCA Track6 Weeks CohortTopic-Linked Attendance Enabled

SQL — Database Fundamentals

Name: SQL — Database Fundamentals
Price: 2799 INR
Availability: InStock

Master relational databases, complex multi-table joins, subqueries, CTEs, analytical window functions, transactions, and normalized schema design using PostgreSQL and MySQL.

Key Skills You Will Master:

PostgreSQLMySQLComplex JoinsWindow FunctionsCTEsDatabase NormalizationIndexes

Lead Instructor

Vikramaditya Iyer

Ex-Tech Lead & STEM Mentor

Master SQL — Database Fundamentals — Online Course Overview & Curriculum Thumbnail

Total Program Fee (Full Cohort + Materials)

₹2,799₹3,999Save 30%

Choose Your CohortLive Interactive

Next cohort starting next weekend • 5:00 PM IST

10 Live Hybrid Interactive Sessions

10 Granular Tracked Topics

Downloadable datasets, cheatsheets & spreadsheets

Verifiable Certificate upon 85%+ topic completion

Syllabus Breakdown

Course Structure & Tracked Topics

Click on any module to view live sessions and the exact list of topics tested & tracked for attendance.

Session 1 • 90 Minutes Live

Session 1: Databases & SQL Syntax

Granular Tracked Topics (1):

RDBMS Concepts, Tables & SELECT Queries

Session 2 • 90 Minutes Live

Session 2: Filtering & Sorting Data

Granular Tracked Topics (1):

WHERE, Comparison Operators, ORDER BY, LIMIT

Hands-on Challenge: High-Value Orders Filter

Extract orders > ₹10,000 sorted by latest transaction timestamp.

Session 3 • 90 Minutes Live

Session 3: Advanced Filtering & Pattern Matching

Granular Tracked Topics (1):

IN, BETWEEN, LIKE Wildcards, NULL Handling

Beginner Milestone: E-Commerce Customer & Orders Query Suite

A suite of 15 analytical SQL queries extracting customer segments, low-stock alerts, and order totals.

Deliverable: Documented SQL query script file with execution results.

Session 1 • 90 Minutes Live

Session 4: Aggregate Functions & Grouping

Granular Tracked Topics (1):

COUNT, SUM, AVG, MIN/MAX, GROUP BY, HAVING

Hands-on Challenge: City-wise Revenue & Customer Spend Aggregator

Aggregate revenue and customer count grouped by city with HAVING filters.

Session 2 • 90 Minutes Live

Session 5: Multi-Table Joins (Part 1)

Granular Tracked Topics (1):

Foreign Keys, INNER JOIN, LEFT & RIGHT JOIN

Session 3 • 90 Minutes Live

Session 6: Multi-Table Joins (Part 2) & Sets

Granular Tracked Topics (1):

FULL OUTER JOIN, Self-Joins, UNION & UNION ALL

Hands-on Challenge: Self-Join Employee-Manager Hierarchy

Query employees and their direct reporting managers using a self-join.

Intermediate Milestone: Hospitality Booking Analytics Suite

Join guests, room bookings, and billing to calculate occupancy rates and repeat customer revenue.

Deliverable: Multi-table analytical SQL queries calculating hospitality KPIs.

Session 1 • 90 Minutes Live

Session 7: Subqueries & Common Table Expressions (CTEs)

Granular Tracked Topics (1):

Nested Subqueries & WITH Clause (CTEs)

Session 2 • 90 Minutes Live

Session 8: Analytical Window Functions

Granular Tracked Topics (1):

OVER(PARTITION BY), ROW_NUMBER, RANK, LEAD, LAG

Hands-on Challenge: Month-over-Month Revenue Growth with LAG()

Calculate MoM growth and top 3 selling items per category using DENSE_RANK().

Session 3 • 90 Minutes Live

Session 9: DDL, Table Constraints & Transactions

Granular Tracked Topics (1):

CREATE TABLE, Constraints, INSERT/UPDATE/DELETE, Transactions

Session 4 • 90 Minutes Live

Session 10: Database Normalization & Indexing

Granular Tracked Topics (1):

1NF/2NF/3NF Rules, B-Tree Indexes & EXPLAIN Plans

Graduation Capstone Portfolio

Full Enterprise Normalized Database & BI Analytics Suite

Design a 3NF normalized schema for a food delivery network, seed records, and build 10 complex queries with window functions and CTEs.

Deliverable:

Complete SQL DDL/DML Schema Script + Documented Query Suite

What You Will Be Able To Do

Write optimized SQL queries against production relational databases

Perform complex multi-table joins, self-joins, and aggregations

Use analytical Window Functions (RANK, ROW_NUMBER, LEAD/LAG) for business metrics

Design 3NF normalized schemas with primary/foreign key constraints and indexes

Prerequisites

Basic computer literacy. No prior database experience required.

SQL — Database Fundamentals

Course Structure & Tracked Topics

Module 1: SQL Basics & Filtering

Session 1: Databases & SQL Syntax

Session 2: Filtering & Sorting Data

Session 3: Advanced Filtering & Pattern Matching

Module 2: Aggregations & Multi-Table Joins

Session 4: Aggregate Functions & Grouping

Session 5: Multi-Table Joins (Part 1)

Session 6: Multi-Table Joins (Part 2) & Sets

Module 3: Subqueries, Window Functions & Schema Design

Session 7: Subqueries & Common Table Expressions (CTEs)

Session 8: Analytical Window Functions

Session 9: DDL, Table Constraints & Transactions

Session 10: Database Normalization & Indexing

Full Enterprise Normalized Database & BI Analytics Suite

What You Will Be Able To Do

Prerequisites