SQL - Structured Query Language training course-Midrand, Sandton, Johannesburg, South Africa

SQL Online

COURSE TRAINERS

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

Discounts Available

Brochure:

Information may change without notice.

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 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 software installation. You will also need full administrator privileges on your laptop.

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

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:

Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
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