Intermediate

Certificate in Database Management Systems

About This Course

Master the backbone of modern applications - professional database design and management. Learn relational database concepts, SQL mastery, database design principles, and normalization techniques. Work with industry-standard systems including MySQL, PostgreSQL, and SQL Server. Understand indexing strategies, query optimization, stored procedures, triggers, and transactions. Learn database administration tasks including backup/recovery, user management, performance tuning, and security. Explore NoSQL basics and data warehousing concepts. Build real-world database projects from e-commerce platforms to content management systems. Essential for backend developers, data engineers, database administrators, or anyone working with data-intensive applications. Transform messy data into organized, efficient database systems.

Course Content

Module 1: Database Foundations

1.1 What Is a Database and Why Does Your Business Need One? (Preview)

1.2 Understanding Tables, Rows, and Columns

1.3 Primary Keys, Foreign Keys, and Relationships

1.4 Module 1 Quiz: Database Foundations

Module 2: Designing a Real-World Database

2.1 Planning a Database for a Zambian Business

2.2 Creating Tables and Choosing Data Types

2.3 Normalisation and Avoiding Data Duplication

2.4 Module 2 Quiz: Designing a Real-World Database

Module 3: SQL and MySQL Basics

3.1 Introduction to SQL and MySQL

3.2 SELECT, WHERE, and ORDER BY

3.3 INSERT, UPDATE, and DELETE

3.4 JOINs: Linking Tables Together

3.5 Module 3 Quiz: SQL and MySQL Basics

Module 4: Database Administration, Backups, and Reports

4.1 Using phpMyAdmin

4.2 Backups, Integrity, and Security

4.3 Creating Simple Reports

4.4 Module 4 Quiz: Administration, Backups, and Reports

Student Reviews

No reviews yet. Be the first to review!

ZMW 1,500.00

Instructor TBA

Duration 6 weeks

Students 2

Language English