SQLBIGURU

Click here to redeem your voucher code Redeem Now

TRENDING BI TOOL

If you ever felt like learning SQL Server Integration Services(SSIS) then this is your chance. This is an extensive course that will leave you filled up with all the details working with Business Intelligence (BI) tool. It will be the golden ticket to your success in this industry. This course will cover everything you need to know about SSIS and how to apply it in your career. You will get the chance to learn simple beginner lessons like where to find different tools, and escalating from there to the level of details of various issues that you might face when designing your packages and how to overcome those issues. By the end of this course you will master data migration for different environments. This course also includes the process of cleansing data and how to get the end result after applying different transformations. It will also give some real life issues faced in many companies and what salary wages to expect when you get into this field.

From this course you will be able to know concepts like

  • How to create an Integration Services Project
  • How to create Integration Services Tasks
  • How to write data to a SQL Server database
  • How to create a Foreach Loop and map Variables
  • How to change a Flat File Connection with Expressions
  • An overview of some Change Data Capture(CDC) database objects
  • An overview of the basic SQL Server Data Tools' features
  • How to create connections to and from an Integration Services Package
  • How to execute a package from SQL Server Data Tools
  • How to control Data Flow for multiple Flat Files
  • How to change command-line application arguments using Expressions
  • How to prepare data for CDC and perform Incremental loading