SQL Server 2008 R2: Messaging, Full-Text Search, Scripts, and Track Changes
This course is included in our On-demand training solution.
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.
Service Broker Components in SQL Server 2008 R2
Creating the Service Broker Components
Tracking Data Changes in SQL Server 2008 R2
Implementing Full-Text Search in SQL Server 2008 R2
Using PowerShell to Manage SQL Server 2008 R2
Using Database Mail in SQL Server 2008 R2
Using SQL Server 2008 R2 Components