Skip to main content
Get a Quote
Course Enquiry
Contact Us

Advanced SQL Course Details


In this course you will learn how to:

  • Use loops and branches in queries
  • Create user defined functions and stored procedures
  • Manage constraints and triggers
  • Control multiple simultaneous updates

Audience:

Database Administrators, Programmers.

Pre-Requisites:

SQL

Duration:

2 days

Price:

$540.00 If you are currently resident in South Africa you will need to pay VAT at 14%.

PC Hire:

$70   *Bring a PC

Note: information may change without notice.

Download Brochure:

Download Brochure

About Advanced SQL

Structured Query Language (SQL) is the most popular language used for querying relational databases. SQL supports a number of advanced features that make your queries more intelligent and efficient and take a lot of the work away from the middle ware.

This course is specifically only for Microsoft SQL Server. For an advanced SQL course focused on Oracle, please contact us.

Course Outline


  • Sequences
    • CREATE SEQUENCE
    • Viewing sequence details
    • NEXT VALUE FOR
    • DROP SEQUENCE
  • Computed Columns
  • Temporary Tables
  • Derived Tables
  • Procedural Language
  • Variables
    • Declaration
    • Assignment
    • Displaying Variables
    • Concatenating Variables
    • Scope
    • Using variables
    • Table variables
  • IF ... ELSE
  • CASE
  • Converting rows into columns
    • Using CASE
    • Using PIVOT
    • UNPIVOT
  • IIF, COALESCE, ISNULL
  • FOR XML
    • RAW mode
    • PATH mode
    • AUTO mode
  • FOR JSON
  • Advanced Grouping
    • WITH ROLLUP
    • WITH CUBE
    • GROUPING SETS
  • Window Functions
    • OVER
    • Creating a running total
    • ROW_NUMBER, RANK and DENSE_RANK
    • LEAD AND LAG
    • FIRST_VALUE and LAST_VALUE
  • WHILE
  • Cursors
  • User Defined Functions
    • Restrictions on functions
    • Table Valued Functions
  • CROSS APPLY and OUTER APPLY
  • Common Table Expressions
  • Stored Procedures
    • Parameters
  • Dynamic SQL
  • Triggers
    • DML AFTER Triggers

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.

Scheduled Dates


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  
Mon 29 Jan 2018 2 days Book Now
Thu 10 May 2018 2 days Book Now
Thu 21 Jun 2018 2 days Book Now
Thu 2 Aug 2018 2 days Book Now
Thu 20 Sep 2018 2 days Book Now
Thu 1 Nov 2018 2 days Book Now