SQL

PostgreSQL for Business Intelligence and Mass-data-analysis

SQL Online

MySQL Administration

PostgreSQL Administration

Advanced SQL

Analyzing Data with Excel

MySQL

PLSQL

PostgreSQL

TRAINERS FOR COURSE

Bernard Niewoud

Mark Badham

Ryan van Rensburg

CUSTOMERS ON THIS COURSE

Nucleus

Ethekwini Municipality

Resolve

Leading Edge Business Solutions (Pty) Ltd

Fnb Wealth & Investments

South Bakels (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.

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

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.

Start Date	Branch	Status
Mon 25 Jan 2021	Woodmead	Provisional
Mon 1 Feb 2021	Woodmead	Scheduled	Book Fulltime Book Webinar
Mon 22 Feb 2021	Woodmead	Scheduled	Book Fulltime Book Webinar
Tue 23 Mar 2021	Woodmead	Provisional
Mon 19 Apr 2021	Woodmead	Provisional
Mon 24 May 2021	Woodmead	Provisional
Mon 31 May 2021	Woodmead	Provisional
Mon 21 Jun 2021	Woodmead	Provisional
Mon 19 Jul 2021	Woodmead	Provisional
Mon 16 Aug 2021	Woodmead	Provisional
Mon 23 Aug 2021	Woodmead	Provisional
Mon 13 Sep 2021	Woodmead	Provisional
Mon 11 Oct 2021	Woodmead	Provisional
Mon 8 Nov 2021	Woodmead	Provisional
Mon 15 Nov 2021	Woodmead	Provisional
Mon 6 Dec 2021	Woodmead	Provisional

TRAINING COURSE

RELATED COURSES