PGDM Core Subject
Database Management with SQL
Course Objective
Primary Mapping: PO1 (Mgmt Knowledge) & PO2 (Critical Thinking). Textbook: Database System Concepts by Silberschatz, Korth, and Sudarshan.
Evaluation Scheme
- 6 Assignments: 30 Marks (5 Marks each).
- Class Participation: 20 Marks.
- Mid Term: 20 Marks.
- End Term: 30 Marks.
|
Session |
Session Name |
Pre-Reading (Approx. Pages) |
Assignment (5M) |
|
1 |
The Evolution: Excel to SQL |
Ch 1: Introduction (pp. 1-20) |
|
|
2 |
Relational Model Concepts |
Ch 2: Relational Model (pp. 27-45) |
A1: Schema Mapping |
|
3 |
SQL Data Definition (DDL) |
Ch 3: SQL Basics (pp. 55-70) |
|
|
4 |
Data Manipulation (DML) |
Ch 3: Selection/Insertion (pp. 71-90) |
A2: DB Creation |
|
5 |
The WHERE Clause & Logic |
Ch 3: Predicates (pp. 91-105) |
|
|
6 |
Aggregate Functions |
Ch 4: Intermediate SQL (pp. 110-125) |
A3: Sales Summary |
|
7 |
GROUP BY & HAVING |
Ch 4: Grouping (pp. 126-140) |
|
|
8 |
Joining Tables - I (Inner) |
Ch 4: Join Expressions (pp. 141-155) |
A4: Multi-table Query |
|
9 |
Joining Tables - II (Outer) |
Ch 4: Left/Right Joins (pp. 156-170) |
|
|
10 |
Mid Term Practical |
Review Sessions 1-9 |
Mid Term (20M) |
|
11 |
Subqueries & Nested Logic |
Ch 5: Advanced SQL (pp. 180-200) |
|
|
12 |
Set Operations (UNION/INTERSECT) |
Ch 3: Set Operations (pp. 106-115) |
A5: Data Merging |
|
13 |
String & Date Functions |
Ch 5: Functions (pp. 201-215) |
|
|
14 |
Views & Integrity Constraints |
Ch 4: Integrity (pp. 160-175) |
A6: View Design |
|
15 |
Indexing for Speed |
Ch 11: Indexing (pp. 480-500) |
|
|
16 |
ACID Properties |
Ch 14: Transactions (pp. 625-640) |
|
|
17 |
SQL for Power BI Integration |
Technical Note: API Connections |
|
|
18 |
Data Cleaning with SQL |
Technical Note: Handling Nulls |
|
|
19 |
Capstone: Building a Retail DB |
Case Study: E-commerce Schema |
|
|
20 |
Final Defense |
Comprehensive Review |
End Term (30M) |