Font size:

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.

Learning Objectives
  • 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
Register Now
Microsoft SQL Server 2012: Creating Functions and Triggers Online course
  • Course ID:
  • Duration:
    60 minutes
  • Price: