Take this
course

Test Prep / Software Exams

SQL Server 2012 (70-464): Implementing Managed Code in SQL Server

As a database professional, you have probably come across situations where SQL Server does not have the exact capabilities to meet the business requirements. In this course you will be learning how to meet complex business requirements by implementing managed code in SQL server. This course will go over importing and cataloging assemblies and choosing between managed code and T-SQL for your situation. This course will also go over how to choose appropriate database objects.

Description

As a database professional, you have probably come across situations where SQL Server does not have the exact capabilities to meet the business requirements. In this "Implementing Managed Code in SQL Server" LearnSmart course you will be learning how to meet complex business requirements by implementing managed code in SQL server. This course will go over importing and cataloging assemblies and choosing between managed code and T-SQL for your situation. This course will also go over how to choose appropriate database objects.


Topics Covered Include:
-Introduction to SQL CLR
-Importing and Cataloging Assembly
-Implementing SQL CLR Integration

Full details

Curriculum

  • Course Orientation
    Course Orientation
    1:54
    Implementing Managed Code in SQL Server: Supplemental Materials
    "Take advantage of all our extra downloadable supplemental materials. This .zip file includes PDF versions of our Script, PPT Slides, Quiz Questions, and vocabulary tools to better enhance your understanding for this ""SQL Server 2012 (70-464): Implementing Managed Code in SQL Server"" Course."
  • Introduction to SQL CLR
    Overview
    2:44
    Alternatives to Extending the Server
    1:40
    Managed Code vs Extended Stored Procedures
    1:36
    .NET Common Language Runtime
    5:31
    Using Managed Code in SQL Server
    2:27
    Error Handling in Managed Code
    1:26
    SHOW ME Demonstration: Error Handling in Managed Code
    1:41
    Managed Code vs T-SQL
    1:23
    Choosing the Appropriate Datatebase Object in Managed Code
    2:01
    Knowledge Check
    0:29
  • Importing and Cataloging Assembly
    Assembly
    3:57
    Importing an Assembly
    1:20
    SHOW ME Demonstration: Importing and Cataloging an Assembly
    2:20
    Knowledge Check
    0:26
  • Implementing SQL CLR Integration
    Attribute Usage in Creation of Assemblies
    2:23
    Implementing User-Defined Functions
    1:36
    Implementing Stored Procedures
    1:23
    Implementing Triggers
    1:02
    Implementing User-Defined Aggregates
    2:00
    Implementing User-Defined Data Types
    1:33
    SHOW ME Demonstration: Cataloging the User-Defined Data Types
    2:42
    Best Practices
    1:12
    Knowledge Check
    0:37
    Conclusion
    0:49

Skills

  • Database Management System (DBMS)
  • Database Management
  • SQL Server

Similar Courses

More Courses by this Instructor