SQL Server 2012: Transact-SQL Error Handling [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server 2012: Transact-SQL Error Handling

Год выпуска: 2013
Производитель: Pluralsight
Автор: Joe Sack
Продолжительность: 1h 21m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
Научитесь писать Transact-SQL код, который правильно обрабатывает ожидаемые и неожидаемые ошибки.

Learn how to write Transact-SQL code that deals correctly with anticipated and unanticipated errors during code execution, for developers and DBAs from SQL Server 2005 onward

Robust Transact-SQL coding practices dictate proactive planning for anticipated and unanticipated errors that might occur during code module execution.
SQL Server’s flavor of Transact-SQL provides several commands that can be used to properly handle errors in your code and this course will cover the fundamental commands you’ll need to know, as well as effective error handling techniques that will help you properly handle issues for high throughput, mission-critical data tiers.
This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience.
The information in the course applies to all versions from SQL Server 2005 onward, with some emphasis on new SQL Server 2012 commands.
[spoiler="Содержание"]
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Course Introduction 1.17 MB 0:00:47 ‎128kbps 134.00 1024x768 ‎15 frames/second 01.Course Introduction
02.Where should our error handling live 1.08 MB 0:00:41 ‎128kbps 85.00 1024x768 ‎15 frames/second 01.Course Introduction
03.Course Structure 785 KB 0:00:30 ‎128kbps 35.00 1024x768 ‎15 frames/second 01.Course Introduction
01.Module Introduction 1.05 MB 0:00:43 ‎128kbps 87.00 1024x768 ‎15 frames/second 02.Command Fundamentals
02.RAISERROR 2.51 MB 0:01:58 ‎128kbps 44.00 1024x768 ‎15 frames/second 02.Command Fundamentals
03.Demo - RAISERROR 10.3 MB 0:04:42 ‎128kbps 528.00 1024x768 ‎15 frames/second 02.Command Fundamentals
04.TRY...CATCH 0.97 MB 0:00:44 ‎128kbps 44.00 1024x768 ‎15 frames/second 02.Command Fundamentals
05.Demo - Legacy Error Handling 12.5 MB 0:04:32 ‎128kbps 1454.00 1024x768 ‎15 frames/second 02.Command Fundamentals
06.Demo - TRY... CATCH Error Handling 10.5 MB 0:02:56 ‎128kbps 895.00 1024x768 ‎15 frames/second 02.Command Fundamentals
07.Demo - Nested TRY... CATCH 9.60 MB 0:03:52 ‎128kbps 700.00 1024x768 ‎15 frames/second 02.Command Fundamentals
08.Demo - TRY... CATCH Gaps 9.28 MB 0:03:48 ‎128kbps 439.00 1024x768 ‎15 frames/second 02.Command Fundamentals
09.Error Information 1.70 MB 0:01:20 ‎128kbps 51.00 1024x768 ‎15 frames/second 02.Command Fundamentals
10.Demo - @@ERROR 4.04 MB 0:02:17 ‎128kbps 288.00 1024x768 ‎15 frames/second 02.Command Fundamentals
11.Demo - CATCH Block Error Information 6.52 MB 0:02:07 ‎128kbps 1049.00 1024x768 ‎15 frames/second 02.Command Fundamentals
12.THROW 1.17 MB 0:00:55 ‎128kbps 41.00 1024x768 ‎15 frames/second 02.Command Fundamentals
13.Demo - THROW with TRY CATCH 6.66 MB 0:02:27 ‎128kbps 700.00 1024x768 ‎15 frames/second 02.Command Fundamentals
14.Demo - THROW Outside of TRY CATCH 3.31 MB 0:01:31 ‎128kbps 311.00 1024x768 ‎15 frames/second 02.Command Fundamentals
15.Transaction Commands 2.76 MB 0:02:01 ‎128kbps 119.00 1024x768 ‎15 frames/second 02.Command Fundamentals
16.Demo - Transaction Handling and TRY CATCH 4.36 MB 0:01:40 ‎128kbps 599.00 1024x768 ‎15 frames/second 02.Command Fundamentals
17.Demo - Transaction Handling and XACT_ABORT 7.30 MB 0:02:54 ‎128kbps 469.00 1024x768 ‎15 frames/second 02.Command Fundamentals
18.Demo - Transaction Handling with THROW vs. RAISERROR 6.05 MB 0:01:57 ‎128kbps 785.00 1024x768 ‎15 frames/second 02.Command Fundamentals
19.Demo - Checking Transaction States 8.36 MB 0:02:53 ‎128kbps 650.00 1024x768 ‎15 frames/second 02.Command Fundamentals
20.Demo - Doomed Transaction Handling 4.99 MB 0:01:56 ‎128kbps 691.00 1024x768 ‎15 frames/second 02.Command Fundamentals
01.Module Introduction 1.27 MB 0:00:54 ‎128kbps 101.00 1024x768 ‎15 frames/second 03.Message Handling
02.sys.messages 1.17 MB 0:00:54 ‎128kbps 51.00 1024x768 ‎15 frames/second 03.Message Handling
03.Demo - sys.messages 5.14 MB 0:01:11 ‎128kbps 3409.00 1024x768 ‎15 frames/second 03.Message Handling
04.Severity Levels 841 KB 0:00:36 ‎128kbps 67.00 1024x768 ‎15 frames/second 03.Message Handling
05.User-Defined Error Message Definition 935 KB 0:00:41 ‎128kbps 65.00 1024x768 ‎15 frames/second 03.Message Handling
06.Demo - Managing User-Defined Error Messages 6.98 MB 0:03:12 ‎128kbps 460.00 1024x768 ‎15 frames/second 03.Message Handling
07.FORMATMESSAGE 580 KB 0:00:26 ‎128kbps 33.00 1024x768 ‎15 frames/second 03.Message Handling
08.Demo - FORMATMESSAGE 5.02 MB 0:02:22 ‎128kbps 435.00 1024x768 ‎15 frames/second 03.Message Handling
01.Module Introduction 1.16 MB 0:00:48 ‎128kbps 82.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
02.Demo - Unplanned Error Handling Template 6.39 MB 0:03:23 ‎128kbps 365.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
03.Demo - Unplanned Error Handling Template - Implementation Example 5.73 MB 0:02:11 ‎128kbps 965.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
04.Demo - Planned Error Handling Template 5.51 MB 0:02:40 ‎128kbps 330.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
05.Demo - Planned Error Handling Template - Implementation Example 9.34 MB 0:03:14 ‎128kbps 1091.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
06.Demo - Unhandled Deadlock Example 1.93 MB 0:01:04 ‎128kbps 185.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
07.Demo - Handled Deadlock Example 3.79 MB 0:01:15 ‎128kbps 517.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
08.Demo - Handled Deadlock Example - with Retry 7.87 MB 0:02:59 ‎128kbps 584.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
09.Demo - Creating an Error Logging Procedure and Table 4.31 MB 0:01:44 ‎128kbps 413.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
10.Demo - Using the Error Logging Procedure and Table 4.74 MB 0:01:47 ‎128kbps 896.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
11.Course Summary 492 KB 0:00:22 ‎128kbps 43.00 1024x768 ‎15 frames/second 04.Error Handling Techniques
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
Видео: wmv3, 15 fps, 1024x768, 33~3409kbps
Аудио: wma2, 128kbps, 44.1kHz, Stereo
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise include slides and code files