SQL Server - TSQL
Pluralsight
Course Summary
This course covers the fundamentals of using SQL Server from T-SQL to the CLR, to automating processing with SQL Server Integration services
-
+
Course Description
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.
-
+
Course Syllabus
T-SQL and the CLR- 1h 17m
—T-SQL and CLR Overview 3m 4s
—Why use the CLR? 2m 52s
—Visual Studio and Extensions 1m 27s
—Demo:Simple UDF 3m 18s
—Demo:Directly adding UDF 4m 19s
—Demo:Debugging Extension 5m 19s
—Assembly Permission 2m 35s
—Demo:Create Assembly Permission 7m 51s
—Demo:CLR Enable 2m 53s
—Demo:External Access Trustworthy 6m 3s
—Demo:External Access Signed 4m 52s
—CLR in a Box 6m 9s
—SqlFunction Attribute 11m 41s
—Data Access 5m 33s
—Table Valued Functions 8m 36s
—Conclusion 0m 59sT-SQL and the CLR II- 1h 10m
—T-SQL and CLR II Overview 0m 33s
—SqlTypes 1m 4s
—SqlTypes vs. .NET Types 4m 50s
—Equivalent Types 4m 20s
—Null Support 8m 26s
—SqlString 3m 51s
—Stored Procedures 2m 3s
—Stored Procedure Basics 4m 11s
—SqlContext 1m 8s
—SqlPipe Messages 0m 59s
—Constructed Resultset 1m 6s
—Fibonacci Series 0m 58s
—Implementing Fibonacci Series 5m 24s
—Stored Procedure Database Access 14m 7s
—Aggregate Functions 1m 54s
—SqlUserDefinedAggregate 2m 56s
—SumSpecial User Defined Aggregate 10m 27s
—Summary 1m 52s
—References 0m 26sT-SQL I- 45m 27sT-SQL II- 38m 58sT-SQL III- 54m 30s
This course is listed under
Development & Implementations
, Data & Information Management
and Server & Storage Management
Community
Related Posts: