Skip to main content
Get a Quote
Course Enquiry
Contact Us
SQL

RELATED COURSES


TRAINERS FOR COURSE


CUSTOMERS ON THIS COURSE

Details

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.

Delivery Methods

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

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
R 4,992.30

Discounts Available

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

Brochure:

Download Brochure


Information may change without notice.

Introduction Video

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

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.

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of four delegates. We remain committed to offering training that is fast, focused and effective.

Start Date End Date Branch Status  
Mon 23 Aug 2021 Wed 25 Aug 2021 Not Applicable Scheduled

Book Webinar

Mon 13 Sep 2021 Wed 15 Sep 2021 Not Applicable Scheduled

Book Webinar

Mon 11 Oct 2021 Wed 13 Oct 2021 Woodmead Scheduled

Book Fulltime

Book Webinar

Mon 8 Nov 2021 Wed 10 Nov 2021 Woodmead Provisional
Mon 15 Nov 2021 Wed 17 Nov 2021 Woodmead Provisional
Mon 6 Dec 2021 Wed 8 Dec 2021 Woodmead Scheduled

Book Fulltime

Book Webinar