Get in Touch

Course Outline

Refresher on Structured Query Language

  • DQL, DML, and DDL
  • Utilizing GROUP BY and HAVING clauses
  • Working with Sub-queries and Correlated Sub-queries
  • Advanced techniques for Update and Delete statements
  • Sub-queries
  • Correlated Sub-queries

Procedural Programming Concepts

  • Handling Variables
  • Control-Of-Flow statements
  • IF, WHILE, CASE, GOTO, and RETURN structures

Error Management

  • Strategies for responding to errors
  • Using RAISERROR
  • Utilizing PRINT

Transaction Management

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

Implementing Cursors

  • Cursor Declaration
  • Using OPEN, FETCH, and CLOSE commands
  • DEALLOCATE procedure
  • CURRENT OF syntax

Stored Procedures

  • Creating new Stored Procedures
  • Passing input values to Stored Procedures
  • Retrieving output information from Stored Procedures
  • Modifying existing Stored Procedures

Database Triggers

  • Creating Triggers
  • Handling Transactional Errors
  • Working with Inserted and Deleted pseudo-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

Upcoming Courses

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-12 09:30
14 hours
Puebla - Fratta Center
76,413 MXN (Online)
96,413 MXN (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-26 09:30
14 hours
Mexico City - Torre Concreta
76,413 MXN (Online)
96,413 MXN (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-09 09:30
14 hours
Mexico City - Samara Shops Tower A
76,413 MXN (Online)
96,413 MXN (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-23 09:30
14 hours
Mexico City - Spaces Santa Fé
76,413 MXN (Online)
96,413 MXN (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-07 09:30
14 hours
Mexico City - Corporativo Napoles Tower
76,413 MXN (Online)
96,413 MXN (Classroom)

Related Courses

Administering in Microsoft SQL Server

 21 Hours
In Mexico, this training equips administrators with the essential skills to manage SQL Server effectively. Participants will gain proficiency in database creation, utilizing SQL syntax for data retrieval, and implementing strict security protocols. Additionally, the curriculum explores advanced functionalities including replication, automation, and BI to construct complex, real-world solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course on Mexico is crafted for individuals with existing familiarity with SQL Server. It concentrates on advanced topics such as set-based querying, query tuning, index management, and execution plan analysis. Participants will gain proficiency in handling table expressions, ranking functions, and partitioned tables.
Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

Designed to build a deep command of advanced SQL syntax and techniques within Microsoft SQL Server, this course guides learners through mastering analytical functions, table joins, subqueries, and aggregation methods. Participants will discover how to shift data analysis workflows from MS Excel directly into the database environment, a strategy that enhances operational efficiency and fosters the creation of stable IT architectures 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 Mexico. Learn to navigate SQL Server Management Studio, create tables using DDL and DML, and construct complex queries with joins and subqueries. Ideal for beginners seeking core database proficiency and practical experience with modern relational systems.
Read more...

SQL language in MSSQL

 14 Hours
This practical SQL training in Mexico focuses on writing efficient queries for Microsoft SQL Server. It covers 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 on Mexico focuses on the core aspects of SQL using Microsoft SQL Server, enabling participants to excel in querying, database design, and normalization. Through practical, hands-on exercises, learners will develop proficiency in T-SQL to optimize data workflows and establish seamless integrations with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This live, instructor-led session on Mexico focuses on essential SQL Server administration competencies. Learners will develop skills in environment setup, database governance, and performance oversight. It is particularly suited 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 Mexico (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 Mexico (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 Mexico delves into SQL Server Analysis Services for sophisticated BI and data modeling. Learners will master the design of OLAP cubes, the application of MDX queries, and the deployment of robust solutions, acquiring the essential skills to support data-driven decision-making in modern business environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Mexico (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 Mexico centers on 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 support efficient data warehousing and migration initiatives.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Mexico empowers delegates with the skills required to manage complex result sets and optimize database performance. It explores 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 Mexico (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.
  • Optimize application performance for real-time industrial environments.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server