Databases

The Databases Certification prepares learners to design, create, manage, and query relational databases using industry-standard database technologies. Learners will gain the knowledge and practical skills required to design database structures, create database objects, retrieve and manipulate data using SQL, and troubleshoot database-related issues.

Through this certification, learners will develop analytical thinking, logical problem-solving abilities, database design skills, and SQL proficiency needed to support data-driven applications and business systems.

Course Overview

Databases form the foundation of modern business applications by storing, organising, and managing critical information. This programme is designed to provide learners with a strong foundation in relational database design, database object management, data retrieval, data manipulation, and database security.

Learners will gain practical experience in designing database structures, creating tables and relationships, writing SQL queries, managing database objects, manipulating data, and troubleshooting common database issues. They will also develop an understanding of database security, normalization, indexing, and data protection best practices.

Course Overview

Duration

The programme combines classroom, practical, and workplace learning. Modules can be scheduled flexibly to meet learner and workplace requirements.

Delivery Method

The course can be delivered on-site at the learner’s business, at a training provider facility, or virtually. Accredited providers will supervise practical and workplace-based learning to meet all assessment and credit requirements.

Who Is This Course For?

Aspiring database administrators
Software developers
Data analysts
IT support professionals
Students pursuing technology careers
Individuals interested in database design and management

Cost

R4 800.00 Per Learner

Exam Objectives

Database Design
1.1 Design Tables for Storing Data
1.2 Identify the Appropriate Primary Key
1.3 Choose Data Types to Meet Requirements
1.4 Design Relationships Between Tables
1.5 Normalize a Database
1.6 Identify Data Protection Measures

Database Object Management Using DDL
2.1 Create, Alter, and Drop Tables
2.2 Create, Alter, and Drop Views
2.3 Construct and Analyse Stored Procedures and Functions
2.4 Choose Between Clustered and Non-Clustered Indexes

Data Retrieval
3.1 Construct and Analyse Queries That Select Data
3.2 Construct and Analyse Queries That Sort and Filter Data
3.3 Construct and Analyse Queries That Aggregate Data
Data Manipulation Using DML
4.1 Construct and Analyse INSERT Statements
4.2 Construct and Analyse UPDATE Statements
4.3 Construct and Analyse DELETE Statements

Troubleshooting
5.1 Troubleshoot Data Object Management Query Failures
5.2 Troubleshoot Data Retrieval Query Failures
5.3 Troubleshoot Data Manipulation Query Failures