x
Menu

Database Management System

IISc Bangalore, , Prof. D.Janakiram

Updated On 02 Feb, 19

Overview

Introduction to Database Management System - Conceptual Designs - Relational Model - Structured Query Language - ER Model to Relational Mapping - Functional Dependencies and Normal Form - ER Model to Relational Model Maping - Storage Structures - Indexing Techniques Single Level - Indexing Techniques Multi-Level - Constraints and Triggers - Query Processing and Optimization - Transaction Processing Concepts - Transaction Processing and Database Manager - Foundation for Concurrency Control - Concurrency Control Part - 4Distributed Transaction Models - Basic 2-Phase and 3-phase commit protocol - Concurrency Control for Distributed Transaction - Introduction to Transaction Recovery - Recovery Mechanisms - Introduction to Data Warehousing nad OLAP - Case Study : MYSQL - Case Study ORACLE and Microsoft Access - Data Mining and Knowledge Discovery - Object Oriented Databases - XML - Introductory Concepts - XML Advanced Concepts - XML Databases - Case Study - Part One Database DesignCase Study

Includes

Lecture 6: Structured Query Language

4.1 ( 11 )


Lecture Details

Lecture Series on Database Management System by Dr.S.Srinath, IIIT Bangalore. For more details on NPTEL visit httpnptel.iitm.ac.in

Ratings

4.0


10 Ratings
55%
30%
10%
3%
2%
Comments
comment person image

Sam

Excellent course helped me understand topic that i couldn't while attendinfg my college.

Reply
comment person image

Dembe

Great course. Thank you very much.

Reply
Send