Creating and Implementing Programming Objects in SQL Server 2008

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

Prerequisite
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.

Expected Duration
120 minutes

Description
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.

Objective

Creating and Managing Functions and Triggers

  • recognize key characteristics of user-defined functions
  • recognize how to create and manage user-defined functions
  • recognize key characteristics of triggers
  • recognize how to create and manage triggers
  • Creating Stored Procedures and Error Handling

  • recognize key characteristics of stored procedures
  • recognize how to create stored procedures
  • recognize how transaction control works in SQL Server 2008
  • recognize how concurrency control works
  • recognize how to implement error handling
  • Creating and Managing CLR Objects

  • recognize key characteristics of CLR
  • recognize how to create CLR objects
  • create and manage programming objects in SQL Server 2008
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.