Get in Touch

Course Outline

Structured Query Language Refresher

  • DQL, DML, DDL
  • GROUP BY and HAVING Clauses
  • Sub-queries and Correlated Sub-queries
  • Advanced Update & Delete Statements
  • Sub-queries
  • Correlated Sub-queries

Procedural Programming

  • Variables
  • Flow Control Statements
  • IF, WHILE, CASE, GOTO, RETURN

Error Management

  • Handling Errors
  • RAISERROR
  • PRINT

Working with Transactions

  • Transaction Fundamentals
  • Transaction Isolation Levels
  • Deadlocks
  • Transactional Error Handling

Cursor Implementation

  • Cursor Declaration
  • OPEN, FETCH, CLOSE
  • DEALLOCATE
  • CURRENT OF

Stored Procedures

  • Creating Stored Procedures
  • Inputting Values into Stored Procedures
  • Retrieving Information from Stored Procedures
  • Modifying Stored Procedures

Triggers

  • Creating Triggers
  • Transactional Error Handling
  • Utilising Inserted and Deleted Tables

Requirements

Participants should possess a working knowledge of the Microsoft SQL Server SQL language.

 14 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (7)

Lot of content and exactly the requested one.

Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

There were a lot of exercises really good exercises and the trainer passed on his knowledge well.

Zsolt - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Communicative, big knowledge and well presented material

Filip Gotowicki - EY GDS (CS) POLAND SP. Z O.O.
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

atmosphere, knowledge

Magdalena Bobel - EY GDS (CS) POLAND SP. Z O.O.
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Open, frank and knowledgeable

Shiva Wagle - Mosaic Primary Care Network
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

It is interactive

Syed Muhammad Mehdi - Mosaic Primary Care Network
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

The content of the training

Kyvin Aw - Asure Quality LTD
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

Provisional Upcoming Courses (Require 5+ participants)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-07 09:30
14 hours
Wellington, Plimmer Towers
7800 NZD (Online)
15300 NZD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-21 09:30
14 hours
Te Pou Toetoe Linwood
7800 NZD (Online)
15300 NZD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-04 09:30
14 hours
Auckland, ANZ Centre
7800 NZD (Online)
16600 NZD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-18 09:30
14 hours
Wellington, Plimmer Towers
7800 NZD (Online)
15300 NZD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-02 09:30
14 hours
Te Pou Toetoe Linwood
7800 NZD (Online)
15300 NZD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-16 09:30
14 hours
Auckland, ANZ Centre
7800 NZD (Online)
16600 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...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in New Zealand is designed for professionals already familiar with SQL Server. It emphasizes set-based querying, query optimization, index management, and execution plan analysis. Learners will develop expertise in table expressions, ranking functions, and the management of partitioned tables.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This course provides a thorough understanding of advanced SQL syntax and techniques available in Microsoft SQL Server. By mastering analytical functions, table joins, subqueries, and aggregation techniques, participants will learn how to move data analysis tasks from MS Excel directly to the database layer. This approach not only improves efficiency but also supports the development of robust IT systems based on Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Master T-SQL fundamentals in this hands-on course in New Zealand. Learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and develop complex queries using joins and subqueries. This course is ideal for beginners seeking core database competencies and practical experience with modern relational systems.
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...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led training in New Zealand delves into the fundamentals of SQL with Microsoft SQL Server, enabling participants to proficiently handle querying, database design, and normalization. Through practical, hands-on exercises, learners will develop real-world T-SQL skills to refine data management and establish seamless connections with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This live, instructor-led training in New Zealand focuses on essential SQL Server administration capabilities. Participants will master the installation and configuration of environments, database management, and performance monitoring. It is ideal for IT professionals seeking practical experience in automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in New Zealand (online or in-person) is aimed at intermediate to advanced database administrators who wish to deepen their knowledge of SQL Server for efficient database management, performance tuning, high availability, and advanced troubleshooting.

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

  • Administer and configure SQL Server instances using best practices.
  • Optimise performance of queries and databases.
  • Implement high availability and disaster recovery strategies.
  • Diagnose and resolve complex issues in production environments.
Read more...

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in New Zealand (online or onsite) is aimed at intermediate-level database administrators who wish to learn the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

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

  • Understand system requirements and perform installations.
  • Create, configure, and manage databases using SSMS.
  • Manage logins, users, roles, and permissions.
  • Perform various types of backups and restore databases.
  • Create, schedule, and manage jobs using SQL Server Agent.
  • Implement best practices for efficient and secure SQL Server administration.
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 specialises in the design of advanced SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy resilient packages to streamline data warehousing and migration efforts.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course held in New Zealand empowers delegates with the competencies required to manage complex result sets and fine-tune database performance. The curriculum addresses analytical functions, index management, query optimisation, and fundamental data warehouse techniques within the Microsoft SQL Server environment.
Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This instructor-led, live training in New Zealand (online or on-site) is designed for intermediate-level software developers and automation engineers who wish to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

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

  • Develop .NET applications in Visual Studio for industrial automation.
  • Communicate with PLCs using industrial protocols such as OPC UA.
  • Implement database interactions with SQL Server for storing and retrieving PLC data.
  • Optimise application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server