Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Learn Challenge: Transaction Creation | ACID
Advanced Techniques in SQL

Swipe to show menu

book
Challenge: Transaction Creation

Now, let's walk through creating a transaction ourselves based on the bank_accounts table described in the previous chapter.

We're going to perform a straightforward financial transaction: transferring funds from one account to another. Ensuring that both steps occur as a single logical unit exemplifies a real-life transaction.

We will work with account numbers 101 and 789 and the initial balance will be the following:

Task

Swipe to start coding

Your task is to fill in the gaps in the query to create a SQL transaction. Use the keywords BEGIN and COMMIT to do it.

Once you've completed this task, click the button below the code to check your solution.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 4

Ask AI

expand
ChatGPT

Ask anything or try one of the suggested questions to begin our chat

book
Challenge: Transaction Creation

Now, let's walk through creating a transaction ourselves based on the bank_accounts table described in the previous chapter.

We're going to perform a straightforward financial transaction: transferring funds from one account to another. Ensuring that both steps occur as a single logical unit exemplifies a real-life transaction.

We will work with account numbers 101 and 789 and the initial balance will be the following:

Task

Swipe to start coding

Your task is to fill in the gaps in the query to create a SQL transaction. Use the keywords BEGIN and COMMIT to do it.

Once you've completed this task, click the button below the code to check your solution.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 4
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt