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