Get in Touch

Course Outline

Structured Query Language Recap

  • DQL, DML, DDL
  • GROUP BY and HAVING clauses
  • Sub-queries and Correlated Sub-queries
  • Complex Update & 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

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

Cursor Implementation

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

Stored Procedures

  • Creating Stored Procedures
  • Passing values to Stored Procedures
  • Retrieving Information from Stored Procedures
  • Modifying Stored Procedures

Triggers

  • Creating Triggers
  • Transactional Error Handling
  • Utilizing Inserted and Deleted 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-14 09:30
14 hours
Bratislava CBC
460 EUR (Online)
860 EUR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-10-28 09:30
14 hours
Bratislava CBC
460 EUR (Online)
860 EUR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-11 09:30
14 hours
Bratislava CBC
460 EUR (Online)
860 EUR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-11-25 09:30
14 hours
Bratislava CBC
460 EUR (Online)
860 EUR (Classroom)

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

2026-12-09 09:30
14 hours
Bratislava CBC
460 EUR (Online)
860 EUR (Classroom)

Related Courses

Introduction to SQL Databases (10985CC)

 21 Hours
This three-day instructor-led course in Slovakia explores essential SQL database concepts, including data modelling, normalization, and database design. It enables participants to establish a robust theoretical foundation necessary for effective work with SQL Server and a clear understanding of performance implications.
Read more...

Administering in Microsoft SQL Server

 21 Hours
In Slovakia, this program equips administrators with the essential skills to manage SQL Server efficiently. Participants will gain mastery over database creation, SQL syntax for data retrieval, and security protocols. The course also delves into advanced capabilities like replication, automation, and BI to facilitate the construction of complex, practical solutions.
Read more...

Microsoft SQL Server (MSSQL)

 14 Hours
This instructor-led course in Slovakia is designed for delegates already acquainted with SQL Server. It focuses on set-based querying, query tuning, working with indexes, and analyzing execution plans. Participants will master table expressions, ranking functions, and partitioned tables.
Read more...

MS 20761 : Querying Data with Transact SQL

 35 Hours

The MS 20761 course is designed to equip learners with the skills necessary for writing Transact-SQL queries.

Read more...

MS SQL Server: SQL Advanced level for Data Analysts

14 Hours

This course offers an in-depth exploration of advanced SQL syntax and methodologies within Microsoft SQL Server. By gaining proficiency in analytical functions, table joins, subqueries, and aggregation strategies, participants will learn to shift data analysis workflows directly from MS Excel to the database layer. This transition not only enhances operational efficiency but also strengthens the foundation for building robust IT systems leveraging Microsoft SQL Server.

Read more...

T-SQL Fundamentals with SQL Server Training Course

 14 Hours
Develop proficiency in T-SQL fundamentals through this hands-on course in Slovakia. Participants will learn to navigate SQL Server Management Studio, construct tables using DDL and DML, and design complex queries incorporating 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 Slovakia focuses on creating efficient queries for Microsoft SQL Server. It covers relational structures, data extraction, filtering, and aggregation. 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 course on Slovakia delves into the fundamentals of SQL within Microsoft SQL Server, enabling participants to master data querying, database architecture, and normalization. Through practical, hands-on exercises, learners will develop proficiency in T-SQL to refine data optimization and establish seamless connections with Excel.
Read more...

Microsoft SQL Server Database Administration

 40 Hours
This live, instructor-led training in Slovakia focuses on essential SQL Server administration skills. Learners will gain the ability to install and configure environments, manage databases, and monitor performance. It is ideal for IT professionals looking to gain 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 Slovakia (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, available online or onsite, is directed at intermediate-level database administrators who wish to gain 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 Slovakia delves into SQL Server Analysis Services for advanced BI and data modeling. Participants will master the design of OLAP cubes, the application of MDX queries, and the deployment of resilient solutions, acquiring the hands-on skills necessary to facilitate data-driven decision-making in contemporary business environments.
Read more...

Introduction to SQL Server 2022 Integration Services (SSIS)

 28 Hours

This instructor-led, live training in Slovakia (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 Slovakia emphasizes the creation of sophisticated SSIS data flows and transformations. Attendees will gain mastery over Slowly Changing Dimensions, manage complex data sources, and deploy robust packages to streamline data warehousing and migration operations.
Read more...

Transact SQL Advanced

 7 Hours
This advanced Transact SQL course in Slovakia prepares participants to manage intricate result sets and enhance database performance. It addresses analytical functions, index administration, query optimization, and introductory data warehousing methods for Microsoft SQL Server.
Read more...

Related Categories

Microsoft SQL Server
Microsoft SQL Server