
Lecture 25 of 41 · Introduction to Database Systems
Sreenivasa Kumar
Introduction to Database Systems · 41 lectures
41 lectures
Lecture 1
2: Database Architecture
3: RDBMS Architecture
4: Introduction to ER Model
5: Entities & Relationships
6: Modelling Weak Entities & Design Choices
7: Relational Data Model & Notion of Keys
8: Introduction to Relational Algebra
9: Operators in Relational Model
10: Uses of Renaming, Join & Division in Relation Algebra
11: Example Queries in Relational Model & Outer Join Operation
12: Convert ER-Model to a Relational Model
13: Introduction to Tuple Relational Calculus
14: Example TRC Queries
15: Data Definition using SQL
16: Basic SQL Query block & Subqueries
17: Correlated Subqueries
18: Aggregate Functions
19: Views
20: Programmatic Access of SQL
21: Normal forms - Introduction
22: Deriving New Functional Dependencies
23: Proving Soundness & Completeness of Armstrong’s Axioms
24: Normal forms - 2NF, 3NF, BCNF
25: Properties of Decompositions
26: Normal forms - 4NF, 5NF
27: Introduction to File Orgranization
28: File Orgranization Methods
29: Dynamic File Orgranization Using Hashing
30: Index Structures
31: B+Trees on Disks
32: Performance & Reliability of Multiple Disks
33: Relational Query Evaluation
34: Join Operator Processing Algorithms
35: Query Optimization
36: ACID Properties & Operations in Transactions
37: Schedules
38: Concurrency Control Using Locks
39: Recovery Using Undo Logging Method
40: Recovery Using Redo & Undo-Redo Logging Methods
41: Recoverable Schedules & Transaction Isolation Levels