An effective strategy that database developers often employ to interface between applications and SQL Server 2012 involves the creation of programs using the Transact-SQL language and saving them as stored procedures or functions as database objects. Subsequently the applications can execute these programs as required and process results. This course introduces this powerful database programming concept and covers the types of programs available, design issues and implementation considerations. This course is one of a series in the Skillsoft learning path that covers the objectives for the Exam 70-464: Developing Microsoft SQL Server Databases. This series may also cover SQL Server 2014 features and functionalities as required by the exam objectives. This exam is one of the requirements for the MCSE: Data Platform certification path.
Create Stored Procedures and TABLE Types
- identify the characteristics of stored procedures
- identify how to manage stored procedures in a given scenario
- recognize the advantages of using table-valued parameters
Design and Create UDFs
- differentiate between table-valued and scalar functions
- identify the considerations for using a multi-statement table-valued function