# Introduction to Database Systems

- Institution: IIT Madras
- Department: Computer Science and Engineering
- Teacher: Prof. Sreenivasa Kumar
- Level: Undergraduate
- Language: English
- Subjects: Computer science, Engineering
- Source: [NPTEL](https://nptel.ac.in/courses/106106220)
- Licence: [CC BY-NC-SA](https://nptel.ac.in/faq) (Non-commercial use only.)
- Syllabus: [at the source](https://nptel.ac.in/courses/106106220)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

## Lectures

1. [Introduction](https://invisiblenetwork.ai/learn/nptel/106106220/5bc93014600b) (Video)
2. [Database Architecture](https://invisiblenetwork.ai/learn/nptel/106106220/8295d1865861) (Video)
3. [RDBMS Architecture](https://invisiblenetwork.ai/learn/nptel/106106220/f5d518bd6020) (Video)
4. [Introduction to ER Model](https://invisiblenetwork.ai/learn/nptel/106106220/197b59df3e00) (Video)
5. [Entities and Relationships](https://invisiblenetwork.ai/learn/nptel/106106220/d76860dcbdec) (Video)
6. [Modelling Weak Entities and Design Choices](https://invisiblenetwork.ai/learn/nptel/106106220/492f60f88083) (Video)
7. [Relational Data Model and Notion of Keys](https://invisiblenetwork.ai/learn/nptel/106106220/c9e8030dd0ed) (Video)
8. [Introduction to Relational Algebra](https://invisiblenetwork.ai/learn/nptel/106106220/497cf78b316b) (Video)
9. [Operators in Relational Model](https://invisiblenetwork.ai/learn/nptel/106106220/8e359fe879f3) (Video)
10. [Uses of Renaming, Join and Division in Relation Algebra](https://invisiblenetwork.ai/learn/nptel/106106220/ae0bc1bc2ee9) (Video)
11. [Example Queries in Relation Model and Outer Join Operation](https://invisiblenetwork.ai/learn/nptel/106106220/7d1e5d3c3add) (Video)
12. [Convert ER-Model to a Relational Model](https://invisiblenetwork.ai/learn/nptel/106106220/a8a66b693f61) (Video)
13. [Introduction to tuple relational calculus](https://invisiblenetwork.ai/learn/nptel/106106220/51fb3380af45) (Video)
14. [Example TRC queries](https://invisiblenetwork.ai/learn/nptel/106106220/5d664cc8a8e7) (Video)
15. [Data definition using SQL](https://invisiblenetwork.ai/learn/nptel/106106220/64023a581fb8) (Video)
16. [Basic SQL query block and subqueries](https://invisiblenetwork.ai/learn/nptel/106106220/7040ca34ba90) (Video)
17. [Correlated subqueries](https://invisiblenetwork.ai/learn/nptel/106106220/79871d7284fd) (Video)
18. [Aggregate functions](https://invisiblenetwork.ai/learn/nptel/106106220/2e24bf0408ff) (Video)
19. [Views](https://invisiblenetwork.ai/learn/nptel/106106220/de94b8c5b2db) (Video)
20. [Programmatic access of SQL](https://invisiblenetwork.ai/learn/nptel/106106220/0e29790886bc) (Video)
21. [Normal forms - Introduction](https://invisiblenetwork.ai/learn/nptel/106106220/9b3f78463cef) (Video)
22. [Deriving new functional dependencies](https://invisiblenetwork.ai/learn/nptel/106106220/0126de49437a) (Video)
23. [Proving soundness and completeness of Armstrong's Axioms](https://invisiblenetwork.ai/learn/nptel/106106220/9210a5cb7f81) (Video)
24. [Normal forms - 2 NF, 3NF, BCNF](https://invisiblenetwork.ai/learn/nptel/106106220/c750a482debe) (Video)
25. [Properties of decompositions](https://invisiblenetwork.ai/learn/nptel/106106220/ea72c8a25394) (Video)
26. [Normal forms - 4NF, 5NF](https://invisiblenetwork.ai/learn/nptel/106106220/29dd0217adcf) (Video)
27. [Introduction to file orgranization](https://invisiblenetwork.ai/learn/nptel/106106220/77bc37d7ecdf) (Video)
28. [File orgranization methods](https://invisiblenetwork.ai/learn/nptel/106106220/501baca58c89) (Video)
29. [Dynamic File orgranization using Hashing](https://invisiblenetwork.ai/learn/nptel/106106220/5ef0b7ee769e) (Video)
30. [Index structures](https://invisiblenetwork.ai/learn/nptel/106106220/124cd261c1b6) (Video)
31. [B+ trees on Disks](https://invisiblenetwork.ai/learn/nptel/106106220/8c60ffeab9a7) (Video)
32. [Performance and Reliability of Multiple Disks](https://invisiblenetwork.ai/learn/nptel/106106220/3d10fcb357a9) (Video)
33. [Relational Query Evaluation](https://invisiblenetwork.ai/learn/nptel/106106220/61dd9b509d89) (Video)
34. [Join operator processing algorithms](https://invisiblenetwork.ai/learn/nptel/106106220/bb692e418463) (Video)
35. [Query optimization](https://invisiblenetwork.ai/learn/nptel/106106220/1dfd36809fa5) (Video)
36. [ACID properties and operations in transactions](https://invisiblenetwork.ai/learn/nptel/106106220/fd820f46c715) (Video)
37. [Schdeules](https://invisiblenetwork.ai/learn/nptel/106106220/803cdbf9ead1) (Video)
38. [Concurrency control using Locks](https://invisiblenetwork.ai/learn/nptel/106106220/bc1de2b0fbf5) (Video)
39. [Recovery using undo logging method](https://invisiblenetwork.ai/learn/nptel/106106220/7812bf50fb0b) (Video)
40. [Recovery using Redo and Undo-Redo logging methods](https://invisiblenetwork.ai/learn/nptel/106106220/53354482658f) (Video)
41. [Recoverable schdeules and transaction isolation levels](https://invisiblenetwork.ai/learn/nptel/106106220/241326e3b508) (Video)
42. [Live Session 11-04-2022](https://invisiblenetwork.ai/learn/nptel/106106220/5bc93014600b-2) (Video)
43. [Live Session 18-04-2022](https://invisiblenetwork.ai/learn/nptel/106106220/8295d1865861-2) (Video)