Creating Stored Procedures
Creating User-Defined Functions
Implementing Managed Code with SQLCLR (SQL Common Language Runtime)
Implementing code with R
Developing a database can include the creation of programmatic database objects. These objects encapsulate different types of functionality inside your database. In this computer science course, you’ll learn about the types of programmatic database objects, how to create stored procedures, triggers, user-defined functions, and advanced topics including implementing managed code, and using the R programming language.
This course is part of the Microsoft SQL Database Development XSeries.
Knowledge of writing T-SQL queries
Knowledge of basic relational database concepts