Creating Programmatic SQL Database Objects (edX)

Creating Programmatic SQL Database Objects (edX)
Course Auditing
Categories
Effort
Certification
Languages
Knowledge of writing T-SQL queries. Knowledge of basic relational database concepts.
Misc
Creating Programmatic SQL Database Objects (edX)
Learn how to add functionality to your database with programmatic database objects using the R programming language. 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.


What you'll learn:

- Creating Stored Procedures

- Creating Triggers

- Creating User-Defined Functions

- Implementing Managed Code with SQLCLR (SQL Common Language Runtime)

- Implementing code with R



Course Auditing
99.00 USD
Knowledge of writing T-SQL queries. Knowledge of basic relational database concepts.