SQL Server 2008 R2: Implementing Programming Objects
Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
In SQL Server 2008 R2 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 include stored procedures, functions, and triggers (based on either DML or DDL statements). SQL Server 2008 R2 provides integration with Common-runtime language (CLR). This enables a developer to create programming objects using any of the Microsoft .NET Framework languages and then deploy them within SQL Server using assemblies. This course demonstrates how to create user-defined functions, DML and DDL triggers, and stored procedures, as well as how to use the control of flow language in transactions and handle any errors that might arise within them using TRY...CATCH, RAISERROR, and @@ERROR. The course also demonstrates how to use CLR integration in SQL Server 2008 by deploying CLR code into SQL Server. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include
• IT generalists who work in environments in which SQL Server 2008 R2 is part of an overall solution
• IT professionals who manage systems that run SQL Server 2008 R2
• IT professionals who work with third-party applications that are built on SQL Server 2008 R2
• Developers who build applications that use SQL Server 2008 R2
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.