All exams are online now due to COVID related precautions read more

Database Management Systems Table of Contents


Table of Content
 

 

DBMS Basics

  • What is a Data?
  • What is a Database?
  • What is DBMS or Database Management System?
  • DBMS vs RDBMS vs File System
  • Client/Server Basics
  • DBMS Architecture
  • Data Models
  • Data Schemas
  • Data Independence
  • ACID Property

Data Modelling

  • Entity Relationship (E-R) Model
  • DBMS Keys
  • Mapping Constraints
  • DBMS Generalization
  • DBMS Aggregation
  • ER Diagram Representation

Relational Data Model

  • Relational Data Model
  • Codd's Rules for RDBMS
  • Relational Algebra
  • Relational Calculus
  • Integrity Constraints
  • ER to Relational Model

Relational Database Design

  • Dependency (Functional and Multivalued)
  • DBMS Normalization
  • DBMS Normal Forms (1NF to 5NF)
  • Database Joins

Data Storage and DBMS File Structure

  • File Organization (Sequential, Heap, Hash and B+)
  • DBMS ISAM

Indexing and Hashing

  • DBMS Indexing
  • Static and Dynamic Hashing
  • Transaction Processing
  • Transaction Processing
  • Serializability
  • Recoverability
  • Log-Based Recovery
  • DBMS Checkpoint
  • Deadlock in DBMS

Concurrency Control

  • Concurrency Control Protocols
  • Multiple Granularity

Backup and Recovery

  • Data Backup
  • Data Recovery
  • RAID

SQL

  • SQL Datatype
  • SQL Commands, Operators and Statements
  • SQL Clauses
  • SQL Aggregate Function
  • SQL JOIN
  • SQL Set Operation
  • SQL Query Processing

Open Source DBMS

  • MySQL
  • PostgreSQL

Commercial DBMS

  • Microsoft Access
  • Microsoft SQL Server
  • Oracle

NoSQL or Big Data DBMS

  • Cassandra
  • HBase
  • MongoDB
  • CouchDB

Cloud DBMS

  • AWS
  • GCP
  • Micrososft Azure



Apply for certification

https://www.vskills.in/certification/databases/dbms-database-management-systems-certificate

 For Support