BTech / BCA Track6 Weeks CohortTopic-Linked Attendance Enabled
SQL — Database Fundamentals
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
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 & Jupyter notebooks
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
Session 1: Databases & SQL Syntax
90 mins
Attendance-Tracked Topics (1):
1RDBMS Concepts, Tables & SELECT Queries
Session 2
Session 2: Filtering & Sorting Data
90 mins
Attendance-Tracked Topics (1):
1WHERE, Comparison Operators, ORDER BY, LIMIT
🎯 Hands-on Mini Task:High-Value Orders Filter
Extract orders > ₹10,000 sorted by latest transaction timestamp.
Session 3
Session 3: Advanced Filtering & Pattern Matching
90 mins
Attendance-Tracked Topics (1):
1IN, 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 4
Session 4: Aggregate Functions & Grouping
90 mins
Attendance-Tracked Topics (1):
1COUNT, SUM, AVG, MIN/MAX, GROUP BY, HAVING
🎯 Hands-on Mini Task:City-wise Revenue & Customer Spend Aggregator
Aggregate revenue and customer count grouped by city with HAVING filters.
Session 5
Session 5: Multi-Table Joins (Part 1)
90 mins
Attendance-Tracked Topics (1):
1Foreign Keys, INNER JOIN, LEFT & RIGHT JOIN
Session 6
Session 6: Multi-Table Joins (Part 2) & Sets
90 mins
Attendance-Tracked Topics (1):
1FULL OUTER JOIN, Self-Joins, UNION & UNION ALL
🎯 Hands-on Mini Task: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 7
Session 7: Subqueries & Common Table Expressions (CTEs)
90 mins
Attendance-Tracked Topics (1):
1Nested Subqueries & WITH Clause (CTEs)
Session 8
Session 8: Analytical Window Functions
90 mins
Attendance-Tracked Topics (1):
1OVER(PARTITION BY), ROW_NUMBER, RANK, LEAD, LAG
🎯 Hands-on Mini Task:Month-over-Month Revenue Growth with LAG()
Calculate MoM growth and top 3 selling items per category using DENSE_RANK().
Session 9
Session 9: DDL, Table Constraints & Transactions
90 mins
Attendance-Tracked Topics (1):
1CREATE TABLE, Constraints, INSERT/UPDATE/DELETE, Transactions
Session 10
Session 10: Database Normalization & Indexing
90 mins
Attendance-Tracked Topics (1):
11NF/2NF/3NF Rules, B-Tree Indexes & EXPLAIN Plans
Graduation Capstone
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.
Unsure if this fits your current grade?
Schedule a 10-minute discovery call with our academic advisor.