Description

Summary: In this online course, you extend your Oracle skills to integrate SQL Server 2005 with Oracle databases by using linked servers, replication, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

Audience: IT Pro
Available Offline: Yes
Subscription: 12 months

Course Type: Self-paced Course
Estimated Time of Completion: 2 Hours
Language: English

Description:
In this online course, you extend your Oracle skills to integrate SQL Server 2005 with Oracle databases by using linked servers, replication, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

Course Objectives

At the end of the course, students will be able to:

• Use SQL Server 2005 to connect to external data sources.
• Implement extract, transform, and load (ETL) through SSIS.
• Build an online analytical processing (OLAP) solution by using SSAS.
• Examine data stored in a data warehouse.
• Describe the reporting facilities offered by SSRS.

Technical 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
• Macromedia Flash 7.0 or higher (1MB disk space needed to install)
• 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)

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