Course 3305: Modeling Database Dependencies with Microsoft SQL Server 2005

Introduction In this 2-hour premium course you will learn how to handle local and remote dependencies within your database design. In the lab you will configure cross-database access and linked servers.

Using these skills will allow you to design databases that can access both local and remote resources.

This course will also prepare you for exam 70-441 PRO: Designing Database Solutions by Using Microsoft® SQL Server™ 2005. Objectives At the end of the course, students will be able to:

• Model Local Database Dependencies
  • Design Cross-Database Access
  • Use Extended Stored Procedures
  • Access COM Components
• Model Remote Database Dependencies
  • Use Linked Servers
  • Model Data Distribution
  • Model Database Availability

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Modeling Database Dependencies Module Introduction Modeling Local Database Dependencies Lesson Introduction Guidelines for Modeling Cross-Database Access Guidelines for Using Extended Stored Procedures Guidelines for Specifying COM Components in a Database Design Self Test Modeling Remote Database Dependencies Lesson Introduction Guidelines for Using Linked Servers Using Linked Servers Guidelines for Modeling Data Distribution Guidelines for Modeling Database Availability Self Test Lab: Modeling Database Dependencies Lesson Introduction Scenario Exercises Lab Review Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled