Database Design-This course covers database design and the use of database management systems for applications

This course covers database design and the use of database management systems for applications

Database Design

This course covers database design and the use of database management systems for applications

A brief summary

Database design is very important  to effectively implement a relational database. In this course we discuss the parts of a database, how to model data, database construction, SQL, and many aspects that are crucial in designing a database. These skills are fundamental to managing database  applications.

Instructor:

NPTEL

What you will learn

Introductory Concepts and Symantic Database Design

Relational Models , Languages and Systems

Storage and Indexing Structures

Query Processing and Optimization

Transaction Processing and Concurrency Control

Database recovery techniques

Data Warehousing

Data Mining

XML

Course Fee: Free

Certification By: Not Certified

Introductory Concepts and Symantic Database Design, Relational Models , Languages and Systems

Introduction to Database Management System, Conceptual Design, Structured Query Language, Functional Dependencies and Normal Form, ER Model to Relational Mapping

Storage and Indexing Structures, Query Processing and Optimization

Storage Structures, Indexing Techniques, Constraints and Triggers, Query Processing and Optimization

Transaction Processing and Concurrency Control, Database recovery techniques

Transaction Processing Concepts, Transaction Processing and Database Manager, Foundation or Concurrency Control, Concurrency Control , Distributed Transaction Model, Basic 2-Phase and 3-Phase commit protocol, Concurrency Control for Distributed Transaction,Introduction to Transaction Recovery, Recovery Mechanism

Data Warehousing, Data Mining

Introduction to Datawarehousing and OLAP-1, Case Study- MYSQL, Case Study: Oracle and Microsoft Access, Data Mining and Knowledge Discovery, Object Oriented Databases

XML

XML Introductory Concepts,XML Advanced Concepts, XML Databases, Case Study Part 1 Database Design, Case Study Part 2 Database Design

Back to top