Exclusive Features

Expert Subject Faculty
Online Video Classes Platform
Online Mock Tests
Online Material

Course Index

Database Management Systems Learning Concepts

Introduction

  • Database System Applications
  • Purpose of Database Systems
  • View of Data
  • Database Languages – DDL
  • DML
  • Relational Databases
  • Database Design
  • Data Storage and Querying
  • Transaction Management
  • Database Architecture
  • Data Mining and Information Retrieval
  • Specialty Databases
  • Database Users and Administrators
  • History of Database Systems.

Introduction to Data base design

  • Database Design and ER diagrams
  • Entities
  • Attributes and Entity sets
  • Relationships and Relationship sets
  • Additional features of ER Model
  • Conceptual Design with the ER Model
  • Conceptual Design for Large enterprises.

Relational Model

  • Introduction to the Relational Model
  • Integrity Constraints over Relations
  • Enforcing Integrity constraints
  • Querying relational data
  • Logical data base Design: ER to Relational
  • Introduction to Views
  • Destroying /Altering Tables and Views.

Relational Algebra and Calculus

  • Preliminaries
  • Relational Algebra
  • Relational calculus – Tuple relational Calculus
  • Domain relational calculus
  • Expressive Power of Algebra and calculus.

SQL

  • Queries
  • Constraints
  • Triggers: Form of Basic SQL Query
  • UNION
  • INTERSECT
  • EXCEPT
  • Nested Queries
  • Aggregate Operators
  • NULL values Complex Integrity Constraints in SQL
  • Triggers and Active Data bases
  • Designing Active Databases.

Schema Refinement and Normal Forms

  • Introduction to Schema Refinement
  • Functional Dependencies - Reasoning about FDs

Normal Forms

  • Properties of Decompositions
  • Normalization
  • Schema Refinement in Database Design
  • Other Kinds of Dependencies.

Transaction Management

  • Transactions
  • Transaction Concept
  • A Simple Transaction Model
  • Storage Structure
  • Transaction Atomicity and Durability
  • Transaction Isolation
  • Serializability
  • Transaction Isolation and Atomicity Transaction Isolation Levels
  • Implementation of Isolation Levels.

Concurrency Control

  • Lock–Based Protocols
  • Multiple Granularity
  • TimestampBased Protocols
  • Validation-Based Protocols
  • Multi version Schemes. Recovery System-Failure Classification
  • Storage
  • Recovery and Atomicity
  • Recovery Algorithm
  • Buffer Management
  • Failure with loss of nonvolatile storage
  • Early Lock Release and Logical Undo Operations
  • Remote Backup systems.

Storage

  • Overview of Storage and Indexing: Data on External Storage
  • File Organization and Indexing
  • Index Data Structures
  • Comparison of File Organizations
  • Tree-Structured Indexing: Intuition for tree Indexes
  • Indexed Sequential Access Method (ISAM)
  • B+ Trees: A Dynamic Index Structure
  • Search
  • Insert
  • Delete.

Hash- Based Indexing

  • Static Hashing
  • Extendible hashing
  • Linear Hashing
  • Extendible vs. Linear Hashing.