In SQL Server 2012 you can use Transact-SQL statements to access data in the databases. Transact-SQL statements can be grouped together in a number of ways to create more complex queries when one Transact-SQL statement will not retrieve the desired results. You can group Transact-SQL statements by creating programming objects within a database. These programming objects can include user-defined functions and DML triggers. When creating programming objects Transact-SQL provides control-of-flow keywords to ensure transaction are completed in a specific sequence and transaction are completed accordingly without errors. This course demonstrates how to use the control-of-flow language keywords, transaction modes, and how to create user-defined functions, including table-valued functions and DML triggers. This course is one of a series in the SkillSoft learning path that covers the objectives for the exam 70-461: Microsoft SQL Server 2012: Querying. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.
Candidates for this path should have two or more years of experience using SQL Server 2012 or a previous version of SQL Server, and they are seeking to prove their proficiency in writing queries. Candidates for this exam are IT professionals who have jobs in which database administration is their main area of responsibility, or they work as database developers.
Microsoft SQL Server 2012: Creating Functions and Triggers
- control the sequence of statement execution using control-of-flow language
- match the transaction modes to their descriptions
- create and modify user-defined functions
- create a DML trigger
- modify an existing DML trigger
- specify the sequence of statement execution for a given scenario
- create and modify functions and triggers in a given scenario