Skip to main content
Get a Quote
Course Enquiry
Contact Us

NOTICE

In the interests of protecting our staff, trainers and you, our clients, we will be suspending all instructor-led training from 15th July 2020 until it is safe again.

Our company is working remotely to serve our clients and we are still offering courses via webinar. If you feel your online course didn’t meet that standard, you are welcome to re-attend your course in class when we re-open.

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  
Thu 17 Sep 2020 Woodmead

Book Fulltime

Book Webinar

Mon 21 Dec 2020 Woodmead

Book Fulltime

Book Webinar