Course 2943 Updating Your Data Integration Skills to Microsoft SQL Server 2005 Integration Services
In this course you administer and program SQL Server 2005 Analysis Services. In addition, you design and deploy a Unified Dimensional Model as well as work with data mining solutions. This course is intended for architects, database developers, database administrators, and business intelligence developers, who are experienced in Microsoft SQL Server. This course also helps prepare you for certification exam 70-445.
Plus, Course 2943 Updating Your Data Integration Skills to Microsoft SQL Server 2005 Integration Services E-Learning lets you learn at your own pace. Work online or download courses to your computer to study when you are not connected to the Internet.
Our Price: $99 Add to Cart Purchase Course 2943 Updating Your Data Integration Skills to Microsoft SQL Server 2005 Integration Services to save on Microsoft SQL Server E-learning
Title: Course 2943 Updating Your Data Integration Skills to Microsoft SQL Server 2005 Integration Services
Course Type: Self-paced Course
Available Offline: Yes
Estimated Time of Completion: 6 Hours
Language: English
Course 2943 Updating Your Data Integration Skills to Microsoft SQL Server 2005 Integration Services Objectives:
At the end of the course, students will be able to:Understand the features and the core concepts of the SSIS architecture. Design SSIS packages by using Business Intelligence (BI) Development Studio. Understand the features of SSIS that help in building high-performance data integration and workflow solutions. Understand the features that extend the functionality of SSIS.
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 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 GS Micro JAWS from Freedom Scientific MSAA enabled
Course 2943 Updating Your Data Integration Skills to Microsoft SQL Server 2005 Integration Services course contents
Course Overview
Module Introduction
How to Use This Course
Course Information
Exploring SSIS Architecture and Core Concepts
Module Introduction
SSIS Architecture
Lesson Introduction
An Overview of SSIS
The Evolution from DTS to SSIS
The SSIS Development Environment
The SSIS Runtime
Self Test
SSIS Core Concepts
Lesson Introduction
Containers, Tasks, and Precedence Constraints
Data Flow Tasks
Connectivity
Variables and Package Configurations
Event Handlers and Log Providers
Self Test
Module Summary
Designing and Debugging SSIS Packages
Module Introduction
Creating Package Control Flow
Lesson Introduction
The SSIS Package Designer
An Overview of Control Flow
Adding and Configuring Containers
Adding and Configuring Tasks
Using Precedence Constraints
Self Test
Creating Package Data Flow
Lesson Introduction
An Overview of Data Flow
Adding Data Sources
Adding Transformations
Adding Destinations
Connecting Data Flow Components
Self Test
Designing for Scalability and Performance
Lesson Introduction
The OVAL Design Strategy
Operations and Volume
Application and Location
Performance Monitoring of SSIS Packages
Self Test
Debugging SSIS Packages
Lesson Introduction
Executing a Package
Setting Breakpoints
Adding a Data Viewer
Monitoring Data Flow Progress
Self Test
Lab: Creating and Debugging a Package
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Rich Functionality in SSIS
Module Introduction
Configuring and Deploying SSIS Packages
Lesson Introduction
An Overview of Package Deployment
Creating Package Configurations
Deploying a Package
Self Test
Enhancing ETL Operations
Lesson Introduction
Adding Logging to a Package
Parallel Operations
Sequence Containers
Lookup Caching
Using Checkpoints to Restart After Failure
Self Test
Working with Transformations
Lesson Introduction
Derived Column Transformation
Slowly Changing Dimension Transformation
Fuzzy Lookup Transformation
Fuzzy Grouping Transformation
Data Mining Query Transformation
Self Test
Lab: Configuring and Deploying a Package
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Extensibility
Module Introduction
Programmability
Lesson Introduction
Programming SSIS Tasks and Packages
Using the Script Task
Using the Script Component Transformation
Self Test
Beyond ETL
Lesson Introduction
Non-Traditional Data Sources
Alternative Transformations
Self Test
Lab: Transforming an RSS Feed
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary
Our Price: $99 Add to Cart
Frequently Asked Questions on Microsoft E-Learning
Question: What is Microsoft E-learning?
Answer: Official Microsoft E-Learning products provide a thorough learning experience by incorporating features designed to improve your product proficiency and boost your productivity. Assessments, hands-on virtual labs, expert advice, and an interactive, non-linear approach all contribute to make Microsoft E-Learning an engaging and flexible learning experience. Regardless of your type of organization, skill levels, or learning styles; Microsoft E-Learning can provide access to just the right software training anytime and anywhere - for IT Professional, developers, and home and office workers. Microsoft E-Learning content is created by Microsoft experts, so the training comes straight from the source.
Question: How Long and how I will have access to purchased Microsoft E-Learning?
Answer: When you purchase any Microsoft Elearning course from us, we will send product key to activate your Microsoft E-learning subscription directly on Microsoft official website. You will need internet access to attend your course. Subscription is for 365 days from your activation date.
Question: How we are able to sell Microsoft E-Learning so cheap?
Answer: We are an Authorized reseller for Microsoft E-Learning Solutions. As a reseller we have special pricing from Microsoft E-learning. You attend Microsoft E-Learning course directly at official Microsoft Elearning website. We only provide you activation key to activate your Microsoft elearning course. Only difference is you save money when you purchase from us.
Question: Can I try one of the course before I purchase?
Answer: Absolutely, There are plenty of courses available to try Free of cost and of course no obligation to purchase. Click here for complete Free Microsoft E-Learning Courses.
Question: Can I get Refund for my Microsoft Elearning purchase?
Answer: Sorry NO! All of our orders are FINAL. There is NO RETURN, NO REFUND, NO EXCHANGE. Once order is processed, everything is FINAL. So If you have any questions, please contact customer service at
elearning@solartechlearning.com before you place an order.
| Our Price: $99 | Add to Cart |
Click here for complete Microsoft SQL Server - E-learning Solutions.
