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:

Завдання

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

Завдання

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

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Секція 1. Розділ 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:

Завдання

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

Завдання

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

Все було зрозуміло?

Секція 1. Розділ 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:

Завдання

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

Завдання

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

Все було зрозуміло?

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:

Завдання

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

Секція 1. Розділ 4