Select your country to view prices and course dates.
Our Advanced SQL course is designed for those who have completed the SQL Intermediate course and want to master more complex querying techniques using Microsoft’s Transact-SQL (T-SQL) in an Azure SQL environment.
You’ll learn to write advanced queries with subqueries, temporary tables, and common table expressions (CTEs), reshape data using pivot and unpivot functions, and apply recursive techniques for hierarchical data and date dimension tables. The course also covers views, stored procedures, table-valued functions, and table variables to help simplify workflows and boost performance skills applicable across a range of database systems.
By the end of this course, you will be able to:
This course builds on the skills taught in our SQL Intermediate course. Students should have completed our SQL Beginner and Intermediate courses or be confident in writing SQL queries.
Select your country to view prices, and course dates.
SQL BeginnerStart your SQL journey with this beginner training course. Learn SQL basics, understand relational databases, and query data in the cloud using Azure tools.
SQL IntermediateBoost your data skills with our intermediate SQL training course. Learn T-SQL functions, subqueries, and views to write more advanced SQL queries.
Introduction
SQL and T-SQL
Reshaping data
Use PIVOT to turn rows into columns
Use UNPIVOT to rotate columns into rows
Writing More Complex Queries
Subqueries
Local and global temporary tables
Create, modifying and delete temporary tables
Writing More Complex Queries (cont'd)
Common table expressions
Nested CTEs
Recursive CTEs
Query hierarchical data
Create date dimension tables
More Complex Joins
Cross joins
Self joins
Anti joins
Semi joins
Variables
Local variables
Table variables
Temporary tables vs CTEs vs table variables
User-Defined Functions
Scalar user-defined functions
Table-valued functions
Multi-statement table-valued functions
Schemas
Use APPLY to join output from table-valued functions to a table
Control of Flow
IF…ELSE
BEGIN…END
Simplifying Code Reuse
Working with views
Table-valued functions
Working with stored procedures
Executing stored procedures with parameters
Query Performance
Improving query performance
Basic principles
View execution plans
Temporary tables, views, CTEs and table variables
Functions
Reusing code
Meet your Developer
Tamara Shatar holds a PhD in Agricultural Data Science. She has extensive experience, including many years working as a research scientist focused on data analysis, modelling using machine learning, simulation, and other techniques. While working in both academia and at the CSIRO, part of her role included teaching a variety of data analysis skills.
What is Remote Training?
Remote training at Nexacu means our experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, participate in the discussion, and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions.
Who should attend this SQL Advanced course?
This course is ideal for professionals who have completed our SQL Intermediate course or have significant experience writing SQL queries. It's designed for those looking to deepen their skills with complex SQL techniques, query performance tuning, and advanced data operations.
What will I learn in this advanced SQL training course?
You’ll learn how to reshape and manipulate result sets using techniques such as pivoting and unpivoting, create common table expressions (CTEs), work with recursive queries, create table-valued functions, and write stored procedures. The course also focuses on improving SQL performance and code reuse.
Do I need to complete the Intermediate SQL course first?
Yes, we strongly recommend completing the SQL Intermediate course before attending. You’ll need a solid understanding of SQL, including subqueries, views, functions, and working in Azure SQL environments.
What tools will I use during the course?
You will work in an Azure SQL environment and write queries using Transact-SQL (T-SQL) in Azure Data Studio. These are commonly used tools for data professionals and business analysts working with cloud-based databases.
Is query optimisation covered in this course?
Yes, a key focus of this course is writing more efficient SQL code. You’ll learn how to optimise queries using execution plans, compare temporary tables, CTEs, and table variables, and apply best practices for SQL performance.
SQL BeginnerStart your SQL journey with this beginner training course. Learn SQL basics, understand relational databases, and query data in the cloud using Azure tools.
SQL IntermediateBoost your data skills with our intermediate SQL training course. Learn T-SQL functions, subqueries, and views to write more advanced SQL queries.
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Valued by Individuals
Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia
