2 YR ORDINARY DIPLOMA IN DATABASE MANAGEMENT AND ADMINISTRATION

Course Duration: 2 Years (18-24 months)(4 semesters, including holidays and attachment)
Course Fee: 30,000 Kenyan Shillings per semester (each semester takes 3 months)

weekly commitment : minimum of 2 hours per day

Course Overview:

This course focuses on database management principles, SQL and NoSQL database systems, database design, administration, and optimization for efficient data storage and retrieval.

Year 1

Semester 1: Introduction to Databases

• Week 1-2: Introduction to Databases
• Overview of Database Systems

• • Role of a Database Administrator
  • Introduction to SQL and NoSQL
  • Setting Up Database Environment

• Week 3-6: Relational Database Management System (RDBMS)

• • Basics of SQL (Structured Query Language)
  • Data Definition Language (DDL) and Data Manipulation Language (DML)
  • Query Optimization Techniques
  • Practical Exercises

• Week 7-10: NoSQL Database Systems

• • Introduction to NoSQL Databases (e.g., MongoDB, Cassandra)
  • Document, Key-Value, and Columnar Databases
  • NoSQL Data Modeling
  • Mini Project

• Week 11-14: Database Design and Normalization

• • Database Design Principles
  • Entity-Relationship (ER) Diagrams
  • Normalization Techniques
  • Practical Exercises

• Week 15-16: Semester Review and Assessment

• • Review of Key Concepts
  • Practice Projects
  • Mid-Semester Exam

Semester 2: Advanced Database Management

• Week 1-4: Data Administration and Security

• • Database Administration Tasks
  • Backup and Recovery Strategies
  • Database Security Measures
  • Practical Exercises

• Week 5-8: Transaction Management and Concurrency Control

• • ACID Properties of Transactions
  • Concurrency Issues and Control Mechanisms
  • Deadlock Prevention and Recovery
  • Mini Project

• Week 9-12: Database Performance Tuning

• • Performance Monitoring and Tuning
  • Indexing Strategies
  • Query Optimization Techniques
  • Practical Exercises

• Week 13-14: Data Warehousing and Business Intelligence

• • Data Warehousing Concepts
  • Extract, Transform, Load (ETL) Processes
  • Introduction to Business Intelligence (BI) Tools
  • Practical Exercises

• Week 15-16: Semester Review and Assessment

• • Review of Key Concepts
  • Practice Projects
  • End-of-Semester Exam

Year 2

Semester 3: Advanced Topics in Database Management

• Week 1-4: Big Data and NoSQL Databases

• • Introduction to Big Data Concepts
  • Managing Big Data with NoSQL Databases
  • Scalability and Performance Considerations
  • Practical Exercises

• Week 5-8: Cloud Database Management

• • Cloud Computing Basics
  • Database Deployment in the Cloud
  • Database as a Service (DBaaS)
  • Mini Project

• Week 9-12: Data Privacy and Compliance

• • Data Privacy Regulations (e.g., GDPR, HIPAA)
  • Compliance Requirements for Database Management
  • Implementing Data Governance Practices
  • Practical Exercises

• Week 13-14: Emerging Trends in Database Technology

• • Blockchain for Database Security
  • AI and Machine Learning in Database Management
  • IoT Data Management Challenges
  • Practical Exercises

• Week 15-16: Semester Review and Assessment

• • Review of Key Concepts
  • Practice Projects
  • Mid-Semester Exam

Semester 4: Capstone Project and Industry Applications

• Week 1-4: Capstone Project

• • Project Planning and Design
  • Implementation of Database Management Project
  • Portfolio Development
  • Final Presentation and Evaluation

• Week 5-8: Industry Attachment

• • Attachment in Database Management Roles
  • Applying Skills in Real-World Projects
  • Industry Best Practices
  • Practical Experience

• Week 9-12: Professional Development

• • Career Pathways in Database Management
  • Building a Professional Portfolio
  • Networking and Career Development
  • Practical Exercises

• Week 13-16: Course Review and Final Exam

• • Comprehensive Course Review
  • Practice Projects
  • Final Exam

Attachment

Students will undertake an industry attachment to gain practical experience in database management and administration. This attachment period allows students to apply their knowledge in real-world database projects, preparing them for professional roles in database administration and data management.

Certification

Upon successful completion of the course, students will receive an "Ordinary Diploma in Database Management and Administration" certificate, recognizing their expertise and skills in managing and optimizing databases across various platforms.