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
Testimonials
He asked each individual about their thoughts and feedback. Very good knowledge of SQL.
Krisztina BALOGH, Diehl
Lot of content and exactly the requested one.
Pascal - Krisztina BALOGH, Diehl
The trainer had a high level of Expertise and could answer all upcoming questions
Krisztina BALOGH, Diehl
The effort it took for the trainer to prepare for the training
Krisztina BALOGH, Diehl
There were a lot of exercises really good exercises and the trainer passed on his knowledge well.
Zsolt - Krisztina BALOGH, Diehl
The excercises, because we do it together, and the trainer explained it.
Krisztina BALOGH, Diehl
Pace of training, explanations of tasks. Generally really good training.
Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Trainer style and knowledge
Aneta Tunderska, EY GDS (CS) POLAND SP. Z O.O.
Communicative, big knowledge and well presented material