SQL exercises on TRANSACTIONS

This page lists the 5 exercises about Transactions in SQL on our website:

Software: SQL
Version: Any version of SQL Server
Topic: Transactions
Level: Relatively easy
Course: Advanced SQL
Exercise: Create a transaction, add Shaun the Sheep as a Doctor Who, then commit or roll this back.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Transactions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a transaction which prevents the same event being added multiple times.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Transactions
Level: Average difficulty
Course: Advanced SQL
Exercise: Update the number of Dr Who enemies within a transaction, and commit or roll this back.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Transactions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a transaction to update all countries that aren't your own, then roll it back.

Go to exercise ...

Software: SQL
Version: Any version of SQL Server
Topic: Transactions
Level: Average difficulty
Course: Advanced SQL
Exercise: Use the Insert, Update and Delete commands in a single transaction.

Go to exercise ...

You can search our full list of SQL exercises here, or why not have a look at our other SQL training resources?

This page has 0 threads Add post