Completed
Introduction
Class Central Classrooms beta
YouTube playlists curated by Class Central.
Classroom Contents
Introduction to Database Systems
Automatically move to the next video in the Classroom when playback concludes
- 1 Introduction
- 2 Database Architecture
- 3 RDBMS Architecture
- 4 Introduction to ER Model
- 5 Entities and Relationships
- 6 Modelling Weak Entities and Design Choices
- 7 Relational Data Model and Notion of Keys
- 8 Introduction to Relational Algebra
- 9 Operators in Relational Model
- 10 Uses of Renaming, Join and Division in Relation Algebra
- 11 Example Queries in Relation Model and 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 and 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 and completeness of Armstrong's Axioms
- 24 Normal forms - 2 NF, 3NF, BCNF
- 25 Properties of decompositions
- 26 Normal forms - 4NF, 5NF
- 27 File orgranization methods
- 28 File orgranization methods
- 29 Dynamic File orgranization using Hashing
- 30 Index Structures
- 31 B+ trees on Disks
- 32 Performance and Reliability of Multiple Disks
- 33 Relational Query Evaluation
- 34 Join Operator Processing Algorithms
- 35 Query optimization
- 36 ACID properties and operations in transactions
- 37 Schdeules
- 38 Concurrency control using Locks
- 39 Recovery using undo logging method
- 40 Recovery using Redo and Undo-Redo logging methods
- 41 Recoverable schdeules and transaction isolation levels
