UrbanPro
true

A2Z DWH/ETL Testing

LIVE
5 reviews
Ongoing

Course offered by Anup Ray

6 reviews
Here the complex process of DWH/ETL testing is presented in its simplest form, which assumes no previous data warehousing experience/exposure. This will guide you through to the entire process of data warehousing and some of the BI stuff as well. So get trained in Data Warehousing and explore the wide career opportunities in the field.

Topics Covered

Data Warehousing Concepts • What is Data Warehousing and necessity of it • Difference between Data Warehouse and Database • Data Warehousing architecture • OLAP & OLTP • Data Mining and Data marts Data Warehouse Design • Dimensional Modelling • Fact & Dimension tables • Star Schema • Snowflake Schema ETL Testing • What is ETL and importance of ETL Testing? • Concepts of Data Extraction • Concepts of Data Transformation • Concepts of Data Loading • Change Data Capture and SCDs • Testing Scenarios, creation of test cases and scripts ETL Testing Validations • Different validations performed in ETL Testing SQL Queries o Joins o Referential Integrity Checks o SET operators o Aggregation etc. Subject Area Model Basics of Report Testing • Validation of the report data with DB and UI testing Basics Of Informatica & UNIX

Who should attend

Anyone who is keen to learn Data warehousing and pursue a career in the field.

Pre-requisites

The person should have basic SQL knowledge.

What you need to bring

Laptop, which is not mandatory. But having one is added advantage.""

Key Takeaways

At the end of the course, you'll be able to: - Figure out what data warehousing is and how ETL testing is being carried out. - Test DWH with ease - Tackle real life challenges in DWH testing

About the Trainer

Anup Kumar Ray picture

4.7 Avg Rating

6 Reviews

5 Students

2 Courses

Anup Ray

B.Tech

5 Years of Experience

5+ years of Data Warehousing experience and 4+ years of ETL Testing Training Experience along with Database SQL, UNIX & Shell Scripting

Reviews (5)

4 out of 5 5 reviews

Anup R. https://p.urbanpro.com/tv-prod/member/photo/188781-small.jpg Mega Hills, Madhapur
4.7055
Anup R.
V
Verified Student

A2Z DWH/ETL Testing

"Trainer is good. "

Anup R.
M

ETL Testing

"He is a real professional. A must trainer for datawarehousing. The way he took control over the training sessions and the way he share the ocean of knowledge he has makes him a valuable trainer because it is not just about sharing knowledge but it is also important how you share it because that makes and keep the student interested. I feel privileged that I got a chance to learn from him I hope more people will learn under him and improve their skill set immensely like I did. "

Anup R.
M

A2Z DWH/ETL Testing

"With a strong knowledge of DWH and ETL tool , Anup gives a thorough grip by not only giving the technological fact but also simple real life examples which helps me understand the complex functionalities of tool . He can make a person with or without having a prior knowledge of DWH/ETL understand with the simple analogies . He has a very good knowledge of SQL as well . His way of teaching and knowledge together helped me understand , implement and work on DWH/ETL .Thank you Anup . "

Anup R.
S

ETL Testing

"He has a good industry experience with different kind of projects which helped me a lot. He has good knowledge in ETL Testing. The way of explaining different topics of ETL Testing with realistic Day to Day life example helped me to understand ETL Testing, Data warehouse concepts,SQL queries very easily. "

View All
Have you attended any class with Anup?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

4 out of 5 5 reviews

Anup R. https://p.urbanpro.com/tv-prod/member/photo/188781-small.jpg Mega Hills, Madhapur
4.7055
Anup R.
V
Verified Student

A2Z DWH/ETL Testing

"Trainer is good. "

Anup R.
M

ETL Testing

"He is a real professional. A must trainer for datawarehousing. The way he took control over the training sessions and the way he share the ocean of knowledge he has makes him a valuable trainer because it is not just about sharing knowledge but it is also important how you share it because that makes and keep the student interested. I feel privileged that I got a chance to learn from him I hope more people will learn under him and improve their skill set immensely like I did. "

Anup R.
M

A2Z DWH/ETL Testing

"With a strong knowledge of DWH and ETL tool , Anup gives a thorough grip by not only giving the technological fact but also simple real life examples which helps me understand the complex functionalities of tool . He can make a person with or without having a prior knowledge of DWH/ETL understand with the simple analogies . He has a very good knowledge of SQL as well . His way of teaching and knowledge together helped me understand , implement and work on DWH/ETL .Thank you Anup . "

Anup R.
S

ETL Testing

"He has a good industry experience with different kind of projects which helped me a lot. He has good knowledge in ETL Testing. The way of explaining different topics of ETL Testing with realistic Day to Day life example helped me to understand ETL Testing, Data warehouse concepts,SQL queries very easily. "

Anup R.
P

ETL Testing

"He was very god explaining the concepts. The best thing about his training is you get a feel of the real time. He links all the concepts with real time examples which will help when we start working in real time projects. "

Have you attended any class with Anup?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

A2Z DWH/ETL Testing by Anup Ray

Anup Kumar Ray picture
LIVE
(5 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

A2Z DWH/ETL Testing by Anup Ray

Anup Kumar Ray picture
LIVE
(5 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more