UrbanPro
true

ETL Testing Jan 2021

LIVE
29 reviews
45 Hours

Course offered by Sagar

29 reviews

ETL/DWH/BI TESTING COURSE CONTENT

 

SQL - MS SQL SERVER - Hand's on

 

  • Introduction to SQL
  • SQL Server Installation & High level overview
  • Hands on Exercises on below topics (200 SQL Queries)
  • DDL & DML Statements
  • SQL Operators, Union, Intersect & Except
  • Integrity Constraints & Built in Functions
  • Case Statements & Sub Queries
  • Group By, Having & Order by Clauses
  • Joins (Inner Join, Outer Joins & Self Join)
  • Views, Stored Procedures & Functions

 

Data Warehousing Concepts

                  

  • Introduction to Data Warehouse
  • Difference between Database & DWH
  • What is Dimensional Modeling and how it is different from ER Modeling
  • What is Dimension & Fact table
  • Star Schema Model vs. Snow Flake Schema Model

 

DWH: Hands on DIM & FACT tables

 

  • How to Design/Create DIM & FACT tables based on Source system
  • Hand's on Dimension & Fact tables data loading (Multiple exercises)

 

SCD (Slowly Changing Dimension

 

  • What is SCD (Slowly Changing Dimension?
  • Hands on Exercise (Real time Scenario's)
  • SCD Type 1
  • SCD Type 2
  • SCD Type 3

 

  ETL Testing: Introduction & Hand's on

  • Different types of ETL Testing Projects in Real world & Popular ETL tools
  • ETL Testing Architecture and how it differs from DB Testing
  • What is Data Mapping Document
  • Test Scenario's/Test Case/ Test Data Preparation using Data Mapping Document
  • How to validate Initial & Delta loads with examples.
  • How to report the Defects in ETL Testing?

ETL Tool : Informatica Hand's  on

  • Introduction to Informatica PowerCenter
  • Informatica PowerCenter Client Tools

                        Repository Manager

                        Designer

                        Workflow Manager

                        Workflow Monitor    

  • Informatica Terminologies(Mapping, Task, Transformations & Workflow
  • Different types of Transformations in Informatica

                  Aggregator, Expression, Filter & Joiner Transformation

                  Lookup, Rank, Router, Sorter Transformation

                  Source Qualifier Transformation, etc

  • Informatica Hand's on

            How to Create & Run Mapping/Workflow

            How to Establish Connections to Databases

            How to Debug issues using Session/Workflow Logs 

 

Real Time Project's - Hands on

  • ETL validations when Source & Target DB are Same
  • ETL validations when Source & Target DB are Different
  • ETL validations when working on Flat files
  • ETL validations when working on DWH(DIM & Fact tables)

 

ADD on’s  

 

  • Resume Preparation & 100 + Real time Interview Questions
  • Reporting/BI Tool : Microsoft Power BI
  • Introduction to DATA SCIENCE

 

Duration: 45 Hrs.      

Gallery (11)

+4 more

About the Trainer

Sagar picture

Avg Rating

Reviews

Students

Courses

Sagar

MCA

13 Years of Experience

---------------Less Theory More Practical-------------

-- 10+ years of Real time working experience in ETL/DWH/BI testing in software industry.
-- Strong experience in working with various ETL projects(Data Centric, Data warehouse, Data Migration, Data Masking, etc) using ETL/BI tools (Informatica, SSIS, OBIEE, SSRS, etc).
-- 7+ years of Classroom/Online Training experience on ETL/DWH/BI testing and trained over 2000+ students with Real time ETL projects.

Students also enrolled in these courses

LIVE
29 reviews
30 Hours

Course offered by Sagar

29 reviews
LIVE
29 reviews
30 Hours

Course offered by Sagar

29 reviews
LIVE
29 reviews
35 Hours

Course offered by Sagar

29 reviews
LIVE
29 reviews
45 Hours

Course offered by Sagar

29 reviews

Reviews (29)

4 out of 5 29 reviews

Sagar https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/6292118-small.jpg Kukatpally K P H B Phase 9
5.00529
Sagar
Y

ETL Testing

"First thing in first class of the course said by sagar sir, sir makes the course so easy by taking examples from real life experience by which every one will an idea of the course.Average person can learn that easily without any problem. "

Sagar
Y

ETL Testing

""I feel it's a great opportunity to learn Etl testing from sagar sir,as the tag line says less theory more practical that is 100% true to the best of my knowledge. Your explanation was very neat and crystal clear ,while ur explaning itself builds confidence levels in us that we can write quries and test cases easily with different approaches. The person who is not aware of sql or etl also can gain excellent knowledge by ur training." "

Sagar
M

ETL Testing

"90% practical knowledge less theoretical explanation. If anybody wants to go for ETL testing training, then I have to say Sagar sir is the go to person.all real time knowledge is given in the training. "

Sagar
R

ETL Testing

"Less theory more practica100% will get more knowledge in SQL and sagar garu proved it amazing experience throughout the training. "

View All
Have you attended any class with Sagar?

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 29 reviews

Sagar https://s3-ap-southeast-1.amazonaws.com/tv-prod/member/photo/6292118-small.jpg Kukatpally K P H B Phase 9
5.00529
Sagar
Y

ETL Testing

"First thing in first class of the course said by sagar sir, sir makes the course so easy by taking examples from real life experience by which every one will an idea of the course.Average person can learn that easily without any problem. "

Sagar
Y

ETL Testing

""I feel it's a great opportunity to learn Etl testing from sagar sir,as the tag line says less theory more practical that is 100% true to the best of my knowledge. Your explanation was very neat and crystal clear ,while ur explaning itself builds confidence levels in us that we can write quries and test cases easily with different approaches. The person who is not aware of sql or etl also can gain excellent knowledge by ur training." "

Sagar
M

ETL Testing

"90% practical knowledge less theoretical explanation. If anybody wants to go for ETL testing training, then I have to say Sagar sir is the go to person.all real time knowledge is given in the training. "

Sagar
R

ETL Testing

"Less theory more practica100% will get more knowledge in SQL and sagar garu proved it amazing experience throughout the training. "

Sagar
S

ETL Testing Jan 2021

"Went in knowing nothing about sql,straight forward and engaging lessons and awesome assignments trained me. And explained so well in such a way that even a candidate with zero knowledge can understand the concepts and can complete the course,finally thank you sir once again. Absolutely enjoyed the classes and course. "

Sagar
A

ETL Testing

"I have a great experience with Sagar Sir in ETL Testing training,The way he explained DB Queries in different scenarios are good to understand with his explanation.Teach every concept in detail with realtime scenarios, less theory and more practical. Gives assignment regularly basic and make a practice habit to you. And always welcome with your questions. Gives recorded videos in shared drive. When ever you need access it N number of times. and sagar teaches me ETL testing from starting to advanced concepts and always available to solve my doubts. Informatica tool explanation is very good. Who are willing opt ETL testing, I suggest you all go with sagar Sir. Thanks, "

Sagar
A

ETL Testing Jan 2021

"From knowing zero about MS SQL Server, I can now confidently read and write queries, views, unions and so much more. I've had no coding background prior to learning SQL. There is nothing I can fault about the course or the lecturer Sagar Sir. He really does explain everything that you need to know. Very easy to understand what is being said. Nothing is rushed, relaxed pace. Just the way he speaks encourages you to listen and move forward with each lecture. He provides wonderful examples and practice exercises at end of every session. This truly is a course for everyone! I couldn't have picked a better course or lecturer to get me on my way with MS SQLServer. And, coming to DWH he is explaining the concepts crystal clear and giving real time examples for the same. "

Sagar
S

ETL Testing

"Being a part of this training we can be strong on SQL, Dataware housing, real time project on ETL , informatica tools etc.... "

Sagar
S

ETL Testing

"Being a part of this training we can be strong on SQL, Dataware housing, real time project on ETL , informatica tools etc."

Sagar
V

ETL Testing

"Thank you Sagar Sir for a great course. Great presentation style with lots of opportunities to ask questions and talk about real time examples which all made for a reality environment" "This has more than met my expectations." "A wonderfully practical course - both personally and professionally.“Fantastic Trainer, very friendly and encouraging. All of the exercises were on a scale of good to excellent.” "

Sagar
N

ETL Testing

"Each and every topic is explained in detail with practice sessions. All the topics are explained with lot of examples and gave assignments. Maintains lively atmosphere in class and make everyone to interact in class. "

Sagar
P

ETL Testing

"I have a great experience with Sagar Sir in ETL Testing training,The way he explained SQL Server Queries in different scenarios are good to understand with his explanation. More over your are always welcome with your questions what ever you have after completing your queries. He is going to take a class on concepts. Every day he will put exercises questions along with recorded videos in shared drive. When ever you need access it N number of times. and sagar teaches me from beginner to advanced concepts and always available online to solve my doubts. Informatica tool explanation is very good. Who are willing opt ETL testing, I suggest you all go with sagar having almost 9 - 10 years experience. "

Sagar
E

ETL Testing

"This is best places to learn etl/dwh testing. After attending training under sagar sir you can crack any interview related to db that for sure. 100% by personal experiences I am saying this. His has covered end to end process with practical s. When ever I was going for interviews just revision all his materials. I was able to wrote most of queries in the interview. Online training really good, while running the classes he is asking us to share screen and he give some questions to write the queries. 2 ways it better for students 1) if your written wrong answers at that time only all your mistakes will clarify in the class. 2) if your answer correct, it will give lot of confidence and reduces all the fear it is really helpful to every student,how are settled in testing. "

Sagar
R

ETL Testing

"It's a best places to learn Database and ETL Testing. After attending training under Sagar Sir you can crack any interview related to DB that for Sure. 100% By personal experiences I am saying this. His material is too good and covered all topics with good Examples. When ever I was going for interviews just revision all his materials. I was able to wrote most of queries in the interview. Online training really good, while running the classes he is asking us to share screen and he give some questions to write the Queries. 2 ways it better for students 1) if your written wrong answers at that time only all your mistakes will clarify in the class. 2) if your answer correct, it will give lot of confidence and reduces all the fear Ramu Kodamasimham. "

Sagar
M

ETL Testing

"Teaching is really excellent. Sagar has made it easy to understand topics with examples ,taught us from basics to complex queries. Real time projects were explained step by step and practical assignments were given everyday which made us to learn more and explore through different scenarios and also Tests were conducted in between which made me to identify the lacking part which i need to learn more. Finally gained confidence in the subject and i would definitely recommend any one who is looking for practical knowledge. Thank you Sagar for Valuable inputs, excellent delivery of subject and Your experience made us learn more Practically. "

Reply by Sagar

thank you so much Madhuri for taking the precious time to leave this excellent review..... Appreciate & All the Best!!!

Sagar
M

ETL Testing

"Sagar's teaching methodology is the best part of his training . His day-to-day tasks have made me feel confident. His sessions are very engaging and everything is explained in detail. I am sure that I gained more knowledge than I expected. Trust me guys your thought process will change to the next level after practising all the complex scenarios. HIGHLY recommended. "

Reply by Sagar

thank you so much Mounika for taking the precious time to leave this excellent review..... Appreciate & All the Best!!!

Sagar
K

ETL Testing

"This is the first time taking a class with Online, so the experience was unique to me. I wasn't quite sure what to expect, but I am very impressed with this format,its all because of Sagar who has great knowledge, he was very good at communicating with all the attendees and ensuring questions were answered. And most importantly he gave us real time & practical oriented training. Thank you Sagar for the knowledge you have shared with us. I would definitely recommend to others. "

Reply by Sagar

Thank you Kalyani for your wonderful feedback. Wish you all the best.

Sagar
R

ETL Testing

"Good trainer. Sagar has excellent knowledge in etl/ datawarehouse testing, he explains real time scenario in excellent way. "

Reply by Sagar

Thank you Raghavendra. Wish you all the best.

Sagar
J

ETL Testing

"Sagar has excellent teaching skills and very good knowledge. The classes were highly interacted and practical oriented. He explains concepts very clearly with examples and covers all possible real-time scenarios. Thank you Sagar for providing such a wonderful training. "

Reply by Sagar

Thank you Jyothi for your wonderful feedback. Wish you all the best.

Sagar
P

ETL Testing

"Wonderful trainer. Understands well. Explains every concept clearly. Got trained for 2 months. Happy with the program "

Reply by Sagar

Thank you Phani for your wonderful feedback/Review Wish you all the best.

Sagar
B

ETL Testing

"Thank you sagar for the knowledge you shared. Sagar is very good at db and etl side. Very patient and he is the right person to learn etl testing. Thank you so much for your support. Highly recommended to all. Has good grip in the concept. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
M

ETL Testing

"Sagar is excellent trainer. He provides fully real time and practical oriented training. If any one looking for ETL Testing career this is the best place to learn. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
R

ETL Testing

"Sagar is a true mentor, excellent coach and his trainings focuses on in-depth hands on knowledge on various projects, effectively tackling issues of each student individually and ensuring that basic concepts of DWH/ETl are clear to all - is quite remarkable! Not only ETL training under him has made me strengthen my querying skills but I could place my self in better job and my approach on troubleshooting bigger SQL queries has been much better ever since. Undoubtedly one of the best trainer I ever come across! "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
S

ETL Testing

"Sagar has in depth knowledge in subject . He tries to explain each and every topic in detail and has designed the courses in a perfect manner. He is friendly,liberal and can accommodate the timings according to the students. He makes things simpler with in-detail explanation. He is well experienced and know how to teach the people who are from completely different platform & also nice experience because of him got an very good idea about tool, thank you. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
S

ETL Testing

"Well experienced with realtime experience, Sagar really helped a lot for me to know the practical knowledge about ETL testing as I know nothing about testing because I am starting from the beginning level, He will explain each and every scenario with real time example .At the end I had a lot of confidence in me. " "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
P

ETL Testing

"Well experienced with realtime experience, Sagar really helped a lot for me to know the practical knowledge about ETL testing as I know nothing about testing because I am starting from the beginning level, He will explain each and every scenario with real time example .At the end I had a lot of confidence in me. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
N

ETL Testing

"I have experienced a very good learning in ETL testing from Sagar Sir. I am happy to say that I got placed in MNC with in a short period of time after completing the course. Sir explains each and every concept thoroughly with real time examples. Now I am able to write complex queries easily. I really thank sir for making me comfortable in understanding ETL. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
N

ETL Testing

"I have experienced a very good learning in ETL testing from Sagar Sir. I am happy to say that I got placed in MNC with in a short period of time after completing the course. Sir explains each and every concept thoroughly with real time examples. Now I am able to write complex queries easily. I really thank sir for making me comfortable in understanding ETL. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Sagar
S

ETL Testing

"My Experience with online ETL testing training by SAGAR Sir was very impressive. His way of explanation gave us confidence in writing complex SQL queries and also I have experienced good knowledge on Informatica ETL tool .He explains with real time scenarios . Thanks Sagar Sir for providing End to End concepts of ETL testing. "

Reply by Sagar

Thank you so much for your valuable feedback/Review....Keep it n touch!!!

Have you attended any class with Sagar?

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

ETL Testing Jan 2021 by Sagar

Sagar picture
LIVE
(29 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

ETL Testing Jan 2021 by Sagar

Sagar picture
LIVE
(29 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