Objectives

The aim of this course is to teach you how to describe stored procedures and functions, as well as database triggers.

Is it for you ?

IT specialists.

Prerequisite

A good knowledge of the SQL language is required, and in particular of its implementation in SQL Server.

Your benefits

Develop stored procedures and functions to automate data processing tasks

Use Transact-SQL procedural logic to implement complex server-side operations

Handle exceptions to ensure reliable and secure execution of database processes

Apply cursors to process data row by row when required

Implement triggers to automate actions based on database events

Content

SQL Server procédural SQL

Curseurs
Exceptions
Procédures et fonctions stockées
Déclencheurs

Livre

Ce module donne accès à un support de cours numérique :

SQL Server 2022 SQL, Transact SQL : Concevoir, construire et utiliser une base de données

💡 Useful information

100% online training. Accessible anytime, from anywhere, giving a one year of access to the training. If you have any questions regarding registration, the language of instruction, or cancellation policies, please consult our FAQ .

Trainers

Upcoming information

Duration

3.5 hours

Regular fee

$250

Private or personalized training

Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.

Request a quote

Advanced database management: Stored procedures and Transact SQL on SQL Server