Course Outline
Review of Structured Query Language
- DQL, DML, DDL
- The GROUP BY and HAVING Clauses
- Sub-queries and Correlated Sub-queries
- Advanced Update & Delete Statements
- Sub-queries
- Correlated Sub-queries
Procedural Programming
- Variables
- Control-of-Flow Statements
- IF, WHILE, CASE, GOTO, RETURN
Error Management
- Error Response Mechanisms
- RAISERROR
Utilizing Transactions
- Introduction to Transactions
- Transaction Isolation Levels
- Deadlocks
- Error Handling within Transactions
Implementing Cursors
- Declaring Cursors
- OPEN, FETCH, CLOSE
- DEALLOCATE
- CURRENT OF
Stored Procedures
- Creating Stored Procedures
- Passing Parameters to Stored Procedures
- Retrieving Data from Stored Procedures
- Modifying Stored Procedures
Triggers
- Creating Triggers
- Error Handling within Transactions
- Leveraging the Inserted and Deleted Tables
Requirements
Participants should already be familiar with the Microsoft SQL Server SQL language.
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 3200 € + 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
