Pick 1 & Get 1 Free + 10% additional off! Hurry Up! - Get Details
Learn about SQL Server Integration Services in detail and gain proficiency in all its aspects

Implementing SQL 2016 Data Warehouse (SSIS) Training & Certification Course

Learn about SQL Server Integration Services in detail and gain proficiency in all its aspects

     209 Learners       Add to wishlist

Play Video

Instructor-Led Online Training

  • 18 Hrs Training
  • Certified & Experienced Trainer
  • Lifetime E-Learning Access
  • Training Session Videos
$ 350
ENROLL NOW
Training Schedule
Start Date End Date No. of Hrs Time (IST) Day  
17 Nov 2018 02 Dec 2018 18 06:00 PM - 09:00 PM Sat, Sun
24 Nov 2018 09 Dec 2018 18 06:00 PM - 09:00 PM Sat, Sun
01 Dec 2018 16 Dec 2018 18 06:00 PM - 09:00 PM Sat, Sun

Schedule does not suit you, contact us now!    |    Want to take one-on-one training, contact us now!

Course Overview

Implementing SQL 2016 Data Warehouse (SSIS) training and certification course will familiarize the learners with the SQL Server Data tools, features, workflow applications, ETL, and many other important aspects. The course will provide you with in-depth knowledge of developing packages using different tasks and providing ETL solutions based on varied requirements. It will equip you with the skills required to efficiently work with SQL Server Integration Services for business intelligence. It will also make you proficient in gathering data from flat files, XML, and relational data sources.

At the completion of this course, you will be able to:

  • Acknowledge the significance of the data integration process
  • Comprehend the components of a data warehousing solution
  • Implement a logical and physical design to create a data warehouse
  • Connect to a particular data source with Connection Managers
  • Create dynamic packages using parameters and variables
  • Construct SSIS packages and package configuration
  • Implement Business Intelligence and its common scenarios
  • Perform basic ETL (i.e. Extract, Transform, Load) tasks at your work
  • Automate SSIS object model; and do even more tasks…

Course Contents

Course ContentDetailed Course Topics
  • Introduction to Data Warehousing
  • Planning Data Warehouse Infrastructure
  • Designing and Implementing a Data Warehouse
  • Columnstore Indexes
  • Implementing an Azure SQL Data Warehouse
  • Creating an ETL Solution
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing a Data Extraction Solution
  • Enforcing Data Quality
  • Master Data Services
  • Extending SQL Server Integration Services
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse

Target Audience

  • Database professionals
  • Data warehousing professionals
  • BI developers and BI solutions professionals
  • Software and ETL developers
  • Students with basic knowledge of SQL, seeking a career in Business Intelligence

Certification

After successfully completing the Implementing SQL 2016 Data Warehouse (SSIS) Training & Certification Course, the candidate will receive a training completion certificate from Multisoft Virtual Academy.

Send us a Query

Capcha

I agree to be contacted via e-mail.

Related Courses

Combo Offers

Implementing SQL 2016 Data Warehouse (SSIS) Training & Certification Course
Rated 5/5 based on 209 votes 209 reviews

Get in Touch

Follow Us

We Accept Online Payments

Online Registration

Subscribe to our Newsletter

Find us on

Online Registration

Contact Us

Capcha

I agree to be contacted via e-mail.

Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP and SP are registered marks of the Project Management Institute, Inc.
  • PRINCE2® is a registered trade mark of AXELOS Limited
  • ITIL® is a registered trade mark of AXELOS Limited
  • MSP® is a registered trade mark of AXELOS Limited
  • The Swirl logoTM is a trade mark of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.