Database Management System

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