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:
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
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 17 Sep 2020 | Woodmead | Scheduled | |
| Mon 21 Dec 2020 | Woodmead | Scheduled |