Transactions and Error Handling in PostgreSQL

СреднийУровень мастерства

Обновлено 12.2024

Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.

Создайте бесплатный аккаунт

или

Продолжая, вы принимаете наши Условия использования, нашу Политику конфиденциальности и подтверждаете, что ваши данные хранятся в США.

Описание курса

Being able to leverage transactions and find and handle errors is critical to building resilient SQL scripts and working with databases. Transactions provide the protection needed to ensure that your data is consistent and operations work on the desired data in concurrent environments. Improper error handling can cause many serious and unexpected issues. Without the proper use of transactions and error handling, it's possible to make decisions based on incorrect data leading to false outcomes. In this course, we'll cover proper ways to use transactions and handle errors with a record of what went wrong. Additionally, we discuss how concurrently plays into the use of transactions and data outcomes. We'll practice these concepts on the FFEIC bank health data and with a patient data table.

Предварительные требования

Data Manipulation in SQL

Getting to Know Transactions

This chapter focuses on learning about single and multistatement transactions and the read committed isolation level.

Welcome to Transactions and Error Handling in PostgreSQL

Описание курса

Получите свидетельство о достижениях

Присоединяйтесь .css-nklxlk{color:var(--wf-brand--main, #03EF62);} 19 миллионов учащихся и начните Transactions and Error Handling in PostgreSQL сегодня!

Создайте бесплатный аккаунт

Развивайте свои навыки работы с данными с помощью DataCamp для мобильных устройств.

Присоединяйтесь 19 миллионов учащихся и начните Transactions and Error Handling in PostgreSQL сегодня!