Skip to main content
Get a Quote
Course Enquiry
Contact Us
Advanced SQL

RELATED COURSES

GIS ESSENTIALS – “GETTING SPATIALLY ENABLED”

PostgreSQL for Business Intelligence and Mass-data-analysis

SQL

SQL Online

MySQL Administration

PostgreSQL Administration

Analyzing Data with Excel

MySQL

PLSQL

PostgreSQL


TRAINERS FOR COURSE

Bernard Niewoud

Mark Badham

Michael Johnson

Ryan van Rensburg


CUSTOMERS ON THIS COURSE

Resolve

Firstrand Bank Ltd

Details

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.

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

Delivery Methods

Delivery Method Duration Price (excl. VAT)
Fulltime 2 days R 5,698.00
Webinar 2 days R 4,098.00

Discounts Available

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

Brochure:

Download Brochure


Information may change without notice.

Audience

Database Administrators, Programmers.

Pre-Requisites

Course Outline / Curriculum

  • 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

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  
Thu 24 Jun 2021 Woodmead Provisional
Thu 16 Sep 2021 Woodmead Provisional
Thu 9 Dec 2021 Woodmead Provisional