IIRF Online > Development > Database Design & Development > Database Management Systems (DBMS) > Certificate in Database Management Systems (DBMS)
Certificate in Database Management Systems (DBMS) by Vskills
Course Highlights
- Government certification
- Certification valid for life
- Lifelong e-learning access
- Learning Hours: 12 hrs
- Life Time Job Support
- Job Profile Tagging
Skills you will learn!
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
.webp)
Certificate in Database Management Systems (DBMS)
Related Database Management Systems (DBMS) Courses
.webp)
Thank You!
Your review has been submitted successfully.