All programmes
    Tech Skill Course

    Data Engineering: Database Design & Administration

    Database design, SQL and MySQL administration for data professionals.

    2 Months Advanced

    Programme overview

    Database engineering course covering SQL, MySQL, database design and optimization. Students learn to design, build and administer enterprise-level database systems.

    What you will learn

    6 modules. Every module is hands-on, with practical work in class. Tap a module to see its topics.

    1. 01

      Module 01

      Database Design & Normalization

      Structuring data so it stays accurate and easy to use.

      By the end of this module, you will be able to design a well-structured relational database.

      • Relational concepts: Tables, rows, keys and relationships.
      • Entity-relationship diagrams: Planning a database before building it.
      • Normalization: Removing duplication and keeping data consistent.
    2. 02

      Module 02

      SQL Query Writing

      Getting exactly the data you need.

      By the end of this module, you will be able to write SQL queries to read, filter, combine and update data.

      • Core queries: SELECT, INSERT, UPDATE and DELETE.
      • Filtering and sorting: WHERE, ORDER BY and LIMIT.
      • Joins and aggregation: Combining tables and summarising data.
    3. 03

      Module 03

      MySQL Administration

      Running a MySQL database server day to day.

      By the end of this module, you will be able to install, configure and manage a MySQL server.

      • Installation and configuration: Setting up MySQL for use.
      • Users and permissions: Controlling who can access what.
      • Monitoring: Keeping an eye on server health.
    4. 04

      Module 04

      Database Optimization

      Making databases and queries fast.

      By the end of this module, you will be able to find slow queries and make them faster.

      • Indexes: How they work and when to add them.
      • Query optimization: Reading query plans and rewriting slow queries.
      • Performance tuning: Settings and design choices that affect speed.
    5. 05

      Module 05

      Backup, Recovery & Security

      Protecting data from loss and misuse.

      By the end of this module, you will be able to back up, restore and secure a database.

      • Backups: Planning and running regular backups.
      • Recovery: Restoring data after failures.
      • Database security: User management, access control and safe practices.
    6. 06

      Module 06

      Data Analysis & Reporting

      Turning stored data into useful information.

      By the end of this module, you will be able to produce reports that answer real business questions.

      • Reporting queries: Summaries, groupings and trends.
      • Views: Reusable queries for common reports.
      • Presenting results: Sharing findings clearly.

    Career opportunities

    • Database Administrator
    • Data Analyst
    • SQL Developer
    • Database Designer
    • Business Intelligence Analyst

    Frequently asked questions

    How long is the Data Engineering: Database Design & Administration course?

    Data Engineering: Database Design & Administration takes 2 months. It is a advanced course.

    Do I need any experience before joining?

    Programming fundamentals or equivalent experience. If you are not sure the course is right for you, talk to us and we will help you choose.

    What certificate will I get?

    You will receive the Advanced Database Management Certificate when you complete the course.

    Can I study online, or do I have to come to Rongai?

    Both. You can attend in class at our Rongai campus (KayGee House, 1st floor, opposite KCB Bank), where physical classes have a maximum of 15 students, or you can study online.

    What class times are available?

    We run morning classes (8:00 AM to 12:00 PM), afternoon classes (1:00 PM to 5:00 PM), evening classes (6:00 PM to 8:00 PM) and Saturday morning classes, so you can study around work or school.

    How much does it cost?

    Contact us on WhatsApp or call +254 797 884 545 for current fees, payment options and the next intake date.

    How do I enrol?

    Register online on our website, visit us at our Rongai campus, or call or WhatsApp us on +254 797 884 545. We will guide you through choosing a start date and getting set up.