ETL Developer Training

(Live Instructor-Led SSIS 2014 Training)

ETL Developer Training

Your success is our #1 priority

At SQLOPS, our #1 priority is your success. If this is your first time learning ETL, this course will enable you to become an ETL Developer. ETL developers are high in demand in the job market. If you are already an ETL developer, DBA, or an Engineer, this course helps enhance and advance your knowledge of ETL processes using SQL Server Integration Services 2014 and helps you become stronger as a developer and enables you to excel in your career.

ETL Developer Training

This course teaches you on how to use SQL Server 2014 Integration Services to Build High Performance Data Integration Solutions. It covers all aspects of ETL Development, including creating SSIS Package, using Control Flow, Data Flow, Tasks, Dynamic SSIS Packages, Common ETL scenarios and its Implementation, Configuring, Deploying and Troubleshooting SQL Server Integration Packages using SQL Server 2014.

ETL Developer Training by SQLOPS
Who should attend ETL Developer Training

This course is designed for anyone who is interested in learning ETL using SQL Server Integration Services 2014.  It covers topics that help you become ETL Developer.

This course can be attended by:

  • Developers
  • QA engineers
  • Database Administrators
  • Service engineers (and SREs)
  • Program Managers
  • BI Analysts/Developers
  • Report writers
  • And anyone who is interested.
Pre-requisites for ETL Developer Training

This course is open to anyone with IT background. However, anyone with prior database experience is a plus (though not required)

You need to have basic knowledge of the following:

  • Basics of T-SQL (You may also join SQL Developer Training)
  • Microsoft Windows Operating System
  • Concepts of relational database management system

Note: This course is not for you if you are newly joining IT industry.

Benefits for ETL Developer Training

List of benefits offered to students joining this course:

  • Placement assistance
  • Job reference
  • Completion certificate
  • Interview preparation
  • Access to Q&A forum
  • Access to recorded sessions
  • Instructor with 12+ years experience
  • Real-life examples
  • Weekly/monthly quiz
  • 15% Discounts on other trainings

Some of the topics covered in this course:

ETL Developer Training Topics

We care about your success!

Our trainers go through rigorous hiring process before they join our team. Every single trainer has at-least 10 years of on-the-field experience.

Happy students

ETL Developer Class - Detailed Syllabus

ETL Developer (SSIS 2014) Class Syllabus

Overview and Installation of SSIS 2014
Using Import and Export Wizard
Installing Integration Services
Setting up Sample Databases
Creating a Solution and Project
Overview of the SQL Server Data Tools
Creating your First SSIS Package
Control Flow
Using Precedence Constraints
Using Files with the File System Task
Using the Execute SQL Task
Using the Execute Process Task
Using the Expression Task
Using the Send Mail Task
Using the FTP Task
Creating a Data Flow
Data Flow
Extracting Data from Sources
Loading Data to a Destination Server
Changing Data Types with the Data Conversion Transform
Creating and Replacing Columns with the Derived Column Transform
Rolling up Data with the Aggregate Transform
Ordering Data with the Sort Transform
Joining Data with the Lookup Transform
Auditing Data with the Row Count Transform
Combining Multiple Inputs with the UNION ALL Transform
Cleansing Data with the Script Component
Separating Data with the Conditional Split Transform
Handling Bad Data with the Fuzzy Lookup
Removing Duplicates with the Fuzzy Grouping Transform
Creating Dynamic Packages
Making a Package Dynamic with Variables
Making a Package Dynamic with Parameters
Making a Connection Dynamic with Expressions
Making a Task Dynamic with Expressions
Common ETL Scenarios
Loading Data Incrementally
Using the CDC Components in SSIS
Using Data Quality Services
Using the DQS Cleansing Transform
Creating a Master Package
Using Containers
Using Sequence Containers to Organize a Package
Using For Loop Containers to Repeat Control Flow Tasks
Using the Foreach Loop Container to Loop through a Collection of Objects
Configuring SSIS Packages
Deploying Packages with Configuration Tables
Deploying Packages with Configuration Files
Configuring Child Packages
Troubleshooting SSIS
Logging Package Data
Using Event Handlers
Troubleshooting Errors
Using Data Viewers
Using Breakpoints
Administering SSIS
Creating and Configuring SSIS Catalog
Deploying Packages to the Package Catalog
Configuring the Packages
Configuring the Service
Securing SSIS Packages
Running SSIS Packages
Running Packages in T-SQL and Deploying Packages
Scheduling Packages