SQL Server - TSQL [2010, ENG] torrent

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

SQL Server - TSQL

Год выпуска: 2010
Производитель: Pluralsight
Сайт производителя: pluralsight.com
Автор: Dan Sullivan
Продолжительность: 4:47
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: This course is primarily for C# developers who use SQL Server in their applications. T-SQL developers and Database Administrators will also find it useful. It covers the fundamentals of using SQL Server from T-SQL to the CLR, to automating processing with SQL Server Integration services.
[spoiler="Содержание"]
T-SQL and the CLR
T-SQL and CLR Overview
Why use the CLR?
Visual Studio and Extensions
Demo:Simple UDF
Demo:Directly adding UDF
Demo:Debugging Extension
Assembly Permission
Demo:Create Assembly Permission
Demo:CLR Enable
Demo:External Access Trustworthy
Demo:External Access Signed
CLR in a Box
SqlFunction Attribute
Data Access
Table Valued Functions
Conclusion

T-SQL and the CLR II
T-SQL and CLR II Overview
SqlTypes
SqlTypes vs. .NET Types
Equivalent Types
Null Support
SqlString
Stored Procedures
Stored Procedure Basics
SqlContext
SqlPipe Messages
Constructed Resultset
Fibonacci Series
Implementing Fibonacci Series
Stored Procedure Database Access
Aggregate Functions
SqlUserDefinedAggregate
SumSpecial User Defined Aggregate
Summary
References

T-SQL I
Title
Overview
Table Row Constructor
Table Row Constructor Examples
Output Clause
Output Clause Examples
Large Datatypes
Large Datatypes Examples
Covering Index
Covering Index Examples
Summary

T-SQL II
Overview
Top
Top Example
Top and Modifications
Exceptions
Exception Information
Exception Example
Exception and Fatal Error
Uncommitable Transaction
Error Functions
Error Severity
Summary

T-SQL III
Overview
Isolation
Snapshot implements isolation
Transaction and isolation
Missing Update
Incoherent Data
Serialized Access
Most data not shared
Transactions run in isolation
Implementing serializable isolation
Locks and blocking
Implementing snapshot isolation
Example read committed
Example snapshot
Snapshots and writes
Version lifetime
Read committed snapshot
Example read committed snapshot
Snapshot management
Summary
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 4:3, 15fps, 132kbps
Аудио: WMA, 44.1kHz, 48kbps, mono
[spoiler="Скриншоты"]

[/spoiler]