Certificate in Database Management Systems (DBMS)

Course details

DBMS or Database Management Systems is an appliocation software for management of data as per its representational model. Due to immense growth in data there is an continous and increasing need for DBMS professionals to manage data.

Why should one take this certification?
DBMS or Database Management Systems have become an integral part of IT systems and companies rely on DBMS for their operational and strategic needs. The Certificate in Database Management Systems (DBMS) is suitable for professionals and graduates wh want to stand out amongst their peers in skills and knowledge on DBMS.

The certification covers

• DBMS Basics
• Data Modeling
• Relational Data Model
• Data Storage and DBMS File Structure
• Transaction And Concurrency
• Backup and Recovery
• Various DBMS (open source, commercial, cloud-based and No SQL)

Who will benefit from taking this certification?
The certification is suitable for administrators, system admins, IT admins and professionals engaged in database support. The certification is of immense benefit to professionals in IT management or administration department especially senior executives and managerial cadre candidates, to increase and demonstrate their skills in Database Management Systems (DBMS).
 
Benefits of Certification

• Government certification
• Certification valid for life
• Lifelong e-learning access
• Learning Hours: 12+ hrs

 
How It Works

1. Select Certification & Register
2. Receive Online e-Learning Access (LMS)
3. Take exam online anywhere, anytime
4. Get certified & Increase Employability

Test Details

• Duration: 60 minutes
• No. of questions: 50
• Maximum marks: 50, Passing marks: 25 (50%).
• There is NO negative marking in this module.
• Online exam.

 
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 Modeling

• 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

Updated on 12 June, 2024