1) What is Data ware housing 2) Features of data warehouse 3) OLTP & OLAP Systems 4) Database V/s Data warehouse 5) ETL V/S Database Testing 6) What is Data model 7) Types of Data models 8) Star schema & Snowflake schema 9) SCD (Slowly Changing Dimensions ) 10) ETL V/S BI Tools

I am new to this but still i understood 100% what he said. thank you so much for explaining so lucidly.

@sdetpavan

Жыл бұрын

Glad it was helpful!

Star schema resembles a star with points radiating from a center table(fact table) which has primary keys from dimension tables whereas snowflake schema is an extension to star and the dimensional table is normalized into multiple lookup tables. And Fact constellation Schema has more than one fact table and looks like a network.

Thank you Sir, Your are my one of the favourite Teacher. Your teaching style and language is very nice and understandable.Thank you again.also thankfull to KZread platform because of them we have exellent teachers like you.(in marathi-ek divas tumchya paaya padayala yeyil sir)

What a Champion - this helped alot

loved the way you teach ❤️❤️

Thank you so much for this session, cleared all my doubts related to ETL

@sdetpavan

Жыл бұрын

Welcome

Very Informative & knowledgeable content...Thanks !

@sdetpavan

Жыл бұрын

My pleasure

My all time fav teacher.. You are very good in teaching ,As a non tech person even I could understand easily.. Thank you so much !!

@sdetpavan

Жыл бұрын

Welcome

@vishnugowda7998

Жыл бұрын

@@sdetpavan excellent classes for beginners...

@AkshayGG

Жыл бұрын

@@sdetpavan which Oracle Database Version i should install????

Eey opener, thanks for the intentions of explaining the theme of technolgies in details sir.

🙏🙏🙏🙏🙏🙏 Thanks alot for this crystal clear explaination......

@sdetpavan

Жыл бұрын

Most welcome

Thank you so much for your valuable explanation sir .your explanation is Cristal clear.

@sdetpavan

Жыл бұрын

Welcome

Good course and well explained. There is some lag between the screen display and the voice over. From 1:20:30 duration, displayed screen and the explained topic is not syncing, may be some part of the screenshare is not visible.

God of Testing 👌

Great session

@sdetpavan

Жыл бұрын

Thanks

Great Sir..! Very Informative sessions

@sdetpavan

25 күн бұрын

Thanks

very well done sir..simply Amazing..

@sdetpavan

6 ай бұрын

Thanks

Hello Sir, your videos are very helpful. I am new to ETL and have to automate jobs developed on Talend. Need your guidance around it.

Thank you sir yours classes are very helpful and your explanation is the best thing in your class 👍❤️❤️

@sdetpavan

Жыл бұрын

thanks

👌👌👌nice explain

@sdetpavan

19 күн бұрын

Thank you

Very good & easily understood

@sdetpavan

Жыл бұрын

Thanks

Wonderful session 👍

@sdetpavan

Жыл бұрын

Thanks

Great teaching , have you any soft form of all these topics and lectures?

Good Intro contents on DWH !

Hi Sir For SCD 2 We are maintaining the history and for that we have to generate a surrogate key so that it wont be duplicate.

Nice explaination

@sdetpavan

Жыл бұрын

Thanks

Very clear explanation.Thank you

@sdetpavan

2 ай бұрын

You are welcome

Tnq so much sir Very informative topic sir.

@sdetpavan

2 жыл бұрын

Most welcome

Could you please add intermediate and advanced concepts of ETL testing?

wonderful teaching sirrrrr

@sdetpavan

Жыл бұрын

thanks

Excellent presentation, so could you please do the "REAL TIME- ETL Project"

@daryn86

Жыл бұрын

Yesssss this! You're the best Pavan!

I just love your way of teaching,I'm happy that I got a mentor on KZread who does his job with whole dedication❤Thanks a lot Sir!

@sdetpavan

Жыл бұрын

Welcome

@vithalraopatil5132

9 ай бұрын

​@@sdetpavansir session-2 is missing in your videos....

I love that during recording he only has 2 people watch but I am the 250,000th person to watch this on YT. lol

very well explained

@sdetpavan

9 ай бұрын

Thanks

Part 4 covering ETL Testing Concepts

Thank you so much for this video. Could you please update session 2 as in part 2 video session 3 is there but session 2 is missing in which ddl, select, inset and update function has covered.

Sir plz explain ETL testing life cycle

Correction (1:11:56)In the fact table every column Is a foreign key which Is having a relationship with dimensions table primary key ( need correction) And also the table can hold only one primary key or composite key Please make a correction

@vinodk1512

2 жыл бұрын

Yes correct!!

@venkatasubbanaidukota492

2 жыл бұрын

Correct bro 🎉

@SURESHREDDY-cm7vt

Жыл бұрын

Yes

Hi sir .. thanks for the valuable information Really great help Is this vedios enough for attending the 3+ years of experience

Good morning sir🙏 . please share ETL interview questions and answers.

Fact table contains the foreign keys that are associated with diamensional table . And diamensional table contains primery keys . Each table has only one primary key .

@gbharathi5556

9 ай бұрын

Yes

Very informative

@sdetpavan

Жыл бұрын

Glad it was helpful!

Thank you so much sir🙏

@sdetpavan

3 ай бұрын

Welcome

Sir, can you please upload videos of teradata sql

Thank you sir

@sdetpavan

Жыл бұрын

Welcome

@Pavan sir what is the difference between Udemy Course of your's vs your actual training that you give.

Sir can you please provide the PDF file from which you are explaining. That would be of great help sir. It's a request sir please do share.

Superb content , Can we get the notes what you are typing in notepad.

Please add timestamps

