Share Description
In this course, you will learn :
- How to handle errors in T-SQL using the TRY...CATCH construct. You will learn about the anatomy of errors and how to use some functions that can provide information about errors.
- How to use RAISERROR and THROW to raise errors. You will also learn how to personalise errors.
- How to commit and rollback changes. You will then learn how to return the number of transactions as well as their state.
- Discover fascinating concepts such as dirty reads, repeatable reads, and phantom reads. To avoid or allow these reads, you will investigate the various transaction isolation levels one by one.
Syllabus :
- Starting with error handling
- Raising, throwing and customizing your errors
- Transactions in SQL Server
- Controlling the concurrency: Transaction isolation levels
