Get in Touch

Course Outline

Structured Query Language Refresher

  • DQL, DML, and DDL
  • GROUP BY and HAVING Clauses
  • Subqueries and Correlated Subqueries
  • Advanced Update and Delete Statements
  • Subqueries
  • Correlated Subqueries

Procedural Programming

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

Error Management

  • Handling Errors
  • RAISERROR
  • PRINT

Transaction Management

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

Cursor Implementation

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

Stored Procedures

  • Creating Stored Procedures
  • Passing Parameters to Stored Procedures
  • Retrieving Data from Stored Procedures
  • Modifying Stored Procedures

Triggers

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

Requirements

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

Upcoming Courses

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-12 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-26 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-09 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-23 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-07 09:30
14 hours
Empire Tower
63214 THB (Online)
63214 THB (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Thailand, this training equips administrators with the skills to manage SQL Server efficiently. Participants will master database creation, utilize SQL syntax for data retrieval, and enforce security protocols. You will also investigate advanced features like replication, automation, and BI to construct complex, practical solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Thailand is intended for participants with existing SQL Server experience. It concentrates on set-based querying, query tuning, index optimization, and execution plan analysis. Learners will gain proficiency 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 program is tailored to cultivate a comprehensive grasp of advanced SQL syntax and methodologies within Microsoft SQL Server. By refining expertise in analytical functions, table joins, subqueries, and aggregation techniques, participants will discover how to shift data analysis workflows from MS Excel directly to the database layer. This strategic shift enhances operational efficiency and underpins the construction of resilient IT systems built upon the Microsoft SQL Server architecture.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Master T-SQL fundamentals in this hands-on course in Thailand. Gain proficiency in using SQL Server Management Studio, constructing tables with DDL and DML, and crafting complex queries using joins and subqueries. This course is ideal for beginners aiming to build core database competencies and gain practical experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course in Thailand focuses on developing efficient query-writing skills for Microsoft SQL Server. It provides a comprehensive overview of relational models, alongside techniques for data retrieval, filtering, and aggregation. Upon completion, participants will have mastered multi-table joins, subqueries, and DML operations, enabling them to manipulate business intelligence datasets effectively and consistently.
Read more...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led course in Thailand focuses on the fundamentals of SQL with Microsoft SQL Server, enabling participants to excel in querying, database design, and normalization. Through practical, hands-on activities, learners will develop proficiency in T-SQL to optimize data workflows and establish seamless connections with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This instructor-led, live training in Thailand focuses on essential SQL Server administration skills. Learners will gain proficiency in installing and configuring environments, managing databases, and monitoring performance. It is ideally suited for IT professionals seeking practical experience with automation and troubleshooting.
Read more...

Microsoft SQL Server for Database Administrators: Intermediate to Advanced

 28 Hours

This live, instructor-led training in Thailand (offered online or on-site) is designed for database administrators at the intermediate to advanced level. It aims to strengthen their SQL Server knowledge for superior database management, performance tuning, high availability, and complex troubleshooting.

Following the training, participants will be equipped to:

  • Administer and set up SQL Server instances following best practices.
  • Improve the speed and efficiency of queries and databases.
  • Establish high availability and disaster recovery frameworks.
  • Pinpoint and fix sophisticated issues in live production systems.A
Read more...

SQL Server Management Studio (SSMS) Administration

 21 Hours

This live, instructor-led training is conducted in Thailand (available online or onsite) and is designed for intermediate-level database administrators. It focuses on imparting the essential skills and knowledge needed to proficiently manage and administer SQL Server databases using SQL Server Management Studio.

Upon completion of this program, participants will be equipped to:

  • Understand system prerequisites and carry out installations.
  • Utilize SSMS to create, configure, and manage databases.
  • Administer logins, users, roles, and permissions.
  • Execute diverse backup types and perform database restores.
  • Generate, schedule, and oversee jobs using SQL Server Agent.
  • Apply industry best practices for secure and efficient SQL Server administration.
Read more...

Business Intelligence with SSAS

 14 Hours
This practical course on Thailand delves into SQL Server Analysis Services for advanced BI strategies and data modeling. Learners will master the design of OLAP cubes, the application of MDX queries, and the deployment of robust solutions, equipping them with the expertise necessary to foster data-driven decisions within modern business environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Thailand (available online or on-site) is designed for beginner-level data professionals aiming to acquire the skills necessary to design, implement, and manage SSIS packages for data integration and transformation tasks.

Upon completion, participants will be capable of:

  • Understanding the architecture and components of SSIS.
  • Designing and implementing ETL processes using SSIS.
  • Utilizing SSIS tools to develop, deploy, and manage data integration solutions.
  • Troubleshooting and optimizing 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 Thailand is dedicated to mastering advanced SSIS data flow design and complex transformations. Learners will gain expertise in implementing Slowly Changing Dimensions, managing intricate data sources, and deploying resilient packages to support efficient data warehousing and migration initiatives.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Thailand empowers participants with the skills to manage complex result sets and optimize database performance. It covers analytical functions, index management, query tuning, and fundamental 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 Thailand (online or onsite) is aimed at 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.
  • Optimize application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server