Creating and Implementing Programming Objects in SQL Server 2008
This course is included in our On-demand training solution.
In SQL Server 2008 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 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 is part of an overall solution IT professionals who manage systems that run SQL Server 2008 IT professionals who work with third-party applications that are built on SQL Server 2008 Developers who build applications that use SQL Server 2008
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008 or two to three years of experience using a previous version of SQL Server.
Creating and Managing User-Defined Functions
- recognize key characteristics of user-defined functions
- recognize how to create and manage user-defined functions
Creating and Managing Triggers in SQL Server 2008
- recognize key characteristics of triggers
- recognize how to create and manage triggers
Creating Stored Procedures in SQL Server 2008
- recognize key characteristics of stored procedures
- recognize how to create stored procedures
Transaction Control in SQL Server 2008
- recognize how transaction control works in SQL Server 2008
Using Concurrency Control and Handling Errors
- recognize how concurrency control works
- recognize how to implement error handling
Creating CLR Objects in SQL Server 2008
- recognize key characteristics of CLR
- recognize how to create CLR objects
Creating and Managing Programming Objects