Private Onsite | 4 Days Classroom
Accelerated SQL Server 2016 Integration Services
Design, develop, deploy, and operate SQL Server Integration Services (SSIS) solutions.
Developed in-house by SolidQ, the Integration Services (SSIS) course focuses on developing and managing SSIS 2016 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS solutions—this involves ETL solutions (extraction, transformation, and loading) from source systems extractions, data integration, SSIS server administration and package execution.
Main Benefits
Create and develop new SSIS projects packages.
Apply SSIS to file and data management.
Loading SSAS dimensions and cubes.
Determine when to use projects mode versus.
Understand and apply ETL concepts in SSIS.
Administer SSIS for sever deployment and production execution.
Course Delivery Options
Private On Site
will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity.
4 Days Classroom.
The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.
Pre-requisites
Basic experience in business intelligence solutions and SQL Server
No prior experience with SQL Server SSIS is required
In this course you will learn how to create and develop new SSIS projects and package and determine when to use project mode versus, how to apply SSIS to file and data managemen, to understand and apply ETL Concepts in SSIS including dimensions and fact table ETL and loading SSAS dimension and cubes and how to administer SSIS for server deployment and production execution.
”He has this rare ability to present a complex matter in a very simple and easy to understand way. Loved him!”
Module 1. SSIS Overview and Core Features
Lab 01: SSIS Overview and Core Features
Module 2. Data Warehousing
Lab 02: Preparing a DW
Module 3. SSIS Control Flow Objects and Features
Lab 03: Using the Control Flow to Orchestrate SSIS Execution
Module 4. Extracting, Transforming and Loading data using SSIS Data Flows
Lab 04: Using Data Flows to Perform Data Movements in SSIS
Module 5. Working with Files, Importing and Exporting File Data
Lab 05: Working with Files in SSIS
Module 6. Optimizing Data Extraction and Data Loading
Lab 06: Using Change Data Capture in SSIS Data Flows
Module 7. Data Quality and Cleasing
Lab 07: Data Profiling and Cleansing
Module 8. Advanced Enterprise Information Management
Lab 08: Validating Data against Regular Expressions
Module 9. Dimension ETL with SSIS
Lab 09: Dimension ETL with SSIS
Module 10. Fact ETL with SSIS
Lab 10: Fact ETL with SSIS
Module 11. Project Deployment Model: Execution and Reporting
Lab 11: Power Query
Module 12. Processing SSAS Objects in SSIS
Lab 12: Analysis Services Processing
Module 13. Project Deployment
Lab 13: SSIS Project Deployment, Configuration, Execution, and Monitoring
Module 14. Package Deployment
Lab 14: SSIS Package Deployment, Configuration, Execution, and Monitoring
Module 15. Transactions and Restartability
Lab 15: Using Transactions and Checkpoints in SSIS Packages
Module 16.Optimization and Scalability
Lab 16: Optimizing SSIS Packages for Performance
Do you want more info about these courses?