Learn · Introduction to Database Systems

Lecture 17 of 43Week 5

Correlated subqueries

Prof. Sreenivasa Kumar · IIT Madras

Credits and licence

From
Introduction to Database Systems, IIT Madras (at NPTEL)
Licence
CC BY-NC-SA, as NPTEL states it. Non-commercial use only.
Attribution
NPTEL states: "Distributed under Creative Commons Attribution-ShareAlike / CC BY - NC - SA", beside a BY-NC-SA badge.
Who can watch
Tweens profiles and older. How courses are placed

All the lectures

  1. Introduction Video
  2. Database Architecture Video
  3. RDBMS Architecture Video
  4. Introduction to ER Model Video
  5. Entities and Relationships Video
  6. Modelling Weak Entities and Design Choices Video
  7. Relational Data Model and Notion of Keys Video
  8. Introduction to Relational Algebra Video
  9. Operators in Relational Model Video
  10. Uses of Renaming, Join and Division in Relation Algebra Video
  11. Example Queries in Relation Model and Outer Join Operation Video
  12. Convert ER-Model to a Relational Model Video
  13. Introduction to tuple relational calculus Video
  14. Example TRC queries Video
  15. Data definition using SQL Video
  16. Basic SQL query block and subqueries Video
  17. Correlated subqueries Video
  18. Aggregate functions Video
  19. Views Video
  20. Programmatic access of SQL Video
  21. Normal forms - Introduction Video
  22. Deriving new functional dependencies Video
  23. Proving soundness and completeness of Armstrong's Axioms Video
  24. Normal forms - 2 NF, 3NF, BCNF Video
  25. Properties of decompositions Video
  26. Normal forms - 4NF, 5NF Video
  27. Introduction to file orgranization Video
  28. File orgranization methods Video
  29. Dynamic File orgranization using Hashing Video
  30. Index structures Video
  31. B+ trees on Disks Video
  32. Performance and Reliability of Multiple Disks Video
  33. Relational Query Evaluation Video
  34. Join operator processing algorithms Video
  35. Query optimization Video
  36. ACID properties and operations in transactions Video
  37. Schdeules Video
  38. Concurrency control using Locks Video
  39. Recovery using undo logging method Video
  40. Recovery using Redo and Undo-Redo logging methods Video
  41. Recoverable schdeules and transaction isolation levels Video
  42. Live Session 11-04-2022 Video
  43. Live Session 18-04-2022 Video