Get in Touch
 Duration 14 hours

Course Outline

Review of Structured Query Language

  • DQL, DML, DDL
  • GROUP BY and HAVING clauses
  • Sub-queries and Correlated Sub-queries
  • Advanced UPDATE and DELETE statements
  • Sub-queries
  • Correlated Sub-queries

Procedural Programming

  • Variables
  • Flow control statements
  • IF, WHILE, CASE, GOTO, RETURN

Error Management

  • Handling errors
  • RAISERROR
  • PRINT

Transaction Usage

  • Introduction to transactions
  • Transaction isolation levels
  • Deadlocks
  • Transactional error handling

Implementing Cursors

  • Declaring cursors
  • OPEN, FETCH, CLOSE
  • DEALLOCATE
  • CURRENT OF

Stored Procedures

  • Creating stored procedures
  • Passing values into a stored procedure
  • Retrieving information from stored procedures
  • Modifying stored procedures

Triggers

  • Creating triggers
  • Transactional error handling
  • Utilising the inserted and deleted tables

Requirements

Participants are expected to have a working knowledge of the Microsoft SQL Server SQL language.

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-11-05 09:30
14 hours
Melbourne 385 Bourke Street
7000 AUD (Online)
13600 AUD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-19 09:30
14 hours
Cliftons Perth
7000 AUD (Online)
14200 AUD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-03 09:30
14 hours
Sydney King Street
7000 AUD (Online)
13600 AUD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-17 09:30
14 hours
London Circuit
7000 AUD (Online)
13600 AUD (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-31 09:30
14 hours
200 Mary Street, Brisbane
7000 AUD (Online)
13600 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...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Australia is tailored for participants familiar with SQL Server. It concentrates on set-based querying, query optimisation, index management, and execution plan analysis. Learners will gain proficiency in table expressions, ranking functions, and the handling of partitioned tables.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This program aims to deliver a comprehensive grasp of the advanced SQL syntax and techniques inherent in Microsoft SQL Server. By acquiring proficiency in analytical functions, table joins, subqueries, and aggregation methods, learners will be equipped to transfer data analysis tasks from MS Excel directly to the database layer. This methodology enhances efficiency and fosters the creation of resilient IT systems built on Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Develop your T-SQL fundamentals in this hands-on course located in Australia. You will learn to leverage SQL Server Management Studio, construct tables using DDL and DML, and craft complex queries involving joins and subqueries. This course is ideally suited for beginners aiming to secure core database skills and gain practical experience with contemporary relational systems.
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...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led training on Australia focuses on the core aspects of SQL using Microsoft SQL Server, enabling participants to refine their querying, database design, and normalization skills. Through practical exercises, learners will develop hands-on proficiency in T-SQL to enhance data optimization and establish seamless connections with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This instructor-led live training in Australia focuses on core SQL Server administration capabilities. Participants will learn to install and configure environments, oversee databases, and track performance. It is well-suited for IT professionals seeking hands-on experience with automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This instructor-led, live training in Australia (online or onsite) is aimed at intermediate-level to advanced-level 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.
  • Optimize 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 Australia (online or onsite) is designed for intermediate-level database administrators seeking to acquire the skills and knowledge required to effectively manage and administer SQL Server databases using SQL Server Management Studio.

Upon completion 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 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 instructor-led training in Australia is dedicated to mastering the design of advanced SSIS data flows and transformations. Participants will gain proficiency in implementing Slowly Changing Dimensions, managing complex data sources, and deploying robust packages to optimise data warehousing and migration workflows.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Australia empowers delegates with the skills necessary to handle complex result sets and optimize database performance. It covers analytical functions, index management, query tuning, and foundational data warehouse techniques for Microsoft SQL Server.
Read more...

Visual Studio for PLC Communication and Database Integration

 21 Hours

This instructor-led, live training in Australia (online or onsite) 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 conclusion 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.
  • Optimize application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server