Live instructor-led training
Accelerated SQL Server Integration Services
- CMDBID 1115
- Course Code LSQLSSIS
- Duration 4 Days
Scroll
Course content
What you will learn
Overview
Accelerated SQL Server Integration Services is a practical training course for teams that need structured, instructor-led skills in Accelerated SQL Server Integration, Services Module, SSIS Overview.
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.
Audience
- 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.
Skills Gained
By completing the Accelerated SQL Server Integration Services LSQLSSIS course participants will gain practical knowledge, configuration skills, implementation techniques and best practice understanding relevant to real enterprise environments.
Prerequisites
- Basic experience in business intelligence solutions and SQL Server
- No prior experience with SQL Server SSIS is required
Outline
Module 1. SSIS Overview and Core Features
- Introduction to Business Intelligence
- Microsoft tools for BI
- Introduction to data integration
- SSIS features overview
- Lab 01: SSIS Overview and Core Features
Module 2. Data Warehousing
- Dimensional modeling
- Optimizing a dimensional database
- Data preparation for advanced analytics
- Lab 02: Preparing a DW
- Module 3. SSIS Control Flow Objects and Features
- What is Control Flow
- Control Flow Concepts
- Control Flow Objects
- Control Flow Features
- Lab 03: Using the Control Flow to Orchestrate SSIS Execution
Module 4. Extracting, Transforming and Loading data using SSIS Data Flows
- The SSIS Data Flow Task
- Data Flows and Data Paths
- Data Connections and Connection Managers
- Data Flow Components
- Lab 04: Using Data Flows to Perform Data Movements in SSIS
- Module 5. Working with Files, Importing and Exporting File Data
- Using SSIS to Automate File System Maintenance
- Extracting Data from Files
- Loading Data into Files
- Excel Considerations
- Lab 05: Working with Files in SSIS
Module 6. Optimizing Data Extraction and Data Loading
- Data Extraction Optimization Essentials
- Determining the Delta"
- Change Tracking
- Change Data Capture
- Data Loading Optimization Essentials
- Lab 06: Using Change Data Capture in SSIS Data Flows
Module 7. Data Quality and Cleasing
- Data quality
- Data profiling
- Data Quality Services
- Fuzzy matching
- Lab 07: Data Profiling and Cleansing
Module 8. Advanced Enterprise Information Management
- Script task and Script Component
- Text mining
- Advanced Analysis and SSIS
- Lab 08: Validating Data against Regular Expressions
Module 9. Dimension ETL with SSIS
- Dimension ETL Theory
- SQL Server Temporal Tables
- SSIS Slowly Changing Dimension Wizard
- Custom Dimension ETL
- Lab 09: Dimension ETL with SSIS
- Module 10. Fact ETL with SSIS
- Fact Table ETL Theory
- Data preparation for fact tables
- Advanced concepts
- Lab 10: Fact ETL with SSIS
Module 11. Project Deployment Model: Execution and Reporting
- Power Pivot
- Power Query
- Lab 11: Power Query
- Module 12. Processing SSAS Objects in SSIS
- SSAS tabular and multidimensional
- Processing methods in SSIS
- Dynamic processing and partition creation
- Lab 12: Analysis Services Processing
Module 13. Project Deployment
- Project Deployment Model
- Deployment to the SSISDB Catalog
- Administration, Security, Configuration
- Execution
- Monitoring
- The Master Package Concept
- Lab 13: SSIS Project Deployment, Configuration, Execution, and Monitoring
Module 14. Package Deployment
- Package Deployment Model
- Deployment to the SSIS package store
- Administration, Configuration, and Security
- Execution
- Monitoring and Logging
- Lab 14: SSIS Package Deployment, Configuration, Execution, and Monitoring
Module 15. Transactions and Restartability
- Using Breakpoints in SSDT
- Implementing Transactions in SSIS
- Using SQL Server Database Snapshots
- Restartability of SSIS Packages
- Responding to Events
- Lab 15: Using Transactions and Checkpoints in SSIS Packages
Module 16.Optimization and Scalability
- Leveraging SSIS and Transact-SQL
- Data Flow Engine Internals
- SSIS Optimization Techniques
- SSIS Performance Troubleshooting
- Lab 16: Optimizing SSIS Packages for Performance
Certification
Exam and certification details
This course may support a vendor exam, digital badge or professional certification depending on the selected delivery option. Delegates should confirm exam inclusion, voucher availability, prerequisites, pass mark and version before booking.
Official vendor training information: CourseMonster vendor-authorised training.
Continue your learning pathway: view all Microsoft SQL Server courses or compare related courses and follow-on options.
Talk to an expert
Thinking about Onsite?
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost-effective option. One-to-one training can be delivered too, at reasonable rates.
Submit an enquiry from any page on this site and let us know you are interested in the requirements box, or simply mention it when we contact you.
All $ prices are in USD unless it’s a NZ or AU date
SPVC = Self Paced Virtual Class
LVC = Live Virtual Class
Please note: All courses are available as Live Virtual Classes
Trusted by over 1/2 million students in 15 countries
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.
