SQL

SQL

COURSE TRAINERS

Ryan van Rensburg

CUSTOMERS

Alexander Forbes Group Services (Pty) Ltd

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)
E-learning	3 Days	R 2,999.00	Get a Quote	Book Now
Fulltime	3 Days	R 7,887.00	Get a Quote
Webinar	3 Days	R 5,547.00	Get a Quote

Discounts Available

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

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

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

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	End Date	Branch	Status
Mon 11 Dec 2023	Wed 13 Dec 2023	Fourways	Provisional	Enquire
Mon 11 Dec 2023	Wed 13 Dec 2023	CedarWoods of Sandton	Provisional	Enquire
Mon 22 Jan 2024	Wed 24 Jan 2024	CedarWoods of Sandton	Scheduled	Book Fulltime Book Webinar
Mon 29 Jan 2024	Wed 31 Jan 2024	Fourways	Scheduled	Book Webinar
Mon 26 Feb 2024	Wed 28 Feb 2024	Fourways	Scheduled	Book Webinar
Mon 25 Mar 2024	Wed 27 Mar 2024	Fourways	Scheduled	Book Webinar
Mon 22 Apr 2024	Wed 24 Apr 2024	Fourways	Scheduled	Book Webinar
Mon 20 May 2024	Wed 22 May 2024	Fourways	Provisional	Enquire
Wed 19 Jun 2024	Fri 21 Jun 2024	Fourways	Provisional	Enquire
Mon 15 Jul 2024	Wed 17 Jul 2024	Fourways	Provisional	Enquire
Mon 12 Aug 2024	Wed 14 Aug 2024	Fourways	Provisional	Enquire
Mon 9 Sep 2024	Wed 11 Sep 2024	Fourways	Provisional	Enquire
Mon 7 Oct 2024	Wed 9 Oct 2024	Fourways	Provisional	Enquire
Mon 4 Nov 2024	Wed 6 Nov 2024	Fourways	Provisional	Enquire
Mon 2 Dec 2024	Wed 4 Dec 2024	Fourways	Provisional	Enquire

Submit Enquiry

TRAINING COURSE

RELATED COURSES