Advanced SQL

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

Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method	Duration	Price (excl. VAT)
Classroom	2 days	ZAR 5,500.00	Get a Quote
Live Virtual Training	2 days	ZAR 4,500.00	Get a Quote

Discounts Available

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

Brochure:

Information may change without notice.

Customer Testimonials

Alexander Forbes Group Services (Pty) Ltd

Ryan is put simply...excellent! The pace at which the course was delivered, the approach that Ryan used to cover the content...purely commendable. Thank you!

Audience

Database Administrators, Programmers.

Pre-Requisites

At least one months experience using SQL
Intermediate Microsoft Excel experience recommended

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

There are currently no scheduled dates.

Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.

Add me to the waiting list

Should you need this course urgently, the following options are available:

Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.

Submit Enquiry