Get a Quote
Course Enquiry
Contact US
Leading Edge Training

SQL Course Details


This course will teach you all you need to know about SQL from basics to advanced joins.

This course is aligned to the following unit standard.

SAQA ID258777
UNIT STANDARD TITLEUse the SQL language to create, modify, query and manage a database application.
NQF Level7
CREDITS8

In Addition delegates may also write the Microsoft Technical Associate Exam 98-364 Database Fundamentals

NB! Assessment requires an extra day and is charged separately.

Audience:

  • Report Writers (anyone required to produce reports from a relational database)
  • Web developers wanting to add database interaction to their web sites.
  • Programmers who quickly wants to add SQL to their skills set.
  • The hobbyist who wants to begin creating SQL scripts for upload to their own ISP.
  • Students, and to those seeking a career in computing, who need a fundamental understanding of database administration with SQL.

Pre-Requisites:

  • Above average computer literacy
  • If you are bringing along your own laptop it will be helpful to pre-install the database server and client software. Please call for assistance or arrive at least one hour before on the first day of the course so we can help you with the software installation. You will also need full administrator privileges on your laptop.

Duration:

3 Days

Price:

$594.00 If you are currently resident in South Africa you will need to pay VAT at 14%.   *Discount available

PC Hire:

$66   *Bring a PC

Note: information may change without notice.

Download Brochure:

Download Brochure

About SQL

SQL or Structured Query Language is a standard language used to communicate with almost any database including MySQL, Microsoft SQL Server, Microsoft Access, PostgreSQL and Oracle.

Course Outline


  • Introduction
    • What is SQL
    • Relational Databases
    • SQL and Standards
    • SQL Implementations
    • Client - Server
    • SQL Syntax
  • Select Statements
    • Overview of SELECT
    • Selecting One Field
    • Selecting Multiple Fields
    • Using a Wild Card
    • Calculations
    • Column Aliases
    • Oracle's Dual table
  • Sorting and Filtering
    • Sorting Results
    • Limiting Rows
    • Using WHERE
    • Using AND/OR and NOT
    • Using LIKE
  • Functions
    • String Functions
    • Conversion Functions
    • Numeric Functions
    • Date Functions
    • Aggregate (Group) Functions
    • DISTINCT
  • Grouping
    • Grouping Results
    • Filtering Using Having
  • Joins
    • Inner Joins
    • Implicit inner join syntax
    • Using table aliases in joins
    • The Using statement
    • Joining Multiple Tables
    • Self Joins
    • Outer Joins
  • Set Operators
    • UNION
    • UNION ALL
    • INTERSECT
    • EXCEPT or MINUS
  • SELECT Summary
  • Sub Queries
  • Creating Structures
    • CREATE DATABASE
    • CREATE SCHEMA
  • CREATE TABLE
    • Data Types
    • Field Modifiers
    • Table Level Constraints
    • CREATE TABLE AS
    • SELECT INTO
  • CREATE VIEW
  • Drop Queries
  • Altering Tables
  • Insert Queries
    • Simple Insert
    • Bulk Insert
    • INSERT SELECT
  • Update Queries
    • Update Joins
  • DELETE and TRUNCATE
  • Indexes
    • Creating Indexes
    • Dropping Indexes
  • Transactions
  • Database Design

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Light finger meals are supplied for part time courses.

Scheduled Dates


To apply for a booking, click on the relevant "Book Here" link below.
Note: places are only fully secured once payment has been made.

Start DateDuration 
Mon 13 Mar 20173 daysBook Here
Wed 19 Apr 20173 daysBook Here
Mon 15 May 20173 daysBook Here
Mon 12 Jun 20173 daysBook Here
Mon 17 Jul 20173 daysBook Here
Mon 21 Aug 20173 daysBook Here
Mon 18 Sep 20173 daysBook Here
Mon 16 Oct 20173 daysBook Here
Mon 13 Nov 20173 daysBook Here
Mon 11 Dec 20173 daysBook Here

Gautrain

For clients who want to enjoy the convenience of public transport, consider the Gautrain. Our training premises in Woodmead is located near the Morning Glenn Mall Bus Stop. If organised by prior arrangement we will collect delegates from the afore mentioned bus stop at no extra charge. Direction to the bus stop are as follows:

Take the Gautrain to the Sandton station.
Take the S2 Bus to Morning Glenn Mall.
We will collect you at 8:30 directly from the bus stop.

Accommodation

Please submit a query on the course page and we will be able to advise you on hotels and guest houses close to the training facility.