Complete DBMS : Concepts and Basics

Database Management System or DBMS in short refers to the technology of storing and retrieving usersí data with utmost efficiency along with appropriate security measures. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more.

Audience

This DBMS tutorial will especially help computer science graduates in understanding the basic-to-advanced concepts related to Database Management Systems.

Prerequisites

Before you start proceeding with this tutorial, it is recommended that you have a good understanding of basic computer concepts such as primary memory, secondary memory, and data structures and algorithms.

Chapters-

Overview

Architecture

Data Models

Data Schemas

Data Independence

Entity Relationship Model

ER Model Basic Concepts

ER Diagram Representation

Generalization, Aggregation

Relational Model

Codd's Rules

Relational Data Model

Relational Algebra

ER to Relational Model

DBMS- SQL Overview

Relational Database Design

Database Normalization

Database Joins

Storage and File Structure

Storage System

File Structure

Indexing and Hashing

Indexing

Hashing

Transaction And Concurrency

Transaction

Concurrency Control

Deadlock

Backup and Recovery

Data Backup

Data Recovery