SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes


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


Overview/Description
SQL Server 2008 R2 provides many components to ensure that database developers can perform many tasks within the database without having to create custom applications. SQL Server's Service Broker component allows developers to create applications that can work with other SQL Server components to complete a specific task by communicating using messages to relay the task information within the instance or between instances of SQL Server 2008 R2. SQL Server 2008 R2 also offers a way for developers to track changes within the database using either change tracking or change data capture. SQL Server's full-text search component can be implemented to ensure that specific data is returned based on search words and phrases. PowerShell has been integrated into SQL Server and offers cmdlets to perform actions on database objects using methods within SQL Server Management Object (SMO) models, and to run scripts to perform tasks within SQL Server. Developers can also use Database Mail to send messages to mail accounts within a profile. This course demonstrates how to implement Server Broker, change tracking, full-text search, and Database Mail. It also demonstrates how to invoke and use PowerShell to run scripts and perform actions on objects. 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 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

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

Expected Duration (hours)
2.5

Lesson Objectives

SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes

  • recognize how Service Broker is used
  • recognize how to create Service Broker objects
  • recognize how to create an application
  • recognize how to use change data capture in SQL Server 2008 R2
  • recognize how to perform change tracking in SQL Server 2008 R2
  • recognize how to perform a full-text search
  • recognize how to use the full-text predicates and functions
  • recognize how to use PowerShell in SQL Server 2008 R2
  • recognize how to use Database Mail in SQL Server 2008 R2
  • use Service Broker
  • use change tracking
  • use PowerShell
  • set up and use Database Mail
  • Course Number:
    md_msdr_a07_it_enus