Course 5147: Building Interoperable Solutions with Microsoft SQL Server 2005 and Oracle Databases

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

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Building Interoperable Solutions with Microsoft SQL Server 2005 and Oracle Databases Module Introduction Connecting SQL Server 2005 to Oracle Lesson Introduction Methods for Integrating SQL Server 2005 and Oracle What Are Distributed Queries? What Is Replication? SQL Server Replication Architecture How Snapshot Replication Works in Oracle Databases How Transactional Replication Works in Oracle Databases Self Test Implementing ETL Through SSIS Lesson Introduction What Is SSIS? The SSIS Package Designer Interface Data Flow In SSIS Data Transformation in SSIS Control Flow in SSIS SSIS Package Execution Self Test Building Analytical Solutions by Using SSAS Lesson Introduction OLAP in SQL Server 2005 Analysis Services Design Considerations for Dimensional Schemas What Are Measures and Measure Groups? What Are Dimensions? Cube Storage Types Data Mining in SQL Server 2005 Self Test Analyzing Data Lesson Introduction OLAP Cube Querying Operations User OLAP Reporting Tools and Applications Cube Driven Excel Analysis What Are KPIs? Self Test Creating Reports by Using SSRS Lesson Introduction Architecture of Reporting Services Reporting Services Tools The Process for Creating Reports in SSRS Report Deployment in SSRS Report Subscriptions in SSRS Report Models in SSRS Self Test Lab: Building Interoperable Solutions with Microsoft SQL Server 2005 and Oracle Lesson Introduction Scenario Exercise Information Launch the Lab 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