All courses available in-class and remotely.

SQL Header

SQL Advanced Course

Take your SQL skills up a level

 

A crucial skill for anyone working with data is the ability to access and analyse that data. Structured Query Language (SQL) enables users to access data from databases, combine data from multiple, related tables and to aggregate, sort, filter or limit the data retrieved as needed. Our Advanced SQL course will build upon the skills learnt in our SQL Intermediate course.

In this course, students will use more sophisticated techniques for querying databases and reshaping and manipulating result sets. Participants will learn to reshape data by pivoting and unpivoting. They will write more complex queries using subqueries, temporary tables and common table expressions. They will use recursive techniques to query hierarchical data and create date dimension tables. Students will build on their understanding of scalar user-defined functions and local variables to create table-valued functions and use table variables.

Students will also learn to simplify querying and increase their efficiency by using views and stored procedures. Students work with an Azure SQL database and write queries in Microsoft’s Transact-SQL (T-SQL). Much of what is covered will be useful for users working with other database products.

SQL Advanced Course

Take your SQL skills up a level

$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day
$595
10 max
1 day

Remote

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Upcoming Courses:
Remote Online
Date
Course
City
Status
Wed 10 Aug 22
Wed
10
Aug
SQL Advanced
Remote Online
Status: Sold Out
Sold Out
Tue 11 Oct 22
Tue
11
Oct
SQL Advanced
Remote Online
Status: Confirmed
Confirmed
Brisbane

We are currently developing these courses. Please contact us to register your interest.

Sydney
Date
Course
City
Status
Wed 10 Aug 22
Wed
10
Aug
SQL Advanced
Sydney
Status: Sold Out
Sold Out
Tue 11 Oct 22
Tue
11
Oct
SQL Advanced
Sydney
Status: Scheduled
Scheduled
Parramatta

We are currently developing these courses. Please contact us to register your interest.

Melbourne

We are currently developing these courses. Please contact us to register your interest.

Canberra

We are currently developing these courses. Please contact us to register your interest.

Adelaide

We are currently developing these courses. Please contact us to register your interest.

Perth

We are currently developing these courses. Please contact us to register your interest.

Scheduled
Taking enrollments.
Confirmed
Taking enrollments.
Few Seats left
Book Now.
Sold Out
Try another date.

Frequently Asked Questions

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 team of 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 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. 


SQL Advanced Course Details

Price
$595
Duration
1 day
Times
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Live Online
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 10
333 Adelaide Street
Brisbane QLD 4000
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 10
100 Walker Street
North Sydney NSW 2060
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 7
79 George Street
Parramatta NSW 2150
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
466 Little Lonsdale St
Melbourne VIC 3000
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Ethos House
Level 1
28 Ainslie Place
Canberra ACT 2601
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 3
97 Pirie Street
Adelaide SA 5000
microsoft_gold

SQL Advanced Course Details

Price
$595
Duration
1 day
Time
9am - 4pm ( approx )
Class Size (max)
10
Class Size (avg)
5
Reference Materials
Provided
Training Computer
Provided
CPD Hours
6 hours
Delivery
Instructor-led training
Address
Level 4
220 St Georges Tce
Perth WA 6000
microsoft_gold

SQL Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft Office 365 Training Courses
Microsoft Excel Training Courses
Excel Specialist Training Courses
Microsoft Project Training Courses
R Programming Training Courses
Python Training Courses
Power Apps Training Courses
SharePoint Training Courses
Microsoft Teams Training Courses
Power Automate Training Courses
Microsoft Visio Training Courses
Dynamics 365 Training Courses
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Other Courses
Course Rating
SQL Training Courses

4.72 5 SQL Training Courses
4.72 out of 5
41981 Student Reviews

Contact Us


What do I need to know to attend?

This course builds on the knowledge gained and skills taught in our SQL Intermediate course.
Students attending this course should have completed our SQL Beginner and Intermediate courses or be very familiar with writing SQL queries.

SQL Advanced Learning Outcomes

Upon completion of this course students will be able to:

  • use more sophisticated techniques for querying databases
  • reshape and manipulate result sets
  • reshape data by pivoting and unpivoting
  • write more complex queries using subqueries, temporary tables and common table expressions
  • use recursive techniques to query hierarchical data and create date dimension tables
  • write more efficient SQL code

SQL Advanced Course Content

  • 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

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 41981 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us