Creating and Implementing Programming Objects in SQL Server 2008


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/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.

Target Audience
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

Prerequisites
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 (hours)
2.0

Lesson Objectives

Creating and Implementing Programming Objects in SQL Server 2008

  • 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
  • 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
  • recognize key characteristics of CLR
  • recognize how to create CLR objects
  • create and manage programming objects in SQL Server 2008
  • Course Number:
    md_msdd_a05_it_enus