Microsoft SQL training exercises | Transactions

Showing exercises 1-4 (out of 4)

Category: SQL
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 ...

Category: SQL
Topic: Transactions
Level: Average difficulty
Course: Advanced SQL
Exercise: Create a procedure to delete all over 18 sites from a database within a transaction, then roll this back and prove this has undone the deletion.

Go to exercise ...

Category: SQL
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 ...

Category: SQL
Topic: Transactions
Level: Harder than average
Course: Advanced SQL
Exercise: Within a transaction, update a column to show number of courses attended, then delete those people who have attended 5 or less - then roll back.

Go to exercise ...

This page has 0 threads Add post