Media Storage Type : 32 GB USB Stick
NPTEL Subject Matter Expert : Dr. Arnab Bhattacharya
NPTEL Co-ordinating Institute : IIT Kanpur
NPTEL Lecture Count : 48
NPTEL Course Size : 3.1 GB
NPTEL PDF Text Transcription : Available and Included
NPTEL Subtitle Transcription : Available and Included (SRT)
Lecture Titles:
Lecture 1 - Introduction to Databases
Lecture 2 - Relational Data Model
Lecture 3 - Relational Algebra Basic Operators
Lecture 4 - Relational Algebra Composition of Operators
Lecture 5 - Relational Algebra Additional Operators
Lecture 6 - Relational Algebra Extended Relational Algebra
Lecture 7 - Relational Algebra: Database Modifications
Lecture 8 - SQL: Introduction and Data Definition
Lecture 9 - SQL: Basic Queries
Lecture 10 - SQL: Advanced Queries
Lecture 11 - SQL: Updates, Joins, Views and Triggers
Lecture 12 - Normalization Theory: Motivation
Lecture 13 - Normalization Theory: 1 NF and 2NF
Lecture 14 - Normalization Theory: 3NF
Lecture 15 - Normalization Theory: BCNF
Lecture 16 - Normalization Theory: MVD
Lecture 17 - Physical Design
Lecture 18 - Database Indexing: Hashing
Lecture 19 - Database Indexing: Tree-based Indexing
Lecture 20 - Query Processing: Selection
Lecture 21 - Query Processing: Sorting
Lecture 22 - Query Processing: Nested-Loop joins and Merge join
Lecture 23 - Query Processing: Hash join and other Operations
Lecture 24 - Query Optimization: Equivalent Expressions and Simple Equivalance Rules
Lecture 25 - Query Optimization: Complex Equivalence Rules
Lecture 26 - Query Optimization: Join Order
Lecture 27 - Query Optimization: Heuristics and Sizes
Lecture 28 - Database Transactions: Properties and Failures
Lecture 29 - Database Transactions: States and Systems
Lecture 30 - Recovery Systems: Deferred Database Modification
Lecture 31 - Recovery Systems: Immediate Database Modification.
Lecture 32 - Recovery Systems: Checkpointing and Shadow Paging
Lecture 33 - Schedules: Introduction
Lecture 34 - Schedules: Conflict Serializability
Lecture 35 - Schedules: View Serializability
Lecture 36 - Schedules: Result Equivalence and Testing for Serializability
Lecture 37 - Schedules: Recoverability
Lecture 38 - Concurrency Control: Locks
Lecture 39 - Concurrency Control: Two-phase Locking Protocol
Lecture 40 - Concurrency Control: Timestamp Ordering Protocol
Lecture 41 - Concurrency Control: Validation-based Protocol
Lecture 42 - Concurrency Control: Multiple Granularity for Locks
Lecture 43 - Concurrency Control: Deadlock Prevention and Deadlock Detection
Lecture 44 - Concurrency Control: Deadlock Recovery and Update Operations
Lecture 45 - NoSQL: Introduction and Properties
Lecture 46 - NoSQL: Columnar Families
Lecture 47 - NoSQL: Different NoSQL Systems
Lecture 48 - Big Data