Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Handling Errors in T-SQL Code

When you code a program, it’s imperative that you handle exceptions or errors. If you don’t, the program can bomb any time an error is found. We will be discussing errors and what happens when errors occur in a program. Learn about Transact-SQL error handling, how it has traditionally been implemented, and how to implement structured exception handling in T-SQL.

Description

When you code a program, it’s imperative that you handle exceptions or errors. If you don’t, the program can bomb any time an error is found. In this "Handling Errors in T-SQL Code" LearnSmart Course we will be discussing errors and what happens when errors occur in a program. You will be learning about Transact-SQL error handling, how it has traditionally been implemented, and how to implement structured exception handling in T-SQL. This chapter will be paired with demos giving the students a real world look at the concepts that will be discussed, as well as knowledge checks  to help test the your knowledge throughout the course.

Topics Covered Include:
-T-SQL Error Handling
-Handling Errors
-Structured Error Handling

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Handling Errors in T-SQL Code: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Handling Errors in T-SQL Code"" Course."
  • T-SQL Error Handling
    Intro to Error Handling
    1:05
    Errors in Transact-SQL
    2:23
    Error Object and Severity
    3:00
    Types of Errors
    1:55
    SHOW ME Demonstration: Working with Error Types and Severity
    1:40
    Knowledge Check
    0:34
  • Handling Errors
    Raising Errors
    2:07
    SHOW ME Demonstration: Handling Errors Using T-SQL
    2:44
    Errors and Transactions
    2:56
    Using @@ERROR
    1:33
    Transaction Nesting Errors
    4:55
    SHOW ME Demonstration: Explicit Transactions and Transaction Nesting Errors
    2:14
    Raising Custom Errors
    1:48
    Creating Alerts When Errors Occur
    1:34
    Knowledge Check
    0:57
  • Structured Error Handling
    Structured Error Handling and Try/Catch Block Programming
    1:49
    Error Handling Functions
    1:15
    Catachable vs. Non-Catchable and Rethrowing Errors
    1:30
    TRY/CATCH and Transactions
    1:48
    SHOW ME Demonstration: Applying Retry Logic to Deadlocks
    3:18
    Errors in Managed Code
    0:48
    Best Practices in Error Handling
    1:18
    Knowledge Check
    0:38
    Conclusion
    0:57

Skills

  • Database Management
  • Database Management System (DBMS)
  • SQL Server

Similar Courses

More Courses by this Instructor