SQL Training Course

Details Audience and Pre-Requisites Course Outline / Curriculum Schedule Dates and Booking Enquiry

Details

SQL, or Structured Query Language, is the universal standard for communicating with relational databases, enabling users to store, manage, and retrieve data efficiently. This comprehensive course provides a step-by-step introduction to SQL language, starting with the fundamentals of SQL and progressing to more advanced topics such as joins and complex queries.

Designed to cater to a wide range of database systems, including MySQL, Microsoft SQL Server, PostgreSQL, and Oracle, the course equips participants with essential SQL query basics and practical skills needed to interact seamlessly with various platforms. Whether you are a beginner aiming to build a strong foundation or an experienced professional looking to refine your database management capabilities, this course offers hands-on training in SQL for beginners, ensuring you can confidently apply SQL in real-world scenarios.

This course will teach you everything you need to know, from SQL language basics to advanced joins. SQL for the following databases is covered:

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Oracle

Delivery Methods

Delivery Method Duration
Classroom
Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.
Classroom
3 Days Get a Quote
e-Learning
This independent, online, guided course is delivered via the Moodle Learner Management System web interface and includes videos, quizzes, exercise files and other downloadable resources. Work through the material in your own time. You have 1 year to complete the course. Download your certificate when done. Limited interaction with a facilitator is provided by telephone, email, and instant messaging on Moodle. Face-to-face appointments can be booked separately.
e-Learning
18 hours Get a Quote Book Now
Live Virtual Training
This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.
Live Virtual Training
3 Days Get a Quote

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

Customer Testimonials

Personal Trust

Ryan is a patient and knowledgeable guy who can boil complex subjects down to very practical examples.

Exxaro Resources Limited

The course was practical, the instructor was very understanding and ready to assist if ever we got stuck in any problems.

Travelex

the trainer is knowledgeable.

Sage South Africa (Pty) Ltd

Price was within budget, received value for money, content was relevant and up to date. Trainer was knowledgeable and patient with all trainees.

The Revenue Services Lesotho (RSL)

The training was detailed and covered crucial details that are normally ignored so i found it very informative

Nedbank Group Ltd

The instructor knew how to go about the training. He understood that most of us were beginners on this course and he was very understanding and patient with us.

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

  • What is SQL
  • Relational Databases
  • Terminology
  • SQL and Standards
  • SQL Implementations
  • Client - Server
  • SQL Syntax
  • Comments
    • Single-line comments
    • Multi-line comments
  • SELECT Statements
    • Overview of SELECT
    • Selecting One Field
    • Selecting Multiple Fields
    • Using a Wild Card
    • Calculations
      • Oracle's DUAL table
      • Column Aliases
  • Data Types
    • Character Types
      • CHAR
      • VARCHAR
    • Numeric Types
      • Integers
      • DECIMAL or NUMERIC
      • NUMBER
    • Datetime Types
      • DATE
      • TIME
      • DATETIME
      • DATE
      • TIMESTAMP
  • Sorting Results
  • Limiting rows
  • Using WHERE
    • Comparison Operators
      • BETWEEN
      • IN
      • IS NULL
      • Comparing one column to another
    • Using AND/OR and NOT
    • Using LIKE
  • Functions
    • String Functions
      • LEN
      • CONCAT
        • Concatenation Operator
      • SUBSTRING
      • REPLACE
    • Conversion Functions
      • CAST
    • Numeric Functions
      • ROUND
      • FLOOR
      • CEILING
    • Date Functions
      • Getting the current date and time
      • Formatting a date and time
      • Extracting a part of a date
      • Calculating the difference between dates
      • Adding an interval to a date
      • Oracle Date comparisons
    • Aggregate
    • DISTINCT
  • Grouping
  • Filtering Using HAVING
  • Joins
    • INNER JOIN
    • Implicit INNER JOIN syntax
    • Using table aliases in joins
    • The USING statement
    • Joining Multiple Tables
    • Self Joins
    • Outer Joins
      • LEFT OUTER JOIN
      • RIGHT OUTER JOIN
      • FULL OUTER JOIN
  • Set Operators
    • UNION
    • UNION ALL
    • INTERSECT
    • EXCEPT or MINUS
  • SELECT summary
  • Subqueries
  • Creating Structures
    • CREATE DATABASE
    • CREATE SCHEMA
    • CREATE USER
    • CREATE TABLE
      • Field Modifiers
        • Auto Increment
      • Table Level Constraints
        • Primary Key Table Constraints
        • Foreign Key Table Constraints
        • Check Table Constraints
        • Unique Table Constraints
    • CREATE TABLE AS SELECT
    • SELECT INTO
  • Views
  • Drop Queries
  • ALTER TABLE
    • Adding a column to a table
    • Deleting a column from a table
    • Modifying a column in a table
    • Renaming a column in a table
    • Renaming a table
  • Insert Queries
    • Bulk Insert
    • INSERT INTO SELECT
  • Update Queries
    • Update Joins
  • DELETE and TRUNCATE
  • Indexes
    • Guidelines to using Indexes
    • Creating Indexes
    • Dropping Indexes
  • Transactions
    • ROLLBACK Example
    • Savepoints
    • COMMIT Example
  • Database Design
    • Conceptual Model
    • Define the Information Required
    • Normalization
    • Divide Data into Tables
    • Assigning Primary and Foreign Keys
      • Keys
      • Table Relationships
        • Many to one
        • One to one
        • Many to many
      • Iterate
    • Entity Relationship Diagrams

Schedule Dates and Booking

You can enrol at any time for this course.

Book Now

Submit Enquiry

Name
Email
Telephone
Query