All courses available in-class and remotely.

SQL Header

SQL Intermediate Course

Take your SQL skills up a level

Our Intermediate SQL course builds upon the skills learnt in our SQL Beginner course.

In this SQL course, you will move beyond using basic SELECT clauses for retrieving data.
Learn to work with many different types of functions and expressions that modify the way data are returned in the result set. Understand how to calculate moving averages and percentages and reshape data by pivoting and unpivoting. Learn techniques to simplify querying, including how to use variables, user-defined functions and stored procedures.

The course focuses on more advanced techniques to create more complex queries, including using control flow statements, temporary tables and common table expressions and cross joins.  Read our course outline below.

SQL Intermediate 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

Frequently Asked Questions

Meet your Trainer

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. She is consistently well reviewed by her students. 


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 Intermediate 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 Intermediate 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
L10
333 Adelaide Street
Brisbane QLD 4000
microsoft_gold

SQL Intermediate 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
37 Pitt Street
Sydney NSW 2000
microsoft_gold

SQL Intermediate 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
** Brand New Location**
Level 3
79 George Street
Parramatta NSW 2150
microsoft_gold

SQL Intermediate 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 Intermediate 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 Intermediate 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 Intermediate 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
Microsoft 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
32745 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 Beginner course.
Students must be familiar with writing SQL queries.

SQL Intermediate Learning Outcomes

In this course, you will:

  • work with an Azure SQL database
  • write queries in transactional SQL (T-SQL)


  • learn to use many functions
  • learn how to create complex queries

SQL Intermediate Course Content

  • Introduction
  • SQL
  • Azure SQL Database
  • Functions in SQL
  • Different types of built-in
  • functions
  • Creating your own
  • String Functions
  • Modifying strings
  • Extracting components from
  • strings
  • Formatting
  • Date and Time Functions
  • Extracting date components
  • Creating new dates
  • Calculating date/time
  • differences
  • Retrieving today's date
  • Formatting dates
  • Logical Functions
  • IIF
  • CHOOSE
  • Mathematical Functions
  • Rounding values
  • Calculating new values
  • Window Functions
  • Moving averages
  • Running totals
  • Percentages
  • Top results in a group
  • Ranking Functions
  • Row number
  • Rank
  • Dense rank
  • NTILE
  • User-Defined Functions and Stored Procedures
  • Writing user-defined functions
  • Variables
  • Data Types
  • Conversion functions
  • Scalar functions
  • Table-valued functions
  • Control flow
  • Using user-defined functions
  • Calling stored procedures
  • Expressions to Modify Returned Values
  • CASE
  • COALESCE
  • NULLIF
  • Reshaping Data
  • PIVOT
  • UNPIVOT
  • Writing More Complex
  • Queries
  • Subqueries
  • Common Table Expressions
  • Temporary tables
  • Table variables
  • More Complex Joins
  • Cross join

Contact Us

What is Remote Training?

Valued by Individuals

4.72 / 5
Over 32745 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us