Database Deployment and Data Distribution

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

---

Overview/Description
recognize how to design, deploy and utilize database deployment and database distribution solutions

Target Audience
Developers who use Microsoft Office SQL Server 2005 and consultants providing consulting services for SQL Server 2005; individuals looking to pass the 70-441 PRO: Designing Database Solutions by Using Microsoft SQL Server 2005 certification exam and those individuals targeting toward the Microsoft certification: Microsoft Certified IT Professional (MCITP): Database Developer certification path.

Prerequisites
Three or more years database programming experience including expertise in troubleshooting triggers, queries, stored procedures, user-defined functions, and user-defined types, writing Transact-SQL queries, performing database performance optimization, designing and troubleshooting the data access layer of the application, designing databases, iImplementing databases at the physical level, and gathering business requirements.

Expected Duration (hours)
2.2

Lesson Objectives

Database Deployment and Data Distribution

recognize how to deploy a database from one instance of the server to another instance using various deployment techniques.

recognize how to design scripts for the deployment of a database and its objects.

recognize how to design SQL Server Agent jobs and define their schedules and alerts.

recognize how to set up database mail and send emails using database mail.

recognize how to use web services supported by SQL Server 2005 that utilize HTTP endpoints.

recognize how to build web services support by using HTTP endpoints for SQL Server 2005.

determine how to implement database deployment solutions and scripts, and how to design data distribution solutions.

Course Number:
256271_eng