Microsoft SQL Server Integration Services (SSIS) Essentials Computer Based Training - CBT
Microsoft SQL Server Integration Services (SSIS) Essentials Computer Based Training - CBT How This Course Is Organised The Microsoft SQL Server Integration Services - SSIS Fundamentals Course provides hands-on step-by-step instructions on how to perform a variety of Data Integration tasks for activities based on real-life work scenarios. In this course, you will learn how to implement a data warehouse platform to support a business intelligence (BI) solution using Extract, transform and load in a SSIS to environment. In the course, you will learn to develop, deploy, and manage Integration Services packages. The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment. Audience Business Intelligence Developer Data Warehouse Administrator Data Warehouse Analyst Data Warehouse Developer Technical Administrator Prerequisites Experience navigating the Microsoft Windows Server environment Experience with Microsoft SQL Server Objectives Understanding SQL-Server Integration Services and its tools Create an Integration Services package Implement control flow in an Integration Services package Implement data flow in an Integration Services package Implement logging in an Integration Services package Debug and implement error handling in an Integration Services package Implement checkpoints and transactions in an Integration Services package Deploy an Integration Services package Manage and secure an Integration Services package Course Outline Overview Course Scenario Understanding ETL and Data Integration Platforms ETL Framework and Components The Evolution of ETL Code Generators versus Engines Database-Centric ETL Data Integration Platforms ETL versus EAI Understanding the Data Integration Tool Market Functional Capabilities of Data Integration Tools Microsoft SSIS Value Proposition Traditional Approach to Integration and ETL The SSIS Approach to Integration and ETL Introduction to ETL Development The Planning and Design Thread The Data Flow Thread Data Delivery Thread Introduction to SQL Server Integration Services Overview of SQL Server Integration Services Using Integration Services Tools Using the Import and Export Wizard Running an Integration Services Package Import Data Using the Import and Export Wizard Managing Packages Developing Integration Services Solutions Creating an Integration Services Project Implementing a Package Building and Running an Integration Services package Implementing Control Flow Control Flow Tasks Control Flow Precedent Constraints Control Flow Containers Implementing Data Flow Data Flow Sources and Destinations Basic Data Flow Transformations Advanced Data Flow Transformations Data Flow Paths Implementing Logging Overview of Integration Services Logging Enabling and Configuring Logging Debugging and Error Handling Debugging a Package Implementing Error Handling Implementing Checkpoints and Transactions Implementing Checkpoints Implementing Transactions Configuring and Deploying Packages Package Configurations Preparing and Deploying Packages Managing and Securing Packages Managing Packages Securing Packages What is Computer Based Training - CBT? Computer Based Training - CBT's are usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's CBT Titles do NOT have voice.. Generally, CBT's tend to be more expensive. Our CBT Titles are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. All CBT and Training Guide Learning formats are delivered with FULL LICENCE KEY. Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods. CBT's not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension. FACT: · Material retention with CBT's are 45% better than with conventional training method · Your learning curve with CBT is % less than conventional method · The cost of CBT training is 75% less than Classroom training · CBT’S are self pacing and Interactive · CBT’S simulate the actual software being studied so there is no need to have the actual software installed Ad ID: Delivery Service Consumer Credit