Sir is good way for manual tester skip to ETL tester could you please give me information ASAP Sir

Please provide English subtitles sir, for easy understanding.

at 1.32.19 the updated year should be there and also the location in type 3 SCD , old loction will be the same

Is there any possibility to add CC (Closed Captions) to this videos? Thank you.

Hi I started learning ETL testing basics..i saw one class which version of oracle database i should install???

In this course can you explained about informatica

hi..pavan sir i hope you welll , sir i think second session is missing in the ETL testing tutorial videos , sir plz upload and as well as plz uoload videos on ETL stuff thank you sir

Can i know difference between normalised and denormalization

Hi Sir.. As per my Understanding Star Schema is a de-normalised and snowflake schema is a normalised. Please can you explain how star schema is de-normalised ? In this schema all tables are connected fact table and these tables are contain primary key... These primary keys will not allow redundant data... Please explain briefly...!!

Yes

Sir can we have... Continuation videos after this... ETl tools and bi tools directly it's showing... Session 3 where is session 2...plz upload it

What are the tools for ETL testing?

Hello sir.. Your session is really good. But there is a mismatch in voice and visuals, so it gets confusing. Audio comes first and then video

@deepthimopuru6314

4 жыл бұрын

same problem ..can you plz resolve soon

What tool is involved as etl testing tool in this tutorial playlist?

Sir in SCD type 3 doesn't creat a many duplicate date like in type 2? Then what's the difference w.r.to data storage?

Hi Sir, could you please upload session 2 class video.

Please upload the session - 2 of ETL testing. Or just share the index for the same. So it will be very helpful to know what I missed, Thanks.

@sdetpavan

5 жыл бұрын

Hi Abhishek, I covered SQL basics in 2nd video. Some how it is corrupted. Instead, you can watch SQL video in which I covered same concepts. Link: kzread.info/dash/bejne/fJeK0ctwe5jLqM4.html

@natashaparihar1334

5 жыл бұрын

kzread.info/dash/bejne/npmOxduGptzFabw.html

For every application is there one OLTP ?? Or only one OLTP for all applications on different locations

If i have followed your SQL for tester playlist. Will i understand this palylist or not? Do i need any other playlist knowledge??

Hi Sir Do you provide any Etl course in Udemy or in any other platform so that we can get in?

Hi everyone, I'm working as manual tester for 3.5+ years and trying to switch from manual testing. If I learnt ETL testing, will I be able to get job in etl testing since I don't have experience in that ??? Any suggestions are welcomed please help me with my career. Thanks

yes

Hello Sir, Could you please provide the notes for all the etl testing videos?

This playlist is enough to show 1 year experience ??? Please reply sir

Hi Team, Do u have any idea on on ETL automation with Python using Talend.. If so can you please help me on this.. I need it as i have urgent requirement. Thanks in advance

@rupam1505

2 жыл бұрын

Hi Satish .. did you get some content .. my problem statement is similar ETL automation with java. Your response would be a great help.

@saisatishsteel

2 жыл бұрын

@@rupam1505 Nope..please do let me know if u find any solution

Sir is there scope for automation or manual testing.?

what does mean Data integration and how we are going to validate Data integration?

Is ETL tetsing have a good and bight scope? Plse tell anyone

I wanna learn ETL Testing

Please share documents also

will this be usefull for aql developers?

Hi Sir is this Playlist is enough to to etl testing job role sir or anything else i need to study from coaching center plz give your response sir

Can you please share the all stuff videos

Sir , after this part there is session 3 in part 2 what about session 2 where I can find session 2 pls send link

@vivekpatil7636

2 жыл бұрын

kzread.info/dash/bejne/lI2bxsGIcsmtgqg.html&ab_channel=SDET-QAAutomationTechie

Sir explain to olap

sir, do we have any pdf motes for this lecture?

thank you sir... how can we download notes

macharla sv congratulations. Are you a fresher?

Sir can i get the notes of this

Sir plz upload the session 2 which is missing.

@natashaparihar1334

5 жыл бұрын

kzread.info/dash/bejne/npmOxduGptzFabw.html

Please provide real time project for ETL

Sir .... I have completed ETL Testing Course ( SQL, UNIX & ETL Concept) .....but am 4 years career cap (No experience in IT & Non IT) .....I would like to join fresher ....any chance about it sir

Session 2 is not there in playlist

Sir can you please explain about informatica cloud platform for ETL testing

@sdetpavan

4 жыл бұрын

Hi Sushma, I do not have experience on Informatica tool. I know very basic stuff. So I posted ETL testing videos based on my knowledge. Thanks.

I want all ETL Testing videos,How much it costs.. Please tell me sir

why this video is playig in blur mode? sir could you please check it

Pawan , i had gone through the Demo session of ETL - looks impressive . Can you help me out with 2nd session (please provide at least index), so that i can proceed further with 3rd session, Thanks

@sdetpavan

5 жыл бұрын

Hi Abhishek, I covered SQL basics in 2nd video. Some how it is corrupted. Instead, you can watch SQL video in which I covered same concepts. Link: kzread.info/dash/bejne/fJeK0ctwe5jLqM4.html

@natashaparihar1334

5 жыл бұрын

kzread.info/dash/bejne/npmOxduGptzFabw.html

@amitsingh-fe2wv

4 жыл бұрын

@@sdetpavan Hi sir can you provide me your number...

@venkatmutyala6794

3 жыл бұрын

@@sdetpavan Hi can i please have your contact number

Hello Sir, I wanted to ask, is this full ETL testing course? or is it beginner level testing course?

@sdetpavan

Жыл бұрын

Beginner level.

🔴NEED ETL TESTING NEW VIDEOS...BY USING CURRENT TOOL

Sir - is there any online course to join?

Is this live classes?