Database Administration
This course outline covers the essentials of database administration with a focus on practical skills in RDBMS, SQL, MySQL, PHP, and PhpMyAdmin. Each week builds on the previous one, ensuring a comprehensive understanding of the topics.
Course Overview
The Database Administration course covers the essentials of managing and optimising relational databases, with a strong focus on practical skills used in real production environments.
Over two months, you will build a solid foundation in RDBMS concepts, master SQL, and gain hands-on experience with MySQL, PHP, and PhpMyAdmin. Each week builds on the previous one, ensuring a comprehensive understanding of how to design, query, and maintain databases.
Who This Course Is For
- Aspiring database administrators (DBAs)
- Backend developers who want stronger database skills
- Data analysts who work directly with databases
- IT professionals supporting database-driven applications
What You Will Learn
- Relational database concepts and data modelling
- SQL: queries, joins, views, stored procedures, and triggers
- MySQL administration and PhpMyAdmin
- Database design, normalisation, and indexing
- Backup, restore, and disaster recovery
- Performance tuning and query optimisation
- Integrating MySQL with PHP applications
Course Outcomes
By the end of the course, you will be able to design and manage production databases, write complex SQL queries with confidence, and take on database administrator or backend-with-DB-focus roles.
Requirements
A laptop with at least 8GB of RAM and an internet connection. Some prior programming or IT experience is recommended.This course will equip students with hands-on knowledge in relational databases, SQL scripting, and administrative tools such as MySQL, PhpMyAdmin, and database security practices. Learn to manage, design, and optimize modern database systems.
Key things you’ll learn
- 1Introduction to RDBMS: Understand relational databases and how data is structured and queried.
- 2SQL Query Language: Learn how to write powerful queries using SELECT, JOIN, WHERE, GROUP BY, and more.
- 3MySQL Database Management: Get hands-on with MySQL – creating databases, tables, indexes, and stored procedures.
- 4PhpMyAdmin: Use a web-based interface to manage databases, run queries, import/export data, and monitor usage.
- 5Database Design: Learn data modeling, normalization, ER diagrams, and design best practices.
- 6Database Security: Understand roles, user permissions, encryption, and data protection strategies.
- 7Performance Tuning: Optimize queries and indexes for faster database performance.
- 8Backup & Recovery: Set up backup strategies and restore operations for disaster recovery.
Course Details
- Price
- ₦200,000
- Duration
- 2 Months
- Level
- Advanced
- Category
- Coding
- Requirement
- Basic computer skills, internet access, and a laptop
Apply for Database Administration
Fill in a few details and our admissions team will reach out to confirm your spot.