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 is returned in the result set. Students will use built-in T-SQL functions for working with string, date, and numeric data types and will calculate moving averages, running totals, and percentages using window functions. 

Learn to use subqueries to perform more complex querying and to use views to simplify querying. Students will also create their own user-defined functions to encapsulate business logic and improve efficiency. Read our course outline below.

SQL Intermediate Course

Take your SQL skills up a level

$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day
$550
10 max
1 day

Remote East

Brisbane

Sydney

Parramatta

Melbourne

Canberra

Adelaide

Perth

Remote West

Upcoming Courses:
Remote East
Date
Course
City
Status
Fri 14 Jun 24
Fri
14
Jun
SQL Intermediate
Remote East
Status: Few Seats
Few Seats
Fri 5 Jul 24
Fri
5
Jul
SQL Intermediate
Remote East
Status: Confirmed
Confirmed
Mon 8 Jul 24
Mon
8
Jul
SQL Intermediate
Remote East
Status: Confirmed
Confirmed
Tue 6 Aug 24
Tue
6
Aug
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Wed 7 Aug 24
Wed
7
Aug
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Tue 20 Aug 24
Tue
20
Aug
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Tue 10 Sep 24
Tue
10
Sep
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Thu 26 Sep 24
Thu
26
Sep
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Tue 22 Oct 24
Tue
22
Oct
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Tue 29 Oct 24
Tue
29
Oct
SQL Intermediate
Remote East
Status: Scheduled
Scheduled
Brisbane
Date
Course
City
Status
Fri 14 Jun 24
Fri
14
Jun
SQL Intermediate
Brisbane
Status: Confirmed
Confirmed
Fri 5 Jul 24
Fri
5
Jul
SQL Intermediate
Brisbane
Status: Confirmed
Confirmed
Tue 6 Aug 24
Tue
6
Aug
SQL Intermediate
Brisbane
Status: Scheduled
Scheduled
Tue 10 Sep 24
Tue
10
Sep
SQL Intermediate
Brisbane
Status: Scheduled
Scheduled
Tue 22 Oct 24
Tue
22
Oct
SQL Intermediate
Brisbane
Status: Scheduled
Scheduled
Mon 25 Nov 24
Mon
25
Nov
SQL Intermediate
Brisbane
Status: Scheduled
Scheduled
Thu 19 Dec 24
Thu
19
Dec
SQL Intermediate
Brisbane
Status: Scheduled
Scheduled
Sydney
Date
Course
City
Status
Wed 7 Aug 24
Wed
7
Aug
SQL Intermediate
Sydney
Status: Scheduled
Scheduled
Tue 29 Oct 24
Tue
29
Oct
SQL Intermediate
Sydney
Status: Scheduled
Scheduled
Thu 19 Dec 24
Thu
19
Dec
SQL Intermediate
Sydney
Status: Scheduled
Scheduled
Parramatta

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

Melbourne
Date
Course
City
Status
Fri 14 Jun 24
Fri
14
Jun
SQL Intermediate
Melbourne
Status: Confirmed
Confirmed
Mon 8 Jul 24
Mon
8
Jul
SQL Intermediate
Melbourne
Status: Confirmed
Confirmed
Tue 20 Aug 24
Tue
20
Aug
SQL Intermediate
Melbourne
Status: Scheduled
Scheduled
Thu 26 Sep 24
Thu
26
Sep
SQL Intermediate
Melbourne
Status: Scheduled
Scheduled
Tue 22 Oct 24
Tue
22
Oct
SQL Intermediate
Melbourne
Status: Scheduled
Scheduled
Mon 4 Nov 24
Mon
4
Nov
SQL Intermediate
Melbourne
Status: Scheduled
Scheduled
Wed 4 Dec 24
Wed
4
Dec
SQL Intermediate
Melbourne
Status: Scheduled
Scheduled
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
Date
Course
City
Status
Tue 23 Jul 24
Tue
23
Jul
SQL Intermediate
Perth
Status: Sold Out
Sold Out
Thu 29 Aug 24
Thu
29
Aug
SQL Intermediate
Perth
Status: Sold Out
Sold Out
Thu 19 Sep 24
Thu
19
Sep
SQL Intermediate
Perth
Status: Sold Out
Sold Out
Wed 6 Nov 24
Wed
6
Nov
SQL Intermediate
Perth
Status: Sold Out
Sold Out
Remote West
Date
Course
City
Status
Thu 29 Aug 24
Thu
29
Aug
SQL Intermediate
Remote West
Status: Sold Out
Sold Out
Thu 19 Sep 24
Thu
19
Sep
SQL Intermediate
Remote West
Status: Sold Out
Sold Out
Wed 6 Nov 24
Wed
6
Nov
SQL Intermediate
Remote West
Status: Sold Out
Sold Out
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 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.

