IISc Bangalore · Computer Science

Database Design

Dr. S. Srinath, Prof. D. Janaki Ram · 43 free video lectures

43 video lectures. Topics: Introduction to Database Management System; Conceptual Designs; Relational Model; Structured Query Language; Structured Query Language II; ER Model to Relational Mapping; Functional Dependencies and Normal Form; ER Model to Relational Model Mapping; Storage Structures…

▶ Play on Open Lecture HallCourse page ↗

Lectures

  1. Introduction to Database Management System
  2. Conceptual Designs
  3. Conceptual Designs
  4. Relational Model
  5. Relational Model
  6. Structured Query Language
  7. Structured Query Language II
  8. ER Model to Relational Mapping
  9. Functional Dependencies and Normal Form
  10. ER Model to Relational Model Mapping
  11. Storage Structures
  12. Indexing Techniques Single Level
  13. Indexing Techniques Multi-Level
  14. Constraints and Triggers
  15. Query Processing and Optimization
  16. Query Processing and Optimization II
  17. Query Processing and Optimization - III
  18. Transaction Processing Concepts
  19. Transaction Processing and Database Manager
  20. Foundation for Concurrency Control
  21. Concurrency Control Part - I
  22. Concurrency Control Part - 2
  23. Concurrency Control Part - 3
  24. Concurrency Control Part - 4
  25. Distributed Transaction Models
  26. Basic 2-Phase and 3-phase commit protocol
  27. Concurrency Control for Distributed Transaction
  28. Introduction to Transaction Recovery
  29. Recovery Mechanisms II
  30. Recovery Mechanisms III
  31. Introduction to Data Warehousing and OLAP
  32. Introduction to Data Warehousing and OLAP
  33. Case Study : MYSQL
  34. Case Study ORACLE and Microsoft Access
  35. Data Mining and Knowledge Discovery
  36. Data Mining and Knowledge Discovery Part II
  37. Object Oriented Databases
  38. Object Oriented Databases II
  39. XML - Introductory Concepts
  40. XML Advanced Concepts
  41. XML Databases
  42. Case Study - Part One Database Design
  43. Case Study - Part 2 Database Design

From NPTEL (IITs and IISc) · CC BY-NC-SA. More from IISc Bangalore.

Open Lecture Hall is free, with no ads and no sign-up. It is not run by or connected to any university; the lectures are the universities' own free recordings, played from where they host them. About & rights