Advanced SQL

TRAINING COURSE

Details Audience and Pre-Requisites Course Outline / Curriculum Schedule Dates and Booking Enquiry

Details

Structured Query Language (SQL) is the most popular language used for querying relational databases. Our advanced Microsoft SQL tutorials cover Microsoft SQL Server, also known as MS SQL or MSSQL Server, which supports a number of advanced features that make your queries more intelligent and efficient, taking much of the work away from the middleware.

In this course, you will learn how to:

  • Use loops and branches in Microsoft SQL Server queries as taught in our SQL tutorials.
  • Create user-defined functions and stored procedures in MS SQL as part of the learning objectives.
  • Manage constraints and triggers in MSSQL Server to optimize database performance.
  • Control multiple simultaneous updates using advanced features of Microsoft SQL Server SQL.

Delivery Methods

Delivery Method Duration
Classroom
Instructor-led classroom-based training. Classes are scheduled at various conference centres in the Sandton area or your premises. Stationary and printed manuals or online resources are included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided. Training is between 9 am to 4 pm.
Classroom
2 days Get a Quote
Live Virtual Training
This course is delivered live via Microsoft Teams. You will be able to see and hear the instructor, view their whiteboard, and ask questions or communicate in the chat. Attend from the comfort of your own home or private office.
Live Virtual Training
2 days Get a Quote

Discounts Available

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

Brochure:

Download 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

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.

Add me to the waiting list

Submit Enquiry

Name
Email
Telephone
Query