DATABASE ADMINISTRATION COURSES

Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product which stores and retrieves data as requested by other software applications which may run either on the same computer or on another computer across a network.

[dnxt_next_dual_button button_text_one=”Enquire” button_link_one=”/first-year-applications/?pid=6″ button_text_two=”Apply” button_link_two=”Mailto:applications@ontheballcollege.co.za” dnxt_button_alignment=”center” btn_one_show_hide=”on” button_bg_one=”#B92026″ btn_two_color_show_hide=”on” button_bg_two=”#B92026″ button_one_margin=”5px|5px|5px|5px|true|true” button_one_padding=”|15px||15px|false|true” button_two_margin=”5px|5px|5px|5px|true|true” button_two_padding=”|15px||15px|false|false” dnxt_dual_one_hover_2d=”dnxt-hover-grow” dnxt_dual_two_hover_2d=”dnxt-hover-grow” _builder_version=”4.16″ _module_preset=”default” btn_one_fonts_text_color=”#ffffff” btn_two_fonts_text_color=”#ffffff” border_radii_one_border=”on|50px|50px|50px|50px” border_color_all_one_border=”#ffffff” border_radii_two_border=”on|50px|50px|50px|50px” border_color_all_two_border=”#ffffff” global_colors_info=”{}”][/dnxt_next_dual_button]

MS Access

Microsoft Access is a database management system from Microsoft that combines the Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications.

[dnxt_next_dual_button button_text_one=”Enquire” button_link_one=”/first-year-applications/?pid=6″ button_text_two=”Apply” button_link_two=”Mailto:applications@ontheballcollege.co.za” dnxt_button_alignment=”center” btn_one_show_hide=”on” button_bg_one=”#B92026″ btn_two_color_show_hide=”on” button_bg_two=”#B92026″ button_one_margin=”5px|5px|5px|5px|true|true” button_one_padding=”|15px||15px|false|true” button_two_margin=”5px|5px|5px|5px|true|true” button_two_padding=”|15px||15px|false|false” dnxt_dual_one_hover_2d=”dnxt-hover-grow” dnxt_dual_two_hover_2d=”dnxt-hover-grow” _builder_version=”4.16″ _module_preset=”default” btn_one_fonts_text_color=”#ffffff” btn_two_fonts_text_color=”#ffffff” border_radii_one_border=”on|50px|50px|50px|50px” border_color_all_one_border=”#ffffff” border_radii_two_border=”on|50px|50px|50px|50px” border_color_all_two_border=”#ffffff” global_colors_info=”{}”][/dnxt_next_dual_button]

Databasing Skills Programme with SQL

software-engineers-working-on-project-and-programm-7KYR3VV

Databasing Skills Programme 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.
Computer Systems Analysts.
Financial Analysts.
Information Security Analysts.
Market Research Analysts.

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

Durration: 3 Months

Price: R7999

Deposit: R500

Upfront payment: 10% discount

Registration Fee: R1000 non refundable.

(Not included in course price)

[dnxt_next_dual_button button_text_one=”Enquire” button_link_one=”/first-year-applications/?pid=6″ button_text_two=”Apply” button_link_two=”Mailto:applications@ontheballcollege.co.za” dnxt_button_alignment=”center” btn_one_show_hide=”on” button_bg_one=”#B92026″ btn_two_color_show_hide=”on” button_bg_two=”#B92026″ button_one_margin=”5px|5px|5px|5px|true|true” button_one_padding=”|15px||15px|false|true” button_two_margin=”5px|5px|5px|5px|true|true” button_two_padding=”|15px||15px|false|false” dnxt_dual_one_hover_2d=”dnxt-hover-grow” dnxt_dual_two_hover_2d=”dnxt-hover-grow” _builder_version=”4.16″ _module_preset=”default” btn_one_fonts_text_color=”#ffffff” btn_two_fonts_text_color=”#ffffff” border_radii_one_border=”on|50px|50px|50px|50px” border_color_all_one_border=”#ffffff” border_radii_two_border=”on|50px|50px|50px|50px” border_color_all_two_border=”#ffffff” global_colors_info=”{}”][/dnxt_next_dual_button]

At WeTrainICT we strive to change lives daily.

We are an accredited Training provider with MICT Seta® (Acc 2007/01/170), an Oracle Partner and Certiport Centre. We are proud to be 100% women owned and 100% Black-owned with a Level 1 BEE rating. We have been offering services in the training and development sector for the past 10 years through IT learnerships and skills programmes with a 90% – 100% job placement in industry.

On the ball college