Conteúdo do Curso
Advanced Techniques in SQL
Advanced Techniques in SQL
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:
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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
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:
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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo