MP9003: Network and Database (General) - Transaction Processing and Cursors > SQL for the Windows Environment

This course shows you how to use transaction processing to execute SQL operations in batches. This enables you to prevent processing errors from corrupting the database. 

Topics:
Understanding transaction processing
Controlling transactions
Setting savepoints
Understanding cursors
Working with cursors

Objectives:
Explain how transaction processing works in SQL code
Control transactions
Explain how cursors are used to save SQL results
Declare and use cursors in your SQL code

Duration:
2 Hours