Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Structured Query Language Refresher
- DQL, DML, and DDL
- Utilizing GROUP BY and the HAVING Clause
- Sub-queries and Correlated Sub-queries
- Sophisticated Update and Delete Operations
- Sub-queries
- Correlated Sub-queries
Procedural Logic
- Variable Management
- Flow Control Statements
- IF, WHILE, CASE, GOTO, and RETURN
Error Management
- Handling Error Responses
- RAISERROR
Transaction Control
- Overview of Transactions
- Transaction Isolation Levels
- Deadlock Resolution
- Error Handling within Transactions
Cursor Implementation
- Defining Cursors
- OPEN, FETCH, and CLOSE Operations
- DEALLOCATE
- CURRENT OF
Stored Procedures
- Building Stored Procedures
- Inputting Values into Stored Procedures
- Extracting Data from Stored Procedures
- Modifying Existing Stored Procedures
Triggers
- Developing Triggers
- Managing Errors in Triggers
- Leveraging Inserted and Deleted Tables
Requirements
Participants are expected to have a solid working knowledge of the Microsoft SQL Server SQL language.
14 Hours
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
