Get in Touch
 Duration 7 hours

Course Outline

Analytical Functions

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

Valuable Database Objects

  • Core principles underlying the use of indexes
  • Processes for creating and maintaining an index
  • Utilisation of clustered tables
  • Employment of partitioned tables
  • Leveraging metadata stored within the master database

Query Performance Tracing

  • Foundational concepts of query execution and optimisation
  • Interpreting the Execution Plan
  • Analysis of table and index statistics
  • Application of query hints

Foundational Data Warehouse Techniques

  • Employment of Indexed Views
  • Use of Dimension and fact tables
  • Implementation 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-24 09:30
7 hours
Wellington, Plimmer Towers
2740 NZD (Online)
6490 NZD (Classroom)

Transact SQL Advanced

2026-12-08 09:30
7 hours
Te Pou Toetoe Linwood
2740 NZD (Online)
6490 NZD (Classroom)

Transact SQL Advanced

2026-12-22 09:30
7 hours
Auckland, ANZ Centre
2740 NZD (Online)
7140 NZD (Classroom)

Transact SQL Advanced

2027-01-05 09:30
7 hours
Wellington, Plimmer Towers
2740 NZD (Online)
6490 NZD (Classroom)

Transact SQL Advanced

2027-01-19 09:30
7 hours
Te Pou Toetoe Linwood
2740 NZD (Online)
6490 NZD (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In New Zealand, this programme equips administrators with the skills to manage SQL Server effectively. Participants will master database creation, apply SQL syntax for data retrieval, and implement security protocols. Additionally, you will explore advanced features such as replication, automation, and BI to construct complex, real-world solutions.
Read more...

SQL Advanced

 14 Hours

This instructor-led, live training in New Zealand (online or on-site) 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:

  • Apply 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 live, instructor-led training in New Zealand empowers data engineers to integrate LLMs into their SQL environments. Participants will construct natural language pipelines, implement AI-driven optimisation strategies, and design secure enterprise workflows for automated data analysis.

Read more...

SQL DATABASE MANAGEMENT AND DESIGN - Bespoke

 14 Hours
This instructor-led training in New Zealand focuses on advanced SQL database management and design. Participants will gain mastery over query commands, joins, and transaction management, while learning to construct robust schemas through entity relationship modelling and the application of ACID properties for dependable systems.
Read more...

SQL Advanced level for Analysts

21 Hours
This course on New Zealand covers advanced SQL techniques for analysts, focusing on data selection, filtering, and sorting. Participants will gain proficiency in joins, subqueries, and analytic functions such as RANK and LAG, enabling them to perform complex data analysis directly within Oracle, SQL Server, or MS Access environments.
Read more...

SQL Basics

 14 Hours
This instructor-led New Zealand course introduces SQL fundamentals for beginners, covering data retrieval, filtering, aggregation, and joins. Through interactive lectures and practical labs, participants learn to craft effective SQL statements for real-world database querying and reporting.
Read more...

SQL: Basics to Intermediate

 35 Hours

This instructor-led, live training in New Zealand (available online or on-site) is designed for data analysts, database professionals, and software developers at a beginner to intermediate level who wish to learn SQL to manage databases effectively.

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

  • Understand and use fundamental SQL commands and queries.
  • Create and manipulate tables and databases.
  • Use SQL to sort, filter, and summarise data.
  • Implement 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 live SQL training in New Zealand supports beginners through advanced querying, joins, and aggregation. Develop practical skills using hands-on exercises and real datasets to manipulate data, generate reports, and optimise performance for effective, modern database management.
Read more...

SQL Fundamentals

 14 Hours
This instructor-led training in New Zealand is designed to help you develop practical proficiency in extracting and analysing data from any relational database. You will learn to formulate SQL queries, grasp database architecture, and navigate different SQL dialects to generate effective reports.
Read more...

SQL Intermediate

 14 Hours
Instructor-led live training in New Zealand tailored for intermediate users. Develop proficiency in complex SQL queries, data manipulation, and performance optimization through advanced techniques. The course includes hands-on exercises and a live lab to ensure skills are effectively applied to real-world scenarios.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in New Zealand focuses on writing efficient queries for Microsoft SQL Server. It covers relational models, data retrieval, filtering, and aggregation. You will gain proficiency in multi-table joins, subqueries, and DML operations to effectively manipulate business intelligence datasets.
Read more...

Data Analysis with SQL, Python, and Tableau

 14 Hours

This instructor-led, live training in New Zealand (available online or on-site) is designed for data scientists and developers who aim to integrate and leverage SQL, Python, and Tableau to carry out advanced data analysis, processing, and visualisation.

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

  • Set up the necessary environment to perform data analysis using SQL, Python, and Tableau.
  • Grasp the core concepts of software integration, including data, servers, clients, APIs, and endpoints.
  • Refresh their understanding of the fundamentals of Python and SQL.
  • Apply data pre-processing techniques using Python.
  • Learn how to connect Python and SQL for effective data analysis.
  • Create insightful data visualisations and charts using Tableau.
Read more...

Business Intelligence with SSAS

 14 Hours
This hands-on training in New Zealand explores SQL Server Analysis Services for advanced BI and data modeling. Participants will learn to design OLAP cubes, leverage MDX queries, and deploy robust solutions, gaining practical skills to drive data-driven decision-making for modern business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in New Zealand (online or on-site) 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 instructor-led training in New Zealand centres on designing sophisticated SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, navigate complex data sources, and deploy robust packages to support efficient data warehousing and migration initiatives.

Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server
SQL
SQL