SQL Server - TSQL
This course covers the fundamentals of using SQL Server from T-SQL to the CLR, to automating processing with SQL Server Integration services
What you'll learn
This T-SQL tutorial 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. Learn the various features added to the Structured Query Language through T-SQL, such as transaction control, error handling, declared variables, and much more.
Table of contents
- T-SQL and CLR Overview 3m
- Why use the CLR? 3m
- Visual Studio and Extensions 1m
- Demo:Simple UDF 3m
- Demo:Directly adding UDF 4m
- Demo:Debugging Extension 5m
- Assembly Permission 3m
- Demo:Create Assembly Permission 8m
- Demo:CLR Enable 3m
- Demo:External Access Trustworthy 6m
- Demo:External Access Signed 5m
- CLR in a Box 6m
- SqlFunction Attribute 12m
- Data Access 6m
- Table Valued Functions 9m
- Conclusion 1m
- T-SQL and CLR II Overview 1m
- SqlTypes 1m
- SqlTypes vs. .NET Types 5m
- Equivalent Types 4m
- Null Support 8m
- SqlString 4m
- Stored Procedures 2m
- Stored Procedure Basics 4m
- SqlContext 1m
- SqlPipe Messages 1m
- Constructed Resultset 1m
- Fibonacci Series 1m
- Implementing Fibonacci Series 5m
- Stored Procedure Database Access 14m
- Aggregate Functions 2m
- SqlUserDefinedAggregate 3m
- SumSpecial User Defined Aggregate 10m
- Summary 2m
- References 0m
- Overview 0m
- Isolation 4m
- Snapshot implements isolation 1m
- Transaction and isolation 3m
- Missing Update 3m
- Incoherent Data 3m
- Serialized Access 4m
- Most data not shared 2m
- Transactions run in isolation 4m
- Implementing serializable isolation 3m
- Locks and blocking 4m
- Implementing snapshot isolation 8m
- Example read committed 2m
- Example snapshot 2m
- Snapshots and writes 3m
- Version lifetime 3m
- Read committed snapshot 2m
- Example read committed snapshot 2m
- Snapshot management 1m
- Summary 3m
About the author
Dan is an independent consultant, author, and speaker. He likes data; pointy data, rectangular data, even data just lying around on the floor. He is a co-author of the book "A Developers Guide to SQL Server 2005". His articles have been published in MSDN Magazine and SQL Server Magazine and he has spoken at WinDev, Microsoft events, as well as to various developer groups.