2795A DESIGNING AN ETL SOLUTION ARCHITECTURE USING MICROSOFT SQL SERVER 2005 INTEGRATION SERVICES
| About this Course
Elements of this syllabus are person to change.
The determine of this 2-day instructor-led instruction is to inform Business Intelligence (BI) professionals employed in project environments to organisation an extract, transform, and alluviation (ETL) resolution that supports their BI solution. Students power see how to organisation an ETL solution, and specifically how to organisation and compel a SQL Server Integration Services (SSIS) supported ETL solution. They power also see how to monitor, optimize, and deploy an SSIS solution.
The instruction focuses on the thinking and organisation aspects of an ETL resolution and does not inform students how to create SSIS packages or how to ingest the utilization tools provided with SQL Server 2005.
|
| Audience Profile
This instruction is witting for old Business Intelligence (BI) professionals. The direct students for this instruction already hit undergo of using the SQL Server 2005 tools to compel ETL functionality, but requirement to amend their discernment of organisation principles and prizewinning practices when planning, implementing, and deploying an ETL solution.
|
| At Course Completion
After completing this course, students power be healthy to:
|
Course OutlineModule 1: Planning for ETL
In this module, Students power see how to organisation the artefact in which accumulation power be transferred and unreal in an ETL solution.
Lessons
-
Identifying Data Sources and Destinations
-
Evaluating Source Data
-
Identifying Staging Requirements
Lab : Planning an ETL Solution
- Identifying ETL Requirements
- Examining Source Data
After completing this module, students power be healthy to:
- Plan accumulation admittance and alluviation operations.
- Evaluate maker data.
- Design the ETL creation environment.
Module 2: Planning an SSIS Solution
In this module, students power see how to organisation an SSIS-based ETL solution. Specifically, they power see how to organisation SSIS packages, how to organisation an trenchant collection utilization process, and how to organisation the curb line within the packages.
Lessons
-
Planning Packages
-
Planning Package Development
-
Designing Package Control Flow
Lab : Implementing SSIS Packages
- Designing an SSIS Solution
- Creating a Package Template
- Implementing SSIS Packages
After completing this module, students power be healthy to:
- Plan SSIS packages.
- Plan collection development.
- Design collection curb flow.
Module 3: Designing Data Flow
In this module, students power see how to organisation accumulation flows that extract, transform, and alluviation data. They power also see most factors to study when employed with tardily dynamical dimensions (SCDs) and when implementing bespoken SCD transformations.
Lessons
-
Understanding Data Flow
-
Designing Data Flow Operations
-
Handling Data Changes
Lab : Implementing Data Flow
- Designing Data Flow
- Implementing Data Flow
After completing this module, students power be healthy to:
- Describe how accumulation flows impact in SSIS.
- Design accumulation line operations
- Design accumulation flows for updated data.
Module 4: Logging, Error Handling, and Reliability
In this module, students power see how to combine logging, nonachievement handling, and reliability into your SSIS collection designs. The power covers accepted logging, bespoken logging, and index reporting. The power also teaches students how to compel nonachievement direction and how to appendage intense data. Finally, the power shows students how to compel a dealings strategy, ingest checkpoints, and appendage restarts and rollbacks.
Lessons
-
Logging ETL Operations
-
Handling Errors in SSIS
-
Implementing Reliable ETL Processes with SSIS
Lab : Implementing Reliable Packages
- Implementing Logging
- Implementing Error Handling
- Implementing Transactions and Checkpoints
After completing this module, students power be healthy to:
- Design and compel logging in an SSIS package.
- Design and compel nonachievement direction in an SSIS package.
- Design and compel reliability in an SSIS package.
Module 5: Optimizing an SSIS Solution
In this power students power see how to guardian and behave SSIS performance. They power also see how to scale-out SSIS packages
Lessons
-
Monitoring SSIS Performance
-
Optimizing SSIS Packages
-
Scaling Out SSIS Packages
Lab : Optimizing Packages
- Monitoring SSIS
- Optimizing an SSIS Package
After completing this module, students power be healthy to:
- Monitor SSIS packages.
- Optimize SSIS packages.
- Design scale-out solutions for SSIS packages.
Module 6: Deploying and Operating an SSIS Solution
This power describes considerations for deploying an SSIS resolution into a creation environment. It also discusses whatever of the issues attendant to dealings and direction that you staleness study when thinking an SSIS solution.
Lessons
-
Deploying SSIS Packages
-
Operating an SSIS Solution
Lab : Deploying and Managing Packages
- Deploying an SSIS Solution
- Backing Up an SSIS Package
After completing this module, students power be healthy to:
- Deploy an SSIS solution.
- Operate an SSIS Solution.
D0wn10ad
http://www.easy-share.com/1905141941/ebook_Udovice2795A.rar
http://www.uploading.com/files/KYJOQQHN/ebook_Udovice2795A.rar.html
http://hotfile.com/dl/2327994/dfd2cb5/ebook_Udovice2795A.rar.html
http://deleted.com/files/231870834/ebook_Udovice2795A.rar
http://www.enterupload.com/uz47yfjcl6j5/ebook_Udovice2795A.rar.html
Password default: netbks.com
No Comments
No comments yet.
RSS feed for comments on this post.
Sorry - comments for this post are closed.