Get in Touch

Course Outline

Refresher on Structured Query Language

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

Procedural Programming

  • Variable Management
  • Flow Control Statements
  • IF, WHILE, CASE, GOTO, and RETURN

Error Management

  • Handling Errors Effectively
  • Using RAISERROR
  • Utilizing PRINT

Working with Transactions

  • Fundamentals of Transactions
  • Transaction Isolation Levels
  • Understanding Deadlocks
  • Transactional Error Handling

Implementing Cursors

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

Stored Procedures

  • Creating Stored Procedures
  • Inputting Values into Stored Procedures
  • Retrieving Output from Stored Procedures
  • Modifying Existing Stored Procedures

Triggers

  • Developing Triggers
  • Transactional Error Handling
  • Working with Inserted and Deleted Tables

Requirements

Participants are expected to have a solid grasp 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

Upcoming Courses

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-15 09:30
14 hours
Bayan Lepas, iDEAL
14441 MYR (Online)
14931 MYR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-29 09:30
14 hours
Kuala Lumpur KL Sentral
14441 MYR (Online)
15091 MYR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-12 09:30
14 hours
Bayan Lepas, iDEAL
14441 MYR (Online)
14931 MYR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-26 09:30
14 hours
Kuala Lumpur KL Sentral
14441 MYR (Online)
15091 MYR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-10 09:30
14 hours
Bayan Lepas, iDEAL
14441 MYR (Online)
14931 MYR (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Malaysia, this training equips administrators to manage SQL Server with confidence. Participants will master database creation, apply SQL syntax for data retrieval, and enforce security protocols. The curriculum also covers advanced features like replication, automation, and BI to construct complex, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Malaysia is tailored for professionals already familiar with SQL Server. It emphasizes set-based querying, query tuning, index management, and the analysis of execution plans. Learners will gain mastery over table expressions, ranking functions, and the handling of partitioned tables.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This course provides a deep dive into advanced SQL syntax and techniques specific to Microsoft SQL Server. By mastering analytical functions, table joins, subqueries, and aggregation strategies, learners will be equipped to shift data analysis tasks from MS Excel to the database layer. This shift not only boosts efficiency but also underpins the creation of robust IT systems built 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 Malaysia. Learn to use SQL Server Management Studio, create tables with DDL and DML, and build complex queries with joins and subqueries. Ideal for beginners seeking core database skills and practical experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This hands-on SQL training in Malaysia teaches efficient query writing for Microsoft SQL Server. It covers relational models, data retrieval, filtering, and aggregation. Participants master multi-table joins, subqueries, and DML operations to reliably manipulate business intelligence datasets.
Read more...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led training in Malaysia covers the essentials of SQL with Microsoft SQL Server, helping participants master querying, database design, and normalization. Through hands-on exercises, learners will gain practical skills in T-SQL to optimize data and connect seamlessly with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This instructor-led, live training in Malaysia covers core SQL Server administration skills. Participants will learn to install and configure environments, manage databases, and monitor performance. Ideal 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 Malaysia (online or onsite) targets intermediate to advanced database administrators seeking to deepen their understanding 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 the 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 Malaysia (online or onsite) is targeted at intermediate database administrators who want to gain the necessary skills and knowledge to effectively manage and administer SQL Server databases using SQL Server Management Studio.

By the conclusion 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 Malaysia 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 Malaysia (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 optimize 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 Malaysia focuses on designing advanced SSIS data flows and transformations. Participants will master Slowly Changing Dimensions, handle complex data sources, and deploy robust packages for efficient data warehousing and migration scenarios.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Malaysia equips delegates with skills to handle complex result sets and optimize database performance. It covers analytical functions, index management, query tuning, and basic 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 Malaysia (online or onsite) is designed for intermediate software developers and automation engineers who want 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.
  • Optimize application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server