SQL Advanced Course

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.