Learn · NPTEL

Course10610622043 lectures

Introduction to Database Systems

Prof. Sreenivasa Kumar · IIT Madras

Start with lecture 1 At NPTEL

Lectures

Week 1

  1. Introduction Video
  2. Database Architecture Video
  3. RDBMS Architecture Video

Week 2

  1. Introduction to ER Model Video
  2. Entities and Relationships Video
  3. Modelling Weak Entities and Design Choices Video

Week 3

  1. Relational Data Model and Notion of Keys Video
  2. Introduction to Relational Algebra Video
  3. Operators in Relational Model Video
  4. Uses of Renaming, Join and Division in Relation Algebra Video

Week 4

  1. Example Queries in Relation Model and Outer Join Operation Video
  2. Convert ER-Model to a Relational Model Video
  3. Introduction to tuple relational calculus Video
  4. Example TRC queries Video

Week 5

  1. Data definition using SQL Video
  2. Basic SQL query block and subqueries Video
  3. Correlated subqueries Video

Week 6

  1. Aggregate functions Video
  2. Views Video
  3. Programmatic access of SQL Video

Week 7

  1. Normal forms - Introduction Video
  2. Deriving new functional dependencies Video
  3. Proving soundness and completeness of Armstrong's Axioms Video

Week 8

  1. Normal forms - 2 NF, 3NF, BCNF Video
  2. Properties of decompositions Video
  3. Normal forms - 4NF, 5NF Video

Week 9

  1. Introduction to file orgranization Video
  2. File orgranization methods Video
  3. Dynamic File orgranization using Hashing Video
  4. Index structures Video

Week 10

  1. B+ trees on Disks Video
  2. Performance and Reliability of Multiple Disks Video
  3. Relational Query Evaluation Video

Week 11

  1. Join operator processing algorithms Video
  2. Query optimization Video
  3. ACID properties and operations in transactions Video
  4. Schdeules Video

Week 12

  1. Concurrency control using Locks Video
  2. Recovery using undo logging method Video
  3. Recovery using Redo and Undo-Redo logging methods Video
  4. Recoverable schdeules and transaction isolation levels Video

Live Session

  1. Live Session 11-04-2022 Video
  2. Live Session 18-04-2022 Video

Syllabus and materials

At NPTEL, as the course publishes them.

Credits and licence

Institution
IIT Madras
Department
Computer Science and Engineering
Teacher
Prof. Sreenivasa Kumar
Level
Undergraduate
Language
English
Subjects
Computer science, Engineering
Source
NPTEL
Licence
CC BY-NC-SA, as NPTEL states it. Non-commercial use only. NPTEL's terms
Attribution
NPTEL states: "Distributed under Creative Commons Attribution-ShareAlike / CC BY - NC - SA", beside a BY-NC-SA badge.
Who can watch
NPTEL gives no rating. Invisible Network shows it to Tweens profiles and older, judged from what the source says about it. How courses are placed