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