Four weeks
Monday – Friday
1hr
500,000/=
Practical and Theory Exams
Prerequisite: Must have Basic Computer Science Concepts such as Computer Programming Language.
Overview:
Database Management System (DBMS) is software that provides an interface to interact with databases. It allows users to define, create, manage, and manipulate databases, as well as control access to the data within those databases. The DBMS is responsible for ensuring data integrity, security, and consistency while providing a convenient means for users to interact with stored data.
Course outline
INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS
1.Overview of Databases and DBMS 2. Types of Databases (Relational, NoSQL, Hierarchical, etc.) 3. Database Models (Relational, Entity-Relationship, Object-Oriented) 4. Components of a DBMS 5. Applications of DBMS
DATABASE DESIGN
1.Database Design Process 2. Entity-Relationship (ER) Model 3. ER Diagrams (Entities, Relationships, Attributes) 4. Relational Model 5. Mapping ER Diagrams to Relations 6. Normalization (1NF, 2NF, 3NF, BCNF) 7. De-Normalization
SQL (STRUCTURED QUERY LANGUAGE)
1.Introduction to SQL 2. SQL Data Types 3. Data Definition Language (DDL): CREATE, ALTER, DROP 4. Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE 5. Data Control Language (DCL): GRANT, REVOKE 6. SQL Constraints (Primary Key, Foreign Key, Unique, Check) 7. SQL Joins (INNER, OUTER, LEFT, RIGHT) 8. Subqueries and Nested Queries
DATABASE SECURITY
1.Authentication and Authorization 2. Data Encryption in Databases 3. SQL Injection and Prevention 4. Role-Based Access Control (RBAC) 5. Auditing and Monitoring in Databases
DATABASE ADMINISTRATION AND MAINTENANCE
1.Roles and Responsibilities of a Database Administrator (DBA) 2. Database Installation and Configuration 3. Database Monitoring and Tuning 4. Backup and Restore Operations 5. Database Migration and Upgrades 6. Troubleshooting Common Database Issues
