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 show code editor

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.}

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 4

Challenge: Transaction Creation

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

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

Task

Swipe to show code editor

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.}

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 4

Switch to desktop for real-world practiceContinue from where you are using one of the options below