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
Base Cost
$569.80
Calculate Discount
I will bring my own PC (less $70.00)I will book and pay 10 business days before the course (less $56.98)
Total
$
If you are currently resident in South Africa you will need to pay VAT at 15%.
Duration:
2 days
Brochure:
Cost
$499.80 If you are currently resident in South Africa you will need to pay VAT at 15%.Duration:
2 daysBrochure:
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. Contact hours are between 9am to 4pm.
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 | Duration | Status | |
|---|---|---|---|---|
| Thu 19 Mar 2020 | Woodmead | 2 days | Scheduled | Book Now |
| Thu 25 Jun 2020 | Woodmead | 2 days | Provisional | |
| Thu 17 Sep 2020 | Woodmead | 2 days | Provisional |