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.
Duration 14 hours
Course Outline
Structured Query Language Review
- DQL, DML, and DDL fundamentals
- Utilizing the GROUP BY and HAVING clauses
- Exploring Sub-queries and Correlated Sub-queries
- Advanced Update & Delete Statements
- Detailed analysis of Sub-queries
- In-depth look at Correlated Sub-queries
Procedural Programming Techniques
- Variable management
- Control-of-flow statements
- IF, WHILE, CASE, GOTO, and RETURN constructs
Error Management Strategies
- Methods for responding to errors
- Using RAISERROR
- Implementing PRINT
Transaction Utilization
- Foundations of Transactions
- Transaction Isolation Levels
- Understanding and resolving Deadlocks
- Transactional Error Handling protocols
Cursor Implementation
- Cursor declaration procedures
- Operations: OPEN, FETCH, and CLOSE
- Executing DEALLOCATE
- Applying CURRENT OF
Stored Procedure Development
- Building Stored Procedures
- Inputting values into Stored Procedures
- Retrieving data from Stored Procedures
- Modifying existing Stored Procedures
Trigger Creation
- Designing and creating Triggers
- Managing Transactional Error Handling
- Leveraging Inserted and Deleted Tables
Requirements
Participants are expected to have a working knowledge of the Microsoft SQL Server SQL language.
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
