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.
Delegates may choose to write the Microsoft Technology Associate Exam 98-364 Database Fundamentals
NB! Assessment requires an extra day and is charged separately.
Cost
$689.70 If you are currently resident in South Africa you will need to pay VAT at 15%.Duration:
3 DaysBrochure:
Delivery Method
Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.
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 software installation. You will also need full administrator pri
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 | Duration | Status | |
|---|---|---|---|
| Mon 23 Apr 2018 | 3 Days | Scheduled |
Closed Please call |
| Mon 7 May 2018 | 3 Days | Scheduled | Book Now |
| Mon 28 May 2018 | 3 Days | Scheduled | Book Now |
| Wed 13 Jun 2018 | 3 Days | Scheduled | Book Now |
| Mon 18 Jun 2018 | 3 Days | Provisional | |
| Mon 2 Jul 2018 | 3 Days | Scheduled | Book Now |
| Mon 30 Jul 2018 | 3 Days | Scheduled | Book Now |
| Mon 13 Aug 2018 | 3 Days | Provisional | |
| Mon 3 Sep 2018 | 3 Days | Scheduled | Book Now |
| Mon 17 Sep 2018 | 3 Days | Provisional | |
| Mon 1 Oct 2018 | 3 Days | Scheduled | Book Now |
| Mon 29 Oct 2018 | 3 Days | Scheduled | Book Now |
| Mon 26 Nov 2018 | 3 Days | Scheduled | Book Now |
| Mon 3 Dec 2018 | 3 Days | Scheduled | Book Now |