Databasing Skills Programme with SQL

This skills programme is for anyone interested to start a career in basic database administration.

Career Opportunities

More Details

Target Audience

• NQF Level 5

Modules that are to be covered:

Database Design

• Data vs Information
• History of the Database
• Major Transformations in Computing

Database Programming

• Introduction
• SELECT and WHERE
• WHERE, ORDER BY and Intro to Functions
• Single Row Functions Part I
• Single Row Functions Part II
• JOINs Part I

Programming with SQL

• Fundamentals
• Defining Variables and Datatypes
• Using SQL in PL/SQL
• Program Structures to Control Execution Flow
• Using Cursors and Parameters
• Using Composite Datatypes
• Exception Handling
• Using and Managing Procedures
• Using and Managing Functions
• Using and Manging Packages
• Getting the Best out of Packages
• Improving PL/SQL Performance
• Using and Managing Triggers
• Recognizing and Managing Dependencies
• Using the PL/SQL Compiler

What’s included

• Online learning environment
• Facilitator: 9 Sessions
• Assessment and Portfolio based.

Follow MICT Seta and QCTO standards System Development NQF Level 5 – 27 Credits

(Accredited course)

Minimum Requirements

Learners must have the following

• Matric or any NQF Level 4 qualification
• Any IT related qualification