Databasing Skills Programme with SQL

Home » Databasing Skills Programme with SQL

Course Description



Price : R6825
Deposit : R1050
Duration : 3 Months
Registration Fee : R1000 non refundable. (Not included in course price)
Upfront Payment : 10% discount

Overview

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

Career Opportunities

  • Computer and Information Systems Managers.
  • Computer Systems Analysts.
  • Computer Network Architects.
  • Financial Analysts.
  • Computer Programmers.
  • Information Security Analysts.
  • Computer Support Specialists.
  • 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

OUR RELATED COURSES

Skills Programme Courses Cybersecurity Analyst

CompTIA Cybersecurity Analyst (CySA+)

This course focuses on defence and teaches the skills needed to apply behavioural ...
Read More

CompTIA Security+

Security+ emphasizes hands-on practical skills, ensuring the security professional is better prepared to problem-solve ...
Read More
IT Qualifications System Development

CompTIA Network+

Security+ emphasizes hands-on practical skills, ensuring the security professional is better prepared to problem ...
Read More
Skills Programme Courses CompTIA Core 1 and 2

CompTIA A+ Core1 and Core2

CompTIA A+ certified professionals are proven, problem solvers. They support today’s core technologies ...
Read More
IT Qualifications

MCSA Microsoft Certified Solutions Associate

A Microsoft Certified Solutions Associate is a certification programme intended for people who seek entry-level ...
Read More
IT Qualifications End-User Computing

Databasing Short Course

Database Management provides the foundation you need for a career in database development and ...
Read More
IT Qualifications System Development

Microsoft SQL Server

Databasing SkillsProgramme with SQL This skills programme is for anyone interested to start ...
Read More
Skills Programme Courses

Python

Python is an interpreted, high-level, general-purpose programming language.
Read More
Skills Programme Courses Website Creation

Website Creation Short Course

Website creation will teach you how to prepare content for the Web. You ...
Read More
IT Qualifications Microsoft Courses

Certiport

With a focus on younger demographics, the IC3 Spark certification addresses the same ...
Read More
Skills Programme Courses CompTIA

CompTIA ITF+

CompTIA IT Fundamentals (ITF) is an introduction to basic IT knowledge and skills that ...
Read More
IT Qualifications System Development

MS OFFICE

Suite of products developed by Microsoft Corporation that includes Microsoft Word, Excel, Access, ...
Read More

Conduct Team Meeting

In order for a group to function effectively, participants must be working toward accomplishing ...
Read More
Skills Programme Courses Research

Research

When researching a topic it is important to understand how to perform your ...
Read More
Skills Programme Courses

Writing A Business Report

Simply stated, a business report conveys information to assist in decision making. Some ...
Read More
IT Qualifications Office Administration

Office Administration

This qualification prepares the qualified learner for researching and creating content using MS ...
Read More
Industry News at On The Ball College

MICROSOFT ACCESS ADVANCED

Career Opportunities  Administration clerksdata capture and financial assistants. Curriculum Querying with SQLAdvanced queriesMacrosAdvanced MacrosImporting, ...
Read More
Industry News at On The Ball College

MICROSOFT ACCESS BASIC

Career Opportunities  Administration clerksdata capture and financial assistants. Curriculum Databases and TablesFields and recordsData ...
Read More
Industry News at On The Ball College

MICROSOFT ACCESS INTERMEDIATE

Career Opportunities Administration clerksdata capture and financial assistants. Curriculum Getting Started with AccessWorking with ...
Read More
Industry News at On The Ball College

MICROSOFT EXCEL ADVANCED

Career Opportunities Administration clerksdata capture and financial assistants. Credits : 4 Curriculum Logical ...
Read More
Industry News at On The Ball College

MICROSOFT EXCEL BASIC

Career Opportunities Administration clerksdata capture and financial assistants. Credits : 4 Curriculum Entering ...
Read More
Industry News at On The Ball College

MICROSOFT EXCEL INTERMEDIATE

Career Opportunities Administration clerksdata capture and financial assistants. Credits : 4 Curriculum Using ...
Read More
Industry News at On The Ball College

MICROSOFT POWERPOINT ADVANCED

Career Opportunities AdministratorOffice Management Credits : 5 Curriculum Customizing PowerPointCustomizing SmartArt graphics, tables ...
Read More
Industry News at On The Ball College

MICROSOFT PROJECT

Learning programming that will lead you to a greater understanding of applying a ...
Read More
Industry News at On The Ball College

MICROSOFT WORD

Career Opportunities Office Administration Credits : 7 Curriculum The students will learn about ...
Read More
Industry News at On The Ball College

MICROSOFT WORD BASIC

Career Opportunities Administration clerksdata capture and financial assistants. Credits : 3 Curriculum The ...
Read More
Industry News at On The Ball College

MICROSOFT WORD INTERMEDIATE

Career Opportunities Office Administration Credits : 5 Curriculum Styles and OutlinesSections and columnsFormatting ...
Read More

OUR CLIENTS

SKILLS PROGRAMME

QUALIFICATIONS

YOUR JOURNEY