Microsoft SQL Server

Databasing SkillsProgramme with SQL

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

Career Opportunities

• Computer and Information Systems Managers.
• Computer Network Architects.
• Computer Programmers.
• Computer Support Specialists.
• Financial Analysts.
• Information Security Analysts.
• Market Research Analysts.

Target Audience

• NQF Level 5

Minimum Requirements

Learners must have the following

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

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
• JOINs Part II
• Group Functions Part I
• Group Functions Part II
• Subqueries
• Ensuring Quality Queries Part I
• DML
• DDL
• Constraints
• Views
• Sequences and Synonyms
• Privileges and Regular Expressions
• TCL
• Ensuring Quality Queries Part II

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

Unit Standards covered during course:

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)

Next Steps

Let us help you get started by showing your interest to complete an application.

Please send an email to applications@ontheballcollege.co.za.

We will send you an application link to complete with a payment request.

We look forward to starting your learning journey with us.
Regards