Week 2: Relational Model & Basic SQL
2.3 Intro to SQL/3
DBMS Notes - IITM
Home
Week 1: Introduction
1.1 Course Overview
1.2 Why DBMS?/1
1.3 Why DBMS?/2
1.4 Intro to DBMS - 1
1.5 Intro to DBMS - 2
Week 2: Relational Model & Basic SQL
2.1 Intro to Relational Model/1
2.2 Intro to Relational Model/2
2.3 Intro to SQL
2.4 Intro to SQL/2
2.3 Intro to SQL/3
Week 3: Advanced SQL
3.1 SQL Examples
3.2 Intermediate SQL/1
3.3 Intermediate SQL/2
3.4 Intermediate SQL/3
3.5 Advanced SQL
Week 4: Relational Query Languages & ER Model
4.1 Relational Algebra
4.2 Relational Calculus
4.3 Entity-Relationship Model/1
4.4 Entity-Relationship Model/2
4.5 Entity-Relationship Model/3
Week 5: Relational Database Design
5.1 Good Database Design
5.2 Functional Dependencies
5.3 FD Theory, BCNF & 3NF
5.4 Algorithms for Functional Dependencies
5.5 Lossless Join & Dependency Preservation
Week 6: Normalization & Database Design
6.1 Normal Forms
6.2 Decomposition Algorithms
6.3 LIS Case Study
6.4 MVD & 4NF
6.5 Design Process & Temporal Data
Week 7: Application Development
7.1 Application Architecture
7.2 Web Technologies
7.3 SQL & Native Language
7.4 Python & PostgreSQL
7.5 RAD, Performance & Security
Week 8: Storage, Indexing & Query Processing
8.1 Data Storage
8.2 File Organization
8.3 Indexing
8.4 B+ Tree Index
8.5 Hash Index
Week 9: Advanced Indexing
9.1 Ordered Indexing
9.2 2-3-4 Trees
9.3 B+ Tree & B-Tree
9.4 Static & Dynamic Hashing
9.5 Index Design in SQL
Week 10: Transactions & Concurrency
10.1 Transaction Concept & ACID
10.2 Serializability
10.3 Recoverability & TCL
10.4 Lock-based Protocols
10.5 Deadlock & Timestamp Protocols
Week 11: Backup, Recovery & RAID
11.1 Backup Concepts & Strategies
11.2 Failure Classification & Log-based Recovery
11.3 Logging, Checkpoints & Recovery Algorithm
11.4 Recovery with Early Lock Release
11.5 RAID
Week 12: Query Optimization & Big Data
12.1 Query Processing
12.2 Query Optimization
12.3 Performance & Scalability
12.4 Big Data & NoSQL
12.5 Course Summary & RDBMS Landscape
On this page
Set Operations
Week 2: Relational Model & Basic SQL
2.3 Intro to SQL/3
2.5 Intro to SQL/3
Set Operations