1. Congratulations!
Congratulations! You have made it to the end of the course Transactions and error handling in SQL Server. Let's review what you learned!
2. Chapters 1 and 2 - Error handling
In chapters 1 and 2 we studied how to handle errors in SQL Server. We learned how to use the TRY...CATCH construct. We also analyzed the anatomy of the errors, explaining each part of them. We saw there are some errors that a CATCH block can't catch. We used some functions that give us information about errors, such as ERROR_NUMBER(), ERROR_SEVERITY(), ERROR_STATE(), ERROR_LINE(), ERROR_PROCEDURE(), and ERROR_MESSAGE(). We demonstrated how to raise errors using RAISERROR and THROW, and we saw the differences between both of them.
3. Chapter 3 - Transactions
In chapter 3, we explained the concept of transactions, and we learned how to use the transaction statements, BEGIN TRAN, COMMIT TRAN, and ROLLBACK TRAN. We also practiced with the @@TRANCOUNT function, and with savepoints. We ended the chapter controlling the errors in transactions with the use of XACT_ABORT and XACT_STATE.
4. Chapter 4 - transaction isolation levels
In this final chapter, we clarified the concept of concurrency. After that, we explained the different isolation levels that SQL Server provides: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE and, SNAPSHOT. We learned the differences between them and whether they prevent some concurrency phenomena such as dirty reads, non-repeatable reads, and phantom reads.
5. Thank you!
Thank you very much for your time! I hope you enjoyed this course and I hope the content of this course will help you with your job.