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
Database Administrators, Programmers.
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.
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.
- CREATE SEQUENCE
- Viewing sequence details
- NEXT VALUE FOR
- DROP SEQUENCE
- Computed Columns
- Temporary Tables
- Derived Tables
- Procedural Language
- Displaying Variables
- Concatenating Variables
- Using variables
- Table variables
- IF ... ELSE
- Converting rows into columns
- Using CASE
- Using PIVOT
- IIF, COALESCE, ISNULL
- FOR XML
- RAW mode
- PATH mode
- AUTO mode
- FOR JSON
- Advanced Grouping
- WITH ROLLUP
- WITH CUBE
- GROUPING SETS
- Window Functions
- Creating a running total
- ROW_NUMBER, RANK and DENSE_RANK
- LEAD AND LAG
- FIRST_VALUE and LAST_VALUE
- User Defined Functions
- Restrictions on functions
- Table Valued Functions
- CROSS APPLY and OUTER APPLY
- Common Table Expressions
- Stored Procedures
- Dynamic SQL
- DML AFTER Triggers
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.
To apply for a booking, click on the
relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.
|Mon 29 Jan 2018||2 days||Scheduled||Book Now|
|Thu 10 May 2018||2 days||Scheduled||Book Now|
|Thu 21 Jun 2018||2 days||Scheduled||Book Now|
|Thu 2 Aug 2018||2 days||Scheduled||Book Now|
|Thu 20 Sep 2018||2 days||Scheduled||Book Now|
|Thu 1 Nov 2018||2 days||Scheduled||Book Now|