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. 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.
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. 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.
$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
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 10
333 Adelaide Street
Brisbane QLD 4000
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
100 Walker Street
North Sydney NSW 2060
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 7
79 George Street
Parramatta NSW 2150
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
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
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
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
SQL Course Outlines
Other Courses
Other Courses
Course Rating
SQL City Pages
Skills Test
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.
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 many functions
- learn how to create complex queries
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
- PIVOT and UNPIVOT
- 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
- Temporary tables
- Common table expressions
- Recursive CTEs
- Cross joins and self joins
- Variables
- Local variables
- Table variables
- Window Functions
- OVER clause
- Calculate percentages, moving averages, and running totals
- LAG and LEAD
- FIRST_VALUE, LAST_VALUE
- Ranking Functions
- ROW_NUMBER
- RANK and DENSE RANK NTILE
- User-Defined Functions
- Scalar user-defined functions
- Table-valued functions
- Schemas
- APPLY
- Control of Flow
- IF…ELSE
- BEGIN…END
- Simplifying Code Reuse
- Views
- Stored procedures
- Query Performance
- Improving query performance
Contact Us
phone
email
enquiry
-
Log in from your Desk
-
Instructor Led Training
-
Your Questions Answered -
-
