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 Review
- DQL, DML, and DDL concepts
- Utilizing GROUP BY and HAVING clauses
- Working with sub-queries and correlated sub-queries
- Advanced UPDATE and DELETE statements
- Implementation of sub-queries
- Application of correlated sub-queries
Procedural Programming Techniques
- Variable management
- Control-of-flow constructs
- Use of IF, WHILE, CASE, GOTO, and RETURN statements
Error Management Strategies
- Strategies for responding to errors
- Using the RAISERROR statement
- Utilizing the PRINT statement
Transaction Administration
- Foundations of transaction management
- Understanding transaction isolation levels
- Addressing deadlocks
- Implementing transactional error handling
Cursor Implementation
- Defining cursors
- Operations: OPEN, FETCH, and CLOSE
- Releasing resources with DEALLOCATE
- Using the CURRENT OF syntax
Developing Stored Procedures
- Creation of stored procedures
- Passing input values to stored procedures
- Retrieving output from stored procedures
- Modifying existing stored procedures
Database Triggers
- Creating and configuring triggers
- Managing transactional errors within triggers
- Leveraging the Inserted and Deleted pseudo-tables
Requirements
Participants must possess a solid understanding 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
