0

(

ratings

)

1

students

Created by:

Profile Photo

Last updated:

September 25, 2023

Duration:

Unlimited Duration

FREE

This course includes:

Unlimited Duration

Badge on Completion

Certificate of completion

Unlimited Duration

Description

Database Design. Instructor: Prof. D. Janakiram and Dr. S. Srinath, Department of Computer Science and Engineering, IIT Madras

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 Curriculum

  • 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

About the instructor

5 5

Instructor Rating

6

Reviews

4637

Courses

24151

Students

Profile Photo
OpenCoursa
We are an educational and skills marketplace to accommodate the needs of skills enhancement and free equal education across the globe to the millions. We are bringing courses and trainings every single day for our users. We welcome everyone woth all ages, all background to learn. There is so much available to learn and deliver to the people.