Mastering the Fundamentals of SSIS
What you'll learn
- At the conclusion of this course you'll understand how the SSIS works at a very high level.
- You'll be able to craft high performing SSIS packages.
- You'll understand all the various components of the SSIS Designer.
Requirements
- You'll need to download and install SQL Server 2012, 2014 or 2016. The Express Edition will do.
- You'll need to download and install Visual Studio 2015. Again, the express edition will do.
- You'll need a copy of the AdventureWorks database.
Description
SQL Server Integration Services (SSIS) is a tool that we use to perform ETL operations; i.e. extract, transform and load data.
We will also sort out the various versions and name changes. For example, in SQL Server 2014 Microsoft decided to no longer include SQL Server Data Tools (Another Visual Studio shell for SSIS) as part of the normal install. This confused everyone. To make matters worse, you now download and install different tools depending on what you have already.
This course will provide you with a solid foundation of SQL Server Integration Services. We will cover everything from the designer to crafting high quality packages.
While ETL processing is common in data warehousing (DW) applications, SSIS is by no means limited to just Data warehousing approaches.
For example, when you create a Maintenance Plan using SQL Server Management Studio (SSMS) an SSIS package is created.
You'll learn all the vernacular associated with SSIS as well as all the core components.
We'll cover the package in detail. The package is the unit of work that is retrieved, executed, and saved.
At a high level, SSIS provides the ability to retrieve data from just about any source, perform transformations on data, covert data from one type to another, load data into just about any source and define complex workflows that move disparate data throughout any organization.
In this course you'll learn how to use SSIS to develop data integration, migration and consolation packages that you as a DBA or developer can use in any organization that has data.
In the course we will cover the integration with other SQL Server products like SSMS. SQL Server Management Studio provides the Integration Services service that you use to manage packages, monitor running packages, and determine impact and data lineage for Integration Services and SQL Server objects.
I look forward to seeing you in the course.
Join Now!!!!!
Who this course is for:
- This is a mid level course aimed at those who have a working foundation of SQL Server.
- This is not an entry level course.
- Everything you need to take the course will be included. There are no items you'll have to purchase.
Course content
- Preview01:17
- Preview01:23
- 02:13Course Downloads
- 00:56Where did BIDS or SSDT go?
- 04:23Installing SSDT
- 03:08Installing Adventureworks Training Database
- Preview02:15
- Preview01:02
- Preview04:26
- 01:52The Project and the Solution
- 08:53Our Very First SSIS Package. Learning what tasks do.
- 00:23Integration Services Service
- 01:18Summary
- 00:44Terminology
- 10 questionsQuiz
Instructor
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Over the last five years I've transitioned to the exciting world of applied machine learning. I'm excited to show you what I've learned and help you move into one of the single most important fields in this space.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Personal
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.