# Fundamentals of Database Systems

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

## Lectures

1. [Introduction to Databases](https://invisiblenetwork.ai/learn/nptel/106104135/7533e2af9fd8) (Video)
2. [Relational Data Model](https://invisiblenetwork.ai/learn/nptel/106104135/f4470f56edc8) (Video)
3. [Relational Algebra Basic Operators](https://invisiblenetwork.ai/learn/nptel/106104135/2d0003eea378) (Video)
4. [Relational Algebra Composition of Operators](https://invisiblenetwork.ai/learn/nptel/106104135/b80626057669) (Video)
5. [Relational Algebra Additional Operators](https://invisiblenetwork.ai/learn/nptel/106104135/3356a560ebb5) (Video)
6. [Relational Algebra Extended Relational Algebra](https://invisiblenetwork.ai/learn/nptel/106104135/eb14895919ea) (Video)
7. [Relational Algebra: Database Modifications](https://invisiblenetwork.ai/learn/nptel/106104135/dc1598341eb3) (Video)
8. [SQL: Introduction and Data Definition](https://invisiblenetwork.ai/learn/nptel/106104135/a48ad2f01b45) (Video)
9. [SQL: Basic Queries](https://invisiblenetwork.ai/learn/nptel/106104135/1faf952cd4d5) (Video)
10. [SQL: Advanced Queries](https://invisiblenetwork.ai/learn/nptel/106104135/65ffccd98de0) (Video)
11. [SQL: Updates, Joins, Views and Triggers](https://invisiblenetwork.ai/learn/nptel/106104135/c6693f125318) (Video)
12. [Normalization Theory: Motivation](https://invisiblenetwork.ai/learn/nptel/106104135/336802f15dfb) (Video)
13. [Normalization Theory: 1 NF and 2NF](https://invisiblenetwork.ai/learn/nptel/106104135/4d98107a8434) (Video)
14. [Normalization Theory: 3NF](https://invisiblenetwork.ai/learn/nptel/106104135/cd9e22d7b56b) (Video)
15. [Normalization Theory: BCNF](https://invisiblenetwork.ai/learn/nptel/106104135/91d811abc7fa) (Video)
16. [Normalization Theory: MVD](https://invisiblenetwork.ai/learn/nptel/106104135/c058201697cf) (Video)
17. [Physical Design](https://invisiblenetwork.ai/learn/nptel/106104135/c4de186d8fde) (Video)
18. [Database Indexing: Hashing](https://invisiblenetwork.ai/learn/nptel/106104135/8a9ac0b0d710) (Video)
19. [Database Indexing: Tree-based Indexing](https://invisiblenetwork.ai/learn/nptel/106104135/0149d9f266d4) (Video)
20. [Query Processing: Selection](https://invisiblenetwork.ai/learn/nptel/106104135/5bbd6a93da7c) (Video)
21. [Query Processing: Sorting](https://invisiblenetwork.ai/learn/nptel/106104135/a647a2d3b83b) (Video)
22. [Query Processing: Nested-Loop joins and Merge join](https://invisiblenetwork.ai/learn/nptel/106104135/308ae40311ce) (Video)
23. [Query Processing: Hash join and other Operations](https://invisiblenetwork.ai/learn/nptel/106104135/4aa2c202acc0) (Video)
24. [Query Optimization: Equivalent Expressions and Simple Equivalance Rules](https://invisiblenetwork.ai/learn/nptel/106104135/cfd12d81aa72) (Video)
25. [Query Optimization: Complex Equivalence Rules](https://invisiblenetwork.ai/learn/nptel/106104135/cd385d2081cf) (Video)
26. [Query Optimization: Join Order](https://invisiblenetwork.ai/learn/nptel/106104135/e9fefea9c6f9) (Video)
27. [Query Optimization: Heuristics and Sizes](https://invisiblenetwork.ai/learn/nptel/106104135/9dfc8c01ba9a) (Video)
28. [Database Transactions: Properties and Failures](https://invisiblenetwork.ai/learn/nptel/106104135/3d2df49c59bf) (Video)
29. [Database Transactions: States and Systems](https://invisiblenetwork.ai/learn/nptel/106104135/d3e3c682f527) (Video)
30. [Recovery Systems: Deferred Database Modification](https://invisiblenetwork.ai/learn/nptel/106104135/77761beeffce) (Video)
31. [Recovery Systems: Immediate Database Modification.](https://invisiblenetwork.ai/learn/nptel/106104135/8013c934f1aa) (Video)
32. [Recovery Systems: Checkpointing and Shadow Paging](https://invisiblenetwork.ai/learn/nptel/106104135/5fa1338bb857) (Video)
33. [Schedules: Introduction](https://invisiblenetwork.ai/learn/nptel/106104135/dd89bdf1f725) (Video)
34. [Schedules: Conflict Serializability](https://invisiblenetwork.ai/learn/nptel/106104135/bfaffde52985) (Video)
35. [Schedules: View Serializability](https://invisiblenetwork.ai/learn/nptel/106104135/f77f879820ba) (Video)
36. [Schedules: Result Equivalence and Testing for Serializability](https://invisiblenetwork.ai/learn/nptel/106104135/50fa352516f7) (Video)
37. [Schedules: Recoverability](https://invisiblenetwork.ai/learn/nptel/106104135/5a38a0f356b2) (Video)
38. [Concurrency Control: Locks](https://invisiblenetwork.ai/learn/nptel/106104135/7e27a8725d34) (Video)
39. [Concurrency Control: Two-phase Locking Protocol](https://invisiblenetwork.ai/learn/nptel/106104135/79bb6a135bed) (Video)
40. [Concurrency Control: Timestamp Ordering Protocol](https://invisiblenetwork.ai/learn/nptel/106104135/a2a61ed46797) (Video)
41. [Concurrency Control: Validation-based Protocol](https://invisiblenetwork.ai/learn/nptel/106104135/5a9a49ea7815) (Video)
42. [Concurrency Control: Multiple Granularity for Locks](https://invisiblenetwork.ai/learn/nptel/106104135/3a686ba907fe) (Video)
43. [Concurrency Control: Deadlock Prevention and Deadlock Detection](https://invisiblenetwork.ai/learn/nptel/106104135/6f92a2f66cc6) (Video)
44. [Concurrency Control: Deadlock Recovery and Update Operations](https://invisiblenetwork.ai/learn/nptel/106104135/8f6de52e3d66) (Video)
45. [NoSQL: Introduction and Properties](https://invisiblenetwork.ai/learn/nptel/106104135/9b537b264a18) (Video)
46. [NoSQL: Columnar Families](https://invisiblenetwork.ai/learn/nptel/106104135/a6f760304f30) (Video)
47. [NoSQL: Different NoSQL Systems](https://invisiblenetwork.ai/learn/nptel/106104135/9d9d136f744f) (Video)
48. [Big Data](https://invisiblenetwork.ai/learn/nptel/106104135/c02eb087f778) (Video)