Course Outline
Structured Query Language Refresher
- DQL, DML, and DDL
- Utilizing GROUP BY and the HAVING Clause
- Sub-queries and Correlated Sub-queries
- Advanced Update and Delete Operations
- Sub-queries
- Correlated Sub-queries
Procedural Programming
- Variable Declaration
- Flow Control Statements
- Implementing IF, WHILE, CASE, GOTO, and RETURN
Error Management
- Handling Error Responses
- Using RAISERROR
- Employing PRINT
Transaction Handling
- Overview of Transactions
- Isolation Levels in Transactions
- Understanding Deadlocks
- Error Management within Transactions
Working with Cursors
- Declaring a Cursor
- Executing OPEN, FETCH, and CLOSE
- Releasing Resources with DEALLOCATE
- The CURRENT OF Syntax
Developing Stored Procedures
- Creation of Stored Procedures
- Inputting Values into Procedures
- Retrieving Data from Stored Procedures
- Modifying Existing Procedures
Implementing Triggers
- Constructing Triggers
- Managing Errors within Triggers
- Leveraging Inserted and Deleted Pseudo-Tables
Requirements
Participants are expected to possess a working knowledge of the SQL Language in Microsoft SQL Server
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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
