Course Outline
Review of Structured Query Language
- DQL, DML, DDL
- The GROUP BY, HAVING Clause
- 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
Managing Errors
- Responding To Errors
- RAISERROR
Using Transactions
- Introduction To Transactions
- Transaction Isolation Levels
- Deadlocks
- Transactional Error Handling
Implementing Cursors
- Declaring Cursors
- OPEN, FETCH, CLOSE
- DEALLOCATE
- CURRENT OF
Stored Procedures
- Creating Stored Procedures
- Passing values into a Stored Procedure
- Returning Information From Stored Procedures
- Altering Stored Procedures
Triggers
- Creating Triggers
- Transactional Error Handling
- Using Inserted and Deleted Tables
Requirements
Delegates should be familiar with the Microsoft SQL Server SQL Language
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from £3800 online delivery, based on a group of 2 delegates, £1200 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
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
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
Kyvin Aw - Asure Quality LTD
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
The range of topics and challenging challenges