SQL

TRAINING COURSE

SQL

RELATED COURSES

Advanced SQL
Analysing Data with Excel
Critical Thinking
Data Modelling with M and Power Query
Data Visualization with Python
Data Visualization with R
Excel Dashboards and Power Pivot
GIS ESSENTIALS – “Getting Spatially Enabled”
Introduction to Statistics
Machine Learning with Python
Machine Learning with R
Microsoft Power BI Boot Camp
Microsoft Power BI Desktop Advanced
Microsoft Power Query
Microsoft PowerBI Dashboard User Course
MySQL
MySQL Administration
PLSQL
PostgreSQL
PostgreSQL Administration
PostgreSQL for Business Intelligence and Mass-data-analysis
Problem Solving and Decision Making
Problem-Solving SAQA US242817
Python Dashboards with plotly Dash
Python Pandas and Jupyter ETL and Data wrangling
Python Regression
Python Statistical Modelling
Python Statistics
Python Web Apps with Flask MVC Framework
R, Into the Tidyverse (Data Wrangling and ETL)
Regression with R
Statistics with R

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. SQL for the following databases are covered:

  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Oracle

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 six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Classroom 3 Days ZAR 8,250.00 Get a Quote
Live Virtual Training 3 Days ZAR 6,750.00 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

The Revenue Services Lesotho (RSL)

Very good in managing virtual training with in-person support.

Multichoice Technical Operations (Pty) Ltd

The instructor paid attention to each student in the course to cater where support was needed.

Barnowl Data Solutions

Leading edge courses are so easy to follow and explained very well. This was my first course and will definitely use leading edge again in future.

Multichoice Technical Operations (Pty) Ltd

Everything was perfect

Sage South Africa (Pty) Ltd

The course was depth

MTN SA

I would like to apply my learning first, though I feel confident that by tomorrow, I will be able to add more value at work. Thanks to Ryan and the team!

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

There are currently no scheduled dates.

Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.

Add me to the waiting list

Should you need this course urgently, the following options are available:

  1. Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
  2. If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.
Submit Enquiry