Get in Touch
 Duration 7 hours

Course Outline

Analytical Functions

  • Application of advanced summary functions
  • Implementation of hierarchical queries
  • Utilization of analytical summary functions, such as moving averages and running totals
  • Application of ranking functions

Useful Database Objects

  • Core principles of using indexes
  • Creation and maintenance of indexes
  • Utilization of clustered tables
  • Utilization of partitioned tables
  • Use of metadata within the master database

Query Performance Tracing

  • Foundations of query execution and optimization
  • Analysis of Execution Plans
  • Use of table and index statistics
  • Application of query hints

Basic Data Warehouse Techniques

  • Utilization of Indexed Views
  • Implementation of Dimension and fact tables
  • Application of Star and Snowflake designs

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (7)

The lecture about cte

Glyssa Mae - Metropolitan Bank and Trust Company
Course - Transact SQL Advanced

Really enjoyed compression data components

James - Medtech Limited
Course - Transact SQL Advanced

new techniques and style

Goniforte Balane - MORESCO-1
Course - Transact SQL Advanced

Some additional tips given to us that is somewhat outside topic area

John Erzon Tan - MORESCO-1
Course - Transact SQL Advanced

Outside topic tips Randomized new IDS, Indexes, Window function The joke was too funny and realistic

ALBERT SANDIG - MORESCO-1
Course - Transact SQL Advanced

when the trainer lets us do task one by one. the additional tips and ideas given to us and also the joke haha

Carl Sherwin Francis Llenares - MORESCO-1
Course - Transact SQL Advanced

Trainer is knowledgeable about the topic, and he really knows what he is doing. I appreciate the pacing and helps the trainees if there is a problem. He is also very engaging and very patient. Gives us words of encouragement very often and keeps training interesting.

Bianca Angela Yap - Human Edge Software Philippines, Inc. (part of Tribal Group)
Course - Transact SQL Advanced

Provisional Upcoming Courses (Require 5+ participants)

Transact SQL Advanced

2026-11-16 09:30
7 hours
London Circuit
2350 AUD (Online)
5650 AUD (Classroom)

Transact SQL Advanced

2026-11-30 09:30
7 hours
200 Mary Street, Brisbane
2350 AUD (Online)
5650 AUD (Classroom)

Transact SQL Advanced

2026-12-14 09:30
7 hours
Adelaide City Central
2350 AUD (Online)
5650 AUD (Classroom)

Transact SQL Advanced

2026-12-28 09:30
7 hours
Melbourne 385 Bourke Street
2350 AUD (Online)
5650 AUD (Classroom)

Transact SQL Advanced

2027-01-11 09:30
7 hours
Cliftons Perth
2350 AUD (Online)
5950 AUD (Classroom)

Transact SQL Advanced

2027-01-25 09:30
7 hours
Sydney King Street
2350 AUD (Online)
5650 AUD (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Australia, this training equips administrators with the skills to manage SQL Server efficiently. Participants will master database creation, SQL syntax for data retrieval, and security protocols. The course also explores advanced features such as replication, automation, and BI, enabling the construction of complex, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in Australia (online or onsite) is aimed at intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

By the end of this training, participants will be able to:

  • Perform advanced querying techniques using unions, subqueries, and complex joins.
  • Add, update, and delete data, tables, views, and indexes with precision.
  • Ensure data integrity through transactions and manipulate database structures.
  • Create and manage databases efficiently for robust data storage and retrieval.
Read more...

AI for SQL: Leveraging Large Language Models for Intelligent Querying and Optimization

 21 Hours

This instructor-led, live training in Australia empowers data engineers to integrate LLMs into SQL environments. Participants will develop natural language pipelines, implement AI-driven optimisation, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in Australia focuses on advanced SQL database management and design. Participants will gain mastery over query commands, joins, and transaction management, while learning to construct resilient schemas using entity-relationship modelling and ACID properties to ensure system reliability.
Read more...

SQL Advanced level for Analysts

21 Hours
This course in Australia provides analysts with advanced SQL skills, focusing on data selection, filtering, and sorting. Participants will learn to master joins, subqueries, and analytic functions like RANK and LAG, enabling them to perform complex data analysis directly within Oracle, SQL Server, or MS Access databases.
Read more...

SQL Basics

 14 Hours
This live, instructor-led session in Australia introduces SQL basics for novices, covering data extraction, filtering, summarisation, and joining. It combines interactive teaching with practical labs to assist participants in crafting effective SQL queries for practical database reporting and analysis.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in Australia (online or onsite) is designed for beginner to intermediate data analysts, database professionals, and software developers who wish to learn SQL for effective database management.

Upon completion of this training, participants will be able to:

  • Comprehend and utilise fundamental SQL commands and queries.
  • Create and manipulate tables and databases.
  • Utilise SQL to sort, filter, and summarise data.
  • Execute more complex operations such as joins, subqueries, and set operations.
  • Apply intermediate techniques including indexes, views, stored procedures, and triggers.
Read more...

SQL Fundamentals to Advanced Querying

 10 Hours
This instructor-led SQL training in Australia guides beginners through advanced querying, joins, and aggregation. Build practical skills with hands-on exercises and real datasets to manipulate data, create reports, and optimise performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training on Australia empowers participants to develop practical abilities for extracting and analysing data from any relational database. You will gain proficiency in writing SQL queries, comprehending database architecture, and utilising diverse SQL dialects to produce effective reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in Australia tailored for intermediate users. Gain mastery over complex SQL queries, data manipulation, and performance optimisation through advanced techniques. The course includes hands-on exercises and a live lab to effectively apply your skills to real-world scenarios.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course in Australia focuses on writing efficient queries for Microsoft SQL Server. It explores relational models, data retrieval, filtering, and aggregation techniques. Learners gain proficiency in multi-table joins, subqueries, and DML operations to effectively manage business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led, live training in Australia (online or onsite) is designed for data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualisation.

By the end of this training, participants will be able to:

  • Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
  • Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
  • Get a refresher on the fundamentals of Python and SQL.
  • Perform data pre-processing techniques in Python.
  • Learn how to connect Python and SQL for data analysis.
  • Create insightful data visualisations and charts with Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in Australia delves into SQL Server Analysis Services for advanced BI and data modelling. Participants will learn to design OLAP cubes, leverage MDX queries, and deploy robust solutions, acquiring the practical skills needed to drive data-informed decision-making for modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Australia (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.

By the end of this training, participants will be able to:

  • Understand the architecture and components of SSIS.
  • Design and implement ETL processes using SSIS.
  • Use SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshoot and optimise SSIS packages for performance and reliability.
Read more...

SQL Server 2022 Integration Services (SSIS) – Data Flows and Advanced Transformations

 14 Hours

This live, instructor-led training in Australia is dedicated to the design of advanced SSIS data flows and transformations. Participants will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to support efficient data warehousing and migration scenarios.

Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL