MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

SQL Server - TSQL

Course Summary

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


  • +

    Course Syllabus

    ● T-SQL and the CLR
        ◦     T-SQL and CLR Overview
        ◦     Why use the CLR?
        ◦     Visual Studio and Extensions
        ◦     Assembly Permission
        ◦     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
     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top