IIT Kanpur · Computer Science
Fundamentals of Database Systems(Course sponsored by Aricent)
Prof. Arnab Bhattacharya · 48 free video lectures
48 video lectures. Topics: Introduction to Databases; Relational Data Model; Relational Algebra Basic Operators; Relational Algebra Composition of Operators; Relational Algebra Additional Operators; Relational Algebra Extended Relational Algebra; Relational Algebra: Database Modifications; SQL…
▶ Play on Open Lecture HallCourse page ↗
Lectures
- Introduction to Databases
- Relational Data Model
- Relational Algebra Basic Operators
- Relational Algebra Composition of Operators
- Relational Algebra Additional Operators
- Relational Algebra Extended Relational Algebra
- Relational Algebra: Database Modifications
- SQL: Introduction and Data Definition
- SQL: Basic Queries
- SQL: Advanced Queries
- SQL: Updates, Joins, Views and Triggers
- Normalization Theory: Motivation
- Normalization Theory: 1 NF and 2NF
- Normalization Theory: 3NF
- Normalization Theory: BCNF
- Normalization Theory: MVD
- Physical Design
- Database Indexing: Hashing
- Database Indexing: Tree-based Indexing
- Query Processing: Selection
- Query Processing: Sorting
- Query Processing: Nested-Loop joins and Merge join
- Query Processing: Hash join and other Operations
- Query Optimization: Equivalent Expressions and Simple Equivalance Rules
- Query Optimization: Complex Equivalence Rules
- Query Optimization: Join Order
- Query Optimization: Heuristics and Sizes
- Database Transactions: Properties and Failures
- Database Transactions: States and Systems
- Recovery Systems: Deferred Database Modification
- Recovery Systems: Immediate Database Modification.
- Recovery Systems: Checkpointing and Shadow Paging
- Schedules: Introduction
- Schedules: Conflict Serializability
- Schedules: View Serializability
- Schedules: Result Equivalence and Testing for Serializability
- Schedules: Recoverability
- Concurrency Control: Locks
- Concurrency Control: Two-phase Locking Protocol
- Concurrency Control: Timestamp Ordering Protocol
- Concurrency Control: Validation-based Protocol
- Concurrency Control: Multiple Granularity for Locks
- Concurrency Control: Deadlock Prevention and Deadlock Detection
- Concurrency Control: Deadlock Recovery and Update Operations
- NoSQL: Introduction and Properties
- NoSQL: Columnar Families
- NoSQL: Different NoSQL Systems
- Big Data
From NPTEL (IITs and IISc) · CC BY-NC-SA. More from IIT Kanpur.
Open Lecture Hall is free, with no ads and no sign-up. It is not run by or connected to any university; the lectures are the universities' own free recordings, played from where they host them. About & rights