SQL Intermediate Course Details

Price
$550
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
$550
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 8
201 Charlotte Street
Brisbane QLD 4000
microsoft_gold

SQL Intermediate Course Details

Price
$550
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 24/477 Pitt Street
Sydney
New South Wales 2000
microsoft_gold

SQL Intermediate Course Details

Price
$550
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 Intermediate Course Details

Price
$550
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 12A
45 William Street Melbourne VIC 3000
microsoft_gold

SQL Intermediate Course Details

Price
$550
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
$550
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 15
33 King William Street
Adelaide 5000
microsoft_gold

SQL Intermediate Course Details

Price
$550
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
553 Hay Street
Perth WA 6000
microsoft_gold

SQL Intermediate Course Details

Price
$550
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 Course Outlines

Other Courses
Microsoft Power BI Training Courses
Microsoft 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
Microsoft PowerPoint Training Courses
Microsoft Word Training Courses
Cloud Computing
Cybersecurity
ChatGPT Training Courses
Microsoft Outlook
Adobe InDesign Courses
Adobe Photoshop Courses
Adobe Illustrator Courses
Adobe Premiere Pro Training
Adobe After Effects Training
Other Courses
Course Rating
SQL Training Courses

4.72 5 SQL Training Courses
4.72 out of 5
68919 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 Transact-SQL (T-SQL)



  • learn to use T-SQL built-in functions
  • learn to create user-defined functions
  • learn to write subqueries and create views

SQL Intermediate Course Content

  • Introduction
  • SQL and T-SQL
  • Data Types
  • Conversion between data types
  • CAST, CONVERT and PARSE
  • Functions in SQL
  • Built-in Functions
  • Aggregate Functions
  • Scalar Functions
  • Ranking Functions
  • User-defined functions
  • Aggregate Functions and Group By Extensions
  • GROUP BY CUBE, ROLLUP and GROUPING SETS
  • CASE and CASE alternatives
  • COALESCE
  • NULLIFF
  • String Functions
  • Concatenate, replace and format
  • Date and Time Functions
  • Get today's date
  • Calculate date/time differences
  • Calculate a new date
  • Extracting date components
  • Creating dates
  • Logical Functions
  • IIF
  • CHOOSE
  • GREATEST and LEAST
  • Mathematical Functions
  • ROUND, CEILING and FLOOR
  • Writing More Complex Queries
  • Subqueries
  • Local Variables
  • Views
  • Window (Analytic) Functions
  • OVER clause
  • PARTITION BY
  • ORDER BY
  • ROWS or RANGE
  • Calculate group totals, averages, percentages, and running totals
  • LAG and LEAD
  • FIRST_VALUE, LAST_VALUE
  • Ranking Functions
  • ROW_NUMBER
  • RANK and DENSE RANK
  • NTILE
  • User-Defined Functions
  • Create, use, and modify scalar user-defined functions
  • Schemas

Contact Us

Why Nexacu?

Valued by Individuals

4.72 / 5
Over 68919 Reviews

Trusted by Business

Procured by Government

Awards and Accreditations

Follow us