Course 4351: Designing an Exception Handling Strategy for Microsoft SQL Server 2005

Introduction In this 1-hour premium course, you will learn about how to design an exception handling strategy within your SQL Server 2005 Database solutions. Topics covered include defining, handling and detecting exceptions.

Having this experience will enable you to design databases that propertly notify applications of unexpected events that occur on the server so that they can be propertly handled.

This course will also prepare you for exam 70-442 PRO: Designing and Optimizing Data Access by Using Microsoft® SQL Server™ 2005. Objectives At the end of the course, students will be able to:

• Implement Database Exception Handling
  • Describe types of Exceptions
  • Describe severity levels
  • Expose Exceptions to administration tools
  • Handle Exceptions caused by data integrity violations
  • Create a User-Defined Exception Strategy
• Detect Exceptions
  • Obtain Exception Information
  • Use TRY...CATCH
  • Detect Integrity Exceptions
• Detect Compile-Time and Run-Time Exceptions
  • Minimize Compile-Time Exceptions
  • Minimize Run-Time Exceptions
  • Detect Deadlocks
• Manage Exceptions
  • Log Exceptions
  • Create Meaningful Error Messages
  • Manage Server-Side Errors
• Filter User Input
  • Avoid SQL Injection attacks

Modules & Lessons Course Overview Module Introduction Navigation Overview Designing an Exception Handling Strategy Module Introduction Overview of Exception Handling Lesson Introduction Types of Exceptions in Database Systems Exception Severity Levels Exposing Exceptions to Administration Tools Techniques for Handling Exceptions Caused by Data Integrity Violations Guidelines for Creating a User-Defined Exception Strategy Self Test Exception Detection Techniques Lesson Introduction Overview of Obtaining Exception Information Methods of Obtaining Exception Information The TRY...CATCH Technique Detecting Integrity Exceptions Self Test Detecting Compile-Time and Run-Time Exceptions Lesson Introduction Guidelines for Minimizing Compile-Time Exceptions Guidelines for Minimizing Run-Time Exceptions Detecting Deadlocks Self Test Managing Exceptions Lesson Introduction Considerations for Managing Exceptions Guidelines for Logging Exceptions Guidelines for Creating Meaningful and Useful Error Messages Managing Server-Side Errors from the Server and the Client Guidelines for Proactively Managing Exceptions Self Test Filtering User Input Lesson Introduction Filtering User Input to Avoid SQL Injection Guidelines for Filtering User Input Self Test Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled