Designing an Exception Handling Strategy for Microsoft® SQL Server„¢ 2005(4351)


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.



  • 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


User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-DEH-SS205
  • Duration: 1 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend