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 & Delete Statements
  • Sub-queries
  • Correlated Sub-queries

Procedural Programming

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

Error Management

  • Error Response Strategies
  • RAISERROR
  • PRINT

Transaction Management

  • Introduction to Transactions
  • Transaction Isolation Levels
  • Deadlocks
  • Transactional Error Handling

Cursor Implementation

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

Stored Procedures

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

Triggers

  • Creating Triggers
  • Transactional Error Handling
  • Using the Inserted and Deleted Pseudo-Tables

Requirements

Participants should have a solid 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

Upcoming Courses

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-17 10:00
14 hours
Jungang-Dong Center
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-01 10:00
14 hours
Seoul - Gran Seoul
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-15 10:00
14 hours
Seoul Center 1
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-29 10:00
14 hours
Jungang-Dong Center
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2027-01-12 10:00
14 hours
Seoul - Gran Seoul
₩ 5000000 (Online)
₩ 10000000 (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In South Korea, this training equips administrators with the essential skills to manage SQL Server with confidence. Participants will master database creation, utilize SQL syntax for efficient data retrieval, and apply robust security protocols. Additionally, you will explore advanced capabilities such as replication, automation, and BI to construct sophisticated, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in South Korea is specifically designed for participants who already have familiarity with SQL Server. It delves into set-based querying, query optimization, index management, and the interpretation 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 module aims to cultivate a deep understanding of advanced SQL syntax and techniques within Microsoft SQL Server. By mastering analytical functions, table joins, subqueries, and aggregation strategies, participants will learn to execute data analysis tasks directly at the database layer rather than relying on MS Excel. This method not only boosts processing efficiency but also strengthens the infrastructure of robust IT systems built on Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Develop a strong grasp of T-SQL fundamentals through this practical course located in South Korea. You will learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and craft complex queries involving joins and subqueries. This course is ideal for beginners aiming to build essential database capabilities and gain hands-on experience with contemporary relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL course for South Korea focuses on writing efficient queries in Microsoft SQL Server. It addresses relational models, data retrieval, filtering, and aggregation. Learners will gain proficiency in multi-table joins, subqueries, and DML operations to effectively manage business intelligence data.
Read more...

Learning SQL with Microsoft SQL Server

 21 Hours
This instructor-led training in South Korea delves into the fundamentals of SQL within the Microsoft SQL Server environment. Participants will master essential skills in querying, database design, and normalization. Through practical, hands-on exercises, learners will develop proficiency in T-SQL to optimize data management and establish seamless integrations with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
Offered as a live, instructor-led session in South Korea, this course focuses on essential SQL Server administration capabilities. Learners will gain the skills to install and configure environments, manage database assets, and monitor performance metrics. It is particularly well-suited for IT professionals looking to enhance their 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 South Korea (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.A
Read more...

SQL Server Management Studio (SSMS) Administration

 21 Hours

This instructor-led, live training in South Korea (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 practical training in South Korea delves into SQL Server Analysis Services for advanced Business Intelligence and data modeling. Learners will acquire the skills to design OLAP cubes, utilize MDX queries, and implement robust solutions, thereby enhancing their ability to drive data-informed decision-making for contemporary business operations.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in South Korea (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 program in South Korea specializes in the design of advanced SSIS data flows and transformations. Learners will gain mastery over Slowly Changing Dimensions, navigate complex data sources, and deploy robust packages to optimize data warehousing and migration workflows.

Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in South Korea empowers participants with the skills to handle 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 session (online or onsite) targets intermediate software developers and automation engineers seeking to build applications that communicate with PLCs and interact with SQL databases using Visual Studio.

Upon completing this training, participants will be capable of:

  • Creating .NET applications in Visual Studio for industrial automation purposes.
  • Communicating with PLCs utilizing industrial protocols such as OPC UA.
  • Implementing database interactions with SQL Server to store and retrieve PLC data.
  • Optimizing application performance for real-time industrial settings.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server