Skip to main content
Get a Quote
Course Enquiry
Contact Us

COVID-19 Lockdown

Leading Training is online and available during the Covid-19 Shutdown.

Our staff are working from home and can do the following:

  • Webinar training and e-learning
  • Consulting
  • Development work
  • Support

We can provide remote assistance to anyone who needs it, however as an IT support company we are willing to provide emergency support to companies that are essential service providers.

If you require any help from us please make use of the live chat below.


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.

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

Delegates may choose to write the Microsoft Technology Associate Exam 98-364 Database Fundamentals

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

Delivery Methods

Delivery Method Duration Price (excl. VAT)
E-learning 3 Days R 2,999.00 Book Now
Fulltime 3 Days R 7,887.00
Webinar 3 Days R 5,547.00

Discounts Available

Save up to R 990 if you bring your own PC on a fulltime course.

Save up to 10% by booking and paying 10 business days before the course.


Download Brochure

Information may change without notice.

Introduction Video


  • 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.


  • Above average computer literacy
  • If you are bringing along your own laptop and you are using Microsoft SQL Server, 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

Course Outline / Curriculum

  • 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
  • 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
  • SELECT Summary
  • Sub Queries
  • Creating Structures
    • Data Types
    • Field Modifiers
    • Table Level Constraints
  • Drop Queries
  • Altering Tables
  • Insert Queries
    • Simple Insert
    • Bulk Insert
  • Update Queries
    • Update Joins
  • Indexes
    • Creating Indexes
    • Dropping Indexes
  • Transactions
  • Database Design

Schedule Dates and Booking

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

Start Date Branch  
Mon 22 Jun 2020 Woodmead

Book Fulltime

Book Webinar

Mon 20 Jul 2020 Woodmead
Mon 17 Aug 2020 Woodmead

Book Fulltime

Book Webinar

Mon 24 Aug 2020 Woodmead
Mon 14 Sep 2020 Woodmead

Book Fulltime

Book Webinar

Mon 19 Oct 2020 Woodmead
Mon 16 Nov 2020 Woodmead
Mon 23 Nov 2020 Woodmead