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.

Audience :

This series is for anyone who wants to use Structured Query Language (SQL) in a Windows Environment.

Time :

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

Features :

• Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
• Activities allow learners to apply course concepts in an interactive questioning environment.
• Exercises allow learners to practice in the actual application being studied.
• Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
• Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, in a dictionary, or in MindLeaders Reference Library (for subscribers). n addition, it lets them find other occurrences of the term in the same course.
• Search text enables learners to rapidly search all text within a course to easily retrieve information required.
• Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
• A skill assessment generates a customized learning path based on the results of a pre-test.
• A glossary provides a reference for definitions of unfamiliar terms.
• Bookmarking tracks a learner's progress in a course.

Prerequisites :

• None