Skip to main content

Advanced SQL

TRAINING COURSE

Advanced SQL

RELATED COURSES

Analysing Data with Excel
Critical Thinking
Data Modelling with M and Power Query
Data Visualization with Python
Data Visualization with R
Excel Dashboards and Power Pivot
GIS ESSENTIALS – “Getting Spatially Enabled”
Introduction to Statistics
Machine Learning with Python
Machine Learning with R
Microsoft Power BI Boot Camp
Microsoft Power BI Desktop Advanced Course
Microsoft Power Query
Microsoft PowerBI Dashboard User Course
MySQL
MySQL Administration
PLSQL
PostgreSQL
PostgreSQL Administration
PostgreSQL for Business Intelligence and Mass-data-analysis
Problem Solving and Decision Making
Problem-Solving SAQA US242817
Python Dashboards with plotly Dash
Python Pandas and Jupyter ETL and Data wrangling
Python Regression
Python Statistical Modelling
Python Statistics
Python Web Apps with Flask MVC Framework
R, Into the Tidyverse (Data Wrangling and ETL)
Regression with R
SQL
SQL Online
Statistics with R

COURSE TRAINERS

Bernard Niewoud

Mark Badham Ryan van Rensburg

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 R 5,500.00 Get a Quote
Live Virtual Training 2 days R 4,500.00 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.

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

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

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.

Start Date End Date Branch Status  
Thu 25 Apr 2024 Fri 26 Apr 2024 Fourways Scheduled

Book Live Virtual Training

Thu 15 Aug 2024 Fri 16 Aug 2024 Fourways Provisional Enquire
Thu 5 Dec 2024 Fri 6 Dec 2024 Fourways Provisional Enquire
Submit Enquiry