1
Database Design. Instructor: Prof. D. Janakiram and Dr. S. Srinath, Department of Computer Science and Engineering, IIT Madras
FREE
This course includes
Hours of videos
1166 years, 6 months
Units & Quizzes
43
Unlimited Lifetime access
Access on mobile app
Certificate of Completion
This course provides an introduction to database systems, covering topics: Semantic Database Design; Relational Model, Languages and Systems; Database Design using the Relational Model; Storage and Indexing Structures; Transaction Processing and Concurrency Control; Database Recovery Techniques; Query Processing and Optimization; Database Security and Authorization; Enhanced Data Models for Specific Applications; Distributed Databases and Issues. (from nptel.ac.in
Course Currilcum
- Lecture 01 – Introduction to Database Management System Unlimited
- Lecture 01a – Conceptual Design using the ER (Entity Relationship) Model Unlimited
- Lecture 02 – Conceptual Design (cont.) Unlimited
- Lecture 03 – The Relational Model and Relational Algebra Unlimited
- Lecture 04 – The Relational Model and Relational Algebra (cont.) Unlimited
- 00:00:00
- Lecture 06 – Structured Query Language (cont.) Unlimited
- Lecture 07 – ER Model to Relational Mapping Unlimited
- Lecture 08 – Functional Dependencies and Normal Forms Unlimited
- Lecture 09 – ER Model to Relational Model Mapping Unlimited
- Lecture 10 – Storage Structures Unlimited
- Lecture 11 – Indexing Techniques: Single Level Unlimited
- Lecture 12 – Indexing Techniques: Multi-Level and Dynamic Indexes Unlimited
- Lecture 13 – Constraints and Triggers Unlimited
- Lecture 14 – Query Processing and Optimization Unlimited
- Lecture 15 – Query Processing and Optimization (cont.) Unlimited
- Lecture 16 – Query Processing and Optimization (cont.) Unlimited
- Lecture 17 – Transaction Processing Concepts Unlimited
- Lecture 18 – Transaction Processing and Database Manager Unlimited
- Lecture 19 – Foundation for Concurrency Control Unlimited
- Lecture 20 – Concurrency Control, Part 1 Unlimited
- Lecture 21 – Concurrency Control, Part 2 Unlimited
- Lecture 22 – Concurrency Control, Part 3 Unlimited
- Lecture 23 – Concurrency Control, Part 4 Unlimited
- Lecture 24 – Distributed Transaction Models Unlimited
- Lecture 25 – Basic 2-Phase and 3-Phase Commit Protocol Unlimited
- Lecture 26 – Concurrency Control for Distributed Transaction Unlimited
- Lecture 27 – Introduction to Transaction Recovery Unlimited
- Lecture 28 – Recovery Mechanisms (cont.) Unlimited
- Lecture 29 – Recovery Mechanisms (cont.) Unlimited
- Lecture 30 – Introduction to Data Warehousing and OLAP Unlimited
- Lecture 31 – Introduction to Data Warehousing and OLAP (cont.) Unlimited
- Lecture 32 – DBMS Case Study: MySQL Unlimited
- Lecture 33 – DBMS Case Study: ORACLE and Microsoft Access Unlimited
- Lecture 34 – Data Mining and Knowledge Discovery Unlimited
- Lecture 35 – Data Mining and Knowledge Discovery (cont.) Unlimited
- Lecture 36 – Object Oriented Databases Unlimited
- Lecture 37 – Object Oriented Databases (cont.) Unlimited
- Lecture 38 – XML – Introductory Concepts Unlimited
- Lecture 39 – XML – Advanced Concepts Unlimited
- Lecture 40 – XML Databases and Managing Semi-structured Data Unlimited
- Lecture 41 – Case Study: Database Design, Part 1 Unlimited
- Lecture 42 – Case Study: Database Design, Part 2 Unlimited
