Skip to main content

Implementing ETL with SQL Server Integration Services


About this course

Microsoft SQL Server Integration Services (SSIS) features graphical tools and wizards for:

  • building and debugging packages
  • tasks for performing workflow functions
  • executing SQL statements
  • data sources and destinations for extracting and loading data
  • transformations for cleaning, aggregating, merging, and copying data

In this computer science course, you'll extract data from a wide variety of data sources, such as files and relational data sources, perform data integration and transformation solutions, and load data into single or multiple destinations. You will solve complex business problems using best practices and troubleshooting techniques.

What you'll learn

You’ll learn design principles and solutions for:

  • Deciding on full or incremental loading
  • Isolating ETL data
  • Creating an ETL script
  • ETL abstraction layers
  • The design environment
  • Control flows
  • Data sources
  • Data transformations
  • Data destinations
  • Precedence constraints
  • Connection managers
  • Execute SQL tasks
  • Progress/execution results
  • Resetting destination database
  • Data flows
  • Data flow paths
  • Error output paths
  • Configuring data sources and destinations
  • Executing SSIS packages
  • Deploying SSIS packages

Meet the instructors

Randal Root

Randal Root

Lecturer University of Washington

Randal is a senior executive consultant specializing in .NET Programming and SQL Server BI solutions. Randal has worked in the industry as a solution designer, network administrator, DBA, and programmer since the 1980s. His passion is to impart knowledge. For the last 18 years, he has provided IT training for businesses and schools; including Microsoft, the University of Washington, and various community colleges in the Seattle area. Randal is an author of two books: A Tester's Guide to .NET Programming and Pro SQL Server 2012 BI Solutions. Randal has achieved several Microsoft professional certifications include MCSE, MCP+I, MCTS, MCDBA, and MCAD.

Cari Mason

Cari Mason

Content Developer Microsoft

Cari is a content developer at Microsoft. Her current role involves developing, producing and delivering Data Analytics courseware. Her experience includes developing content for IT Professionals and developers with a major focus on Business Intelligence Solutions. She has worked with the University of Washington’s continuing education programs, assisting with C# programming, web development, and BI courses. Her passion is in education and diversity, with a special interest in Autism support and career growth. She is an author of Pro SQL Server 2012 BI Solutions.

Joey Chemis

Joey Chemis

Data Scientist and Software Engineer Microsoft

Joey Chemis is a Data Scientist and Software Engineer at Microsoft with a focus on predictive analytics. His work involves forecasting projects that enable him to assist First Party Devices and the Commercial Team in demand planning, while using development tools such as R, Power BI, Azure Machine Learning, SQL Server, and Excel. His passion is mathematics and statistics and the heavy role they play in the field of Data Science. Prior to Microsoft, he worked as a Data Scientist at REI. Joey has completed the P-Probability requirement and is working on achieving the designation Associate of the Society of Actuaries (ASA).

  1. Course Number

  2. Classes Start

  3. Classes End

  4. Estimated Effort

    Total 12 to 24 hours