Structured Query Language Video Lecture, IIT Madras

Home »Computer Science »IIT Madras » Database Design

Database Design

Lecture 6: Structured Query Language

Download:   mp3 download MP4,FLV & 3GP 18535 views

SEE: Guide to Download NPTEL Video Lecture

Lecture Details :

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

Course Description :

Introduction to Database Management System - Conceptual Designs-Relational Model - Structured Query Language - ER Model to Relational Mapping - Functional Dependencies and Normal Form - Storage Structures -Indexing Techniques Single Level,Multi - Level-Constraints and Triggers - Query Processing and Optimization - Transaction Processing Concepts - Transaction Processing and Database Manager - Foundation for Concurrency Control-Concurrency Control Part - Distributed Transaction Models

Basic 2-Phase and 3-phase commit protocol -Concurrency Control for Distributed Transaction-Introduction to Transaction Recovery - Recovery Mechanisms II - Introduction to Data Warehousing and OLAP - Case Study : MYSQL, ORACLE and Microsoft Access-Data Mining and Knowledge Discovery - Object Oriented Databases - XML - Introductory Concepts - XML Advanced Concepts - XML Databases

Other Resources :

Syllabus | Citation |

IITMadras delivers the above video lessons under NPTEL program, there are more than 6000+ nptel video lectures by other IIT's as well.

Other Computer Science Courses

» check out the complete list of Computer Science Video lectures          


Get Your Degree!

Find schools and get information on the program that’s right for you.

Powered by Campus Explorer


Post your Comments