Course Highlights
  • Government certification
  • Certification valid for life
  • Lifelong e-learning access
  • Learning Hours: 12 hrs
  • Life Time Job Support
  • Job Profile Tagging
Curriculum

10 Topics
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

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

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

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

2 Topics
File Organization (Sequential Heap Hash and B+)
DBMS ISAM

2 Topics
DBMS Indexing
Static and Dynamic Hashing

6 Topics
Transaction Processing
Serializability
Recoverability
Log-Based Recovery
DBMS Checkpoint
Deadlock in DBMS

2 Topics
Concurrency Control Protocols
Multiple Granularity

3 Topics
Data Backup
Data Recovery
RAID

7 Topics
SQL Datatype
SQL Commands Operators and Statements
SQL Clauses
SQL Aggregate Function
SQL JOIN
SQL Set Operation
SQL Query Processing

2 Topics
MySQL
PostgreSQL

3 Topics
Microsoft Access
Microsoft SQL Server
Oracle

4 Topics
Cassandra
HBase
MongoDB
CouchDB

3 Topics
AWS
GCP
Micrososft Azure

  Write a Review

Certificate in Database Management Systems (DBMS)

Go to Paid Course