Design, develop, deploy, and operate SQL Server Integration Services (SSIS) solutions.
Developed in-house by Lucient, 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.
What Will I Learn?
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.
Module 1. SSIS Overview and Core Features
Module 2. Data Warehousing
Module 4. Extracting, Transforming and Loading data using SSIS Data Flows
Module 6. Optimizing Data Extraction and Data Loading
Module 7. Data Quality and Cleasing
Module 8. Advanced Enterprise Information Management
Module 9. Dimension ETL with SSIS
Module 11. Project Deployment Model: Execution and Reporting
Module 13. Project Deployment
Module 14. Package Deployment
Module 15. Transactions and Restartability
Module 16.Optimization and Scalability
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.