Become an SQL Developer: Learn SSIS | SSIS tutorial

SSIS is SQL Server Integration Services, a part of Microsoft SQL Server database software that allows you to perform data migration. SSIS is a platform that includes an ETL tool to integrate applications for smooth data transferring and workflow applications.
This course is designed to give you a deep understanding of SSIS and its concepts to become a successful SQL Developer. From this course, you’ll understand

• The introductory-level basics of SSIS, including control and data flows, sources and destinations
• How to use SSIS to interact with common resources in Azure like Azure Blob storage and Azure SQL Database
• How to configure your SSIS packages for zero-touch deployment and deploy, schedule and administer SSIS in production
• Tips and tricks on how to properly set the Buffer size and engine threads, as well as go over how threading in SSIS works
• Common mistakes that are made when picking the wrong source or destination driver and some helpful components to reduce the number of operations and get the packages on the right track
• Changes and features in SSIS 2012
• Fundamentals of SSIS, all the basics to get started
• Various techniques to take advantage of the new Project Deployment model in SSIS 2012!
• Load type 1 and type 2 dimensions, fact tables and create a master package framework to control it all
• Explore the built-in tools such as dimension wizard and how to replace the functionality with much faster components
• How to handle special business scenarios, such as late arriving dimension members, in a variety of ways. After loading your warehouse and learn how to consume this data in SSAS
• Basic SSIS Logging and Notification as a part of every package
• Best practices for developing packages that perform well and scale as data demands grow
• Different design options that are available for maintaining dimensions in a traditional data warehouse
• Some of the new features in SQL Server 2012 SSIS and how that will improve on development as well as look into the enhancements made to existing features from the previous versions
• Difference between the former package deployment and new project deployment models, variables vs. parameters, deployment to the new SSIS catalog and how to configure environments
• How to add flexibility to consume the contents of any folder, regardless of file formatting or type
• How to use SSIS to connect to a variety of different data sources and destinations such as Excel, SQL Server, Oracle and Flat Files
• DOs and DON’Ts of the SSIS ETL world
• Use SSIS to do a simple data dump, keep tables in sync, do incremental loads, deal with very large data sets that may not be able to handle all in memory, and bring multiple sources into one destination
• Types of transforms (partially blocking vs fully blocking), which transforms are right for which jobs and which transforms to avoid getting the data moved quickly and efficiently
• Why we need scripting, basics of the script task and script component, and commonly used C# scripts
• How to set up SSIS in Azure, move your existing SSIS packages, and execute packages from the cloud
• What is MDS (Master Data Services) and its core capabilities and how MDS can be empowered with Profisee to deliver an Enterprise MDM solution
• How to deploy SSIS packages from Development environment into Production, the three different target location options and how to dynamically change data source and destination connection strings and other object properties using SSIS Package Configurations
• Explore the different SSIS package configuration options and provide best practices for production environment deployments
• Explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges
• How to use the Data Profiling Task, Script Transform, and Fuzzy logic and also learn how to use Data Quality Services (DQS) and Master Data Services (MDS) to normalize and cleanse your data
• How to use the Data Profiling Task, Script Transform and Fuzzy logic, new components built into SQL Server Denali for data cleansing
• How to create your own custom SSIS data flow transformation and how to read input data, process the input data and send data to outputs
• How to create your first control flow task, discover how to create a reusable component that can be used to send HTML emails within SSIS
• The best ways to implement an SSIS Framework, why is it important to implement a framework? What roles do parameters play? How can a BI Xpress help ease the implementation process?
• Build a robust enterprise ETL Framework while leveraging the architectural enhancements available in SQL Server 2012
• Topics include auditing, logging, designing for fault tolerance and recoverability, handling orchestration, parallelism and finally scheduling in a dynamic and configurable manner