ETL TestingCourse Duration: 25 Hr

Selfpaced Tech is the leader in ETL Testing online training courses. We provide quality of online training and corporate training courses by real time faculty and well trained software specialists. Our ETL Testing online training is regarded as the best training by students who attended ETL Testing online training with us. All our students were happy and able to find Jobs quickly in India, Singapore, Japan, Europe, Canada, Australia, USA and UK. We provide ETL Testing online training in India, UK, USA, Singapore and Canada etc..


Rating: 4/5

Course Description

Extract, Transform & Load is a process in Data Warehousing. ETL refers to, "Extraction of data from different applications" developed & supported by different vendors, managed & operated by different persons hosted on different technologies "into Staging tables-Transform data from staging tables by applying a series of rules or functions - which may include Joining and Deduplication of data, filter and sort the data using specific attributes, Transposing data, make business calculations etc - to derive the data for loading into the destination system-Loading the data into the destination system, usually the data warehouse, which could further be used for business intelligence & reporting purposes.

Course Price: $ 400 $ 350

Features

Live online instructor led sessions by industry veterans. Industry renowed training to boost your resume.
Incredible practicals, workshops, labs, quiz and assignments. Personalized one to one career discussion with the trainer.
Real life case studies and live project to solve real problem Mock interview & resume preparation to excel in interviews
Lifetime access to course, recorded sessions and study materials Premium job assistance and support to step ahead in career

Prerequisites

  • knowledge of Quality Assurance testing processes, the software development lifecycle, Windows operating systems, and Microsoft Office products.
  • Basic knowledge of Software testing and Sql

Curriculum

  • What is Data Warehouse?
  • Time Variant
  • Non-Volatile
  • Subject Oriented
  • Integrated
  • Differences between OLTP and OLAP
  • Design Schema
  • ETL – Extraction Transformation & Loading
  • Reporting
  • Data Extraction
  • Data Transformation
  • Data Cleansing
  • Data Scrubbing
  • Data Merging
  • Data Aggregating
  • Data Loading
  • Initial Load / Full Load
  • Incremental Load / Delta Load
  • Top down Approach / Dependent Data Mart
  • Bottom up Approach / Independent Data Mart
  • Dimension Table & Fact Table

  • Star Schema
  • Snow Flake Schema
  • SCD Type 1
  • SCD Type 2
  • SCD Type 3
  • Conceptual Modeling
  • Logical Modeling
  • Physical Modeling
  • Basic concepts in SQL

  • Data Warehousing Architecture
  • Active Transformation
  • Sorter Transformation
  • Filter Transformation
  • Router Transformation
  • Rank Transformation
  • Joiner Transformation
  • Union Transformation
  • Aggregator Transformation
  • SQL Transformation
  • Passive Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Stored Procedure Transformation
  • Connected Transformations
  • Unconnected Transformations
  • Finding difference between source tables and target tables
  • Finding Duplicate Records
  • Finding Junk Values
  • Incompatible and duplicate data

FAQs

The tools you’ll need to attend training are:
  • Windows: Windows XP SP3 or higher
  • Mac: OSX 10.6 or higher
  • Internet speed: Preferably 512 Kbps or higher
  • Headset, speakers and microphone: You’ll need headphones or speakers to hear instruction clearly, as well as a microphone to talk to others. You can use a headset with a built-in microphone, or separate speakers and microphone.
The trainings are delivered by highly qualified and certified instructors with relevant industry experience.

People from various domains with no prior knowledge of this technology have got successfully trained with us and are now working in the this industry. Though, knowledge of basics is an added advantage.

Get your batch scheduled at your convenient time. Schedule Now