Complete DBMS : Concepts and Basics

About 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