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.


Course Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDF
Upcoming Courses
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
We are currently developing these courses. Please contact us to register your interest.
SQL Training Courses

Learn how to work with data stored in the cloud, develop an understanding of relational databases and SQL.
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
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.
Course Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFContact Us
Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.
Locations In-Person & Online
Find the nearest location and date that works for you
-
SQL Training in Brisbane
View Dates -
SQL Training in Melbourne
View Dates -
SQL Training in Sydney
View Dates -
SQL Training in Adelaide
View Dates -
SQL Training in Perth
View Dates -
SQL Training in Parramatta
View Dates -
SQL Training in Canberra
View Dates -
SQL Training in Remote Online
View Dates
Locations In-Person & Online
Find the nearest location and date that works for you
Locations In-Person & Online
Find the nearest location and date that works for you
-
SQL Training in Brisbane
View Dates -
SQL Training in Melbourne
View Dates -
SQL Training in Sydney
View Dates -
SQL Training in Adelaide
View Dates -
SQL Training in Perth
View Dates -
SQL Training in Parramatta
View Dates -
SQL Training in Canberra
View Dates -
SQL Training in Remote Online
View Dates
Locations In-Person & Online
Find the nearest location and date that works for you
-
80K+
Students
-
76K+
4 & 5 Star Reviews
-
4.7/5
Google Reviews
-
1.3K+
Businesses Trust Nexacu
Step by Step Courseware
Custom workbook included with a step by step exercises



Free Refresher
Resit your course for free within 6 Months