Get a Quote
Course Enquiry
Contact US
Leading Edge Training

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%.   *Discount available

PC Hire:

$44   *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


  • Variables
    • Variables in SQL (Slightly database dependent) use results from previous queries.
  • Control Structures
    • CASE is used to branch execution
    • WHILE creates a loop
  • Stored Procedure
    • Agregate statements and call them as a unit
  • `Triggers
    • Run statments when inserting or updating tables
  • Transaction Concurrency
    • Manage the way you database handles simultaneos connectionsby :
    • Table locks
    • or row level locking
  • Constraints
    • Create simple constraints on filed values or Foreign Keys

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. Light finger meals are supplied for part time courses.

Scheduled Dates


To apply for a booking, click on the relevant "Book Here" link below.
Note: places are only fully secured once payment has been made.

Start DateDuration 
Thu 16 Mar 20172 daysBook Here
Thu 18 May 20172 daysBook Here
Thu 20 Jul 20172 daysBook Here
Thu 21 Sep 20172 daysBook Here
Thu 16 Nov 20172 daysBook Here

Gautrain

For clients who want to enjoy the convenience of public transport, consider the Gautrain. Our training premises in Woodmead is located near the Morning Glenn Mall Bus Stop. If organised by prior arrangement we will collect delegates from the afore mentioned bus stop at no extra charge. Direction to the bus stop are as follows:

Take the Gautrain to the Sandton station.
Take the S2 Bus to Morning Glenn Mall.
We will collect you at 8:30 directly from the bus stop.

Accommodation

Please submit a query on the course page and we will be able to advise you on hotels and guest houses close to the training facility.