Contenido del 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:
Tarea
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.
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¿Todo estuvo claro?
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:
Tarea
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.
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¿Todo estuvo claro?
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:
Tarea
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.
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones¿Todo estuvo claro?
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:
Tarea
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.
Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opcionesCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones