ETL Testing

If you are Interested to build your carrier in the field of Core Java ? Then this course is exclusively designed for you! This course has been designed by eminent corporate trainers with vast experience in Industry sector with real time knowledge. So that we can share our knowledge and help you learn complex theory, algorithms and coding libraries in a simple way. We will make you to walk you step-by-step into the World of Data Science. With every tutorial you will develop new skills and improve your understanding of this challenging yet lucrative sub-field of Core java.

Course Duration

25 Days

Training Options

Classroom / Online

Rating

5/5

Why Should You Take Core Java?

Very cost effective and highly affordable low class training by real time experts

Very cost effective and highly affordable low class training by real time experts

Very cost effective and highly affordable low class training by real time experts

Instructor-led ETL Testing Live Classes

Sep 21st SAT & SUN (6 WEEKS) Timings - 08:30 PM to 11:30 PM (IST Online
Sep 21st SAT & SUN (6 WEEKS) Timings - 08:30 PM to 11:30 PM (IST Online
Sep 21st SAT & SUN (6 WEEKS) Timings - 08:30 PM to 11:30 PM (IST Classroom
Sep 21st SAT & SUN (6 WEEKS) Timings - 08:30 PM to 11:30 PM (IST Online

Course Price at

₹ 19,179 ₹ 30,000

About Course

It has been observed that Independent Verification and Validation is gaining huge market potential and many companies are now seeing this as prospective business gain. Customers have been offered different range of products in terms of service offerings, distributed in many areas based on technology, process and solutions. ETL or Data warehouse is one of the offerings which are developing rapidly and successfully.

About Trainer

Can’t find a batch you were looking for?

Skills Covered

  • What is ETL Testing ?
    • Overview about ETL testing
  • Difference between ETL Testing and Database Testing
  • What is a Data warehouse?
  • Introduction to Data warehousing.
  • Why Data warehouse and why not Database?
  • What is ETL ?
  • What is a Datamart?
  • Different types of Mapping in Data warehouse.
  • Different types of Schemas.
  • Slowly Changing Dimensions.
  • What is Database?
  • Files VS Databases
  • Different types of Databases.
  • What is SQL
  • DDL,DML,DRL,DCL,TCL overview
  • Select statements basics
  • Primary key
  • Foreign key
  • Unique key
  • Not Null
  • Check
  • Default
  • Table Creation, Updation, Inserting and Delete
  • Table Alter, Truncate, Drop
  • Commit & Rollback
  • Views
  • Mathematical operations
  • Columns aliasing
  • Where clause
  • Having clause
  • Difference between where and having clause
  • Group by
  • Order by
  • Logical operators
  • Special operators
  • Arithmetic functions
  • String functions
  • Date and Time functions
  • Ranking functions
  • Null functions
  • Case expression
  • Aggregate functions
  • Set operators
  • Table aliasing
  • Joins
    • Different types of joins
  • Sub queries
    • Multiple subqueries
    • Correlated subqueries
  • Normalisation
  • Denormalisation
  • Datawarehouse Architecture
  • Staging Area
  • Dimensional modelling
  • Dimensional Table
  • Fact Table
  • Star schema
  • Snow flake schema
  • Types of Dimensional tables
  • Data merging
  • Data cleansing
  • Data scrubbing
  • Data Aggregation
  • Types of Loads
  • Conformed dimensional table
  • Degenerated dimension table
  • Junk Dimensions
  • What is informatica
  • Workflow monitor tool usage
  • Types of transformations
  • Types of ETL testing
  • Understanding ETL Testing Project Architecture
  • Project objective
  • Project Documents(BR, FR, mapping documents, TDD, Technical Specifications)
  • Testing Life cycle in the ETL project
  • Test cases preparation and execution
  • Test Data Preparation
  • Testing Techniques

Like the curriculum? Enroll Now

Structure your learning and get a certificate to prove it.

ETL Testing

QEdge Tech Core Java Professional Certificate Holders work at 1000s of companies like

Reviews

John Doe
John Doe
@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
John Doe
John Doe
@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
John Doe
John Doe
@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
John Doe
John Doe
@username
Read More
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Previous
Next

QEdge Training Features

Theory

Project Work

Assignments

Certification

Resume Preparation

Interview Preparation

Resume Marketing

Placement Support

Frequently Asked Questions

This course is about to learning software testing training includes both manual testing and automation (selenium) testing.
We have a huge team of experienced faculties with advanced industry exposure for better course handling and real time guidance.
Depending on the choice of the course, the duration varies as per the curriculum and mode selected.
The course fee is variable as per the choice of the course structure and mode.

There is no prerequisite for learning the software testing, coding knowledge is advantage.

Be Future Ready. Enroll Now

Structure your learning and get a certificate to prove it.

Register for Demo
close slider




    Looking for

    Classroom TrainingOnline Training

    Select Your Country





      Looking for

      Classroom TrainingOnline Training

      Select Your Country