Transactions and Error Handling in SQL Server
|
Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.
It is critical to know how to handle errors and manage transactions when programming SQL scripts. Unhandled errors can be very harmful and can cause unexpected situations, such as inconsistent data in your database, or even worse, errors can lead you to make wrong business decisions.
In this course, you will learn how to handle errors and discover how to manage transactions in case of an error. Additionally, you will study what happens when two or more people interact at the same time with the same data. You will practice all these concepts using two datasets, one of them based on bank accounts and the other one on an electric bike store.
User Reviews
Be the first to review “Transactions and Error Handling in SQL Server”
Related Products
Joining Data in SQL
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
Learn Intermediate SQL for Marketers and Product Managers
Perform data analysis on funnels, churn, and attribution. This course contains advanced SQL content for new Marketers and Product Managers.
Analyzing Business Data in SQL
Learn to write SQL queries to calculate key metrics that businesses use to measure performance.
Full-Stack Engineer
A full-stack engineer can get a project done from start to finish, back-end to front-end.
Data Scientist: Inference Specialist
Inference Data Scientists run A/B tests, do root-cause analysis, and conduct experiments. They use Python, SQL, and R to analyze data.
Learn SQL: Multiple Tables
Combine data stored across multiple tables using joins, unions, and temporary tables.
There are no reviews yet.