What is ETL | What is Data Warehouse | OLTP vs OLAP

In this video, we will discuss what is ETL (Extract, transform, load), what is data warehouse and the purpose of it. The difference between OLTP (Online Transaction Processing System) vs OLAP (Online Analytics Processing System). Apache nifi, talend, informatica are some the entreprise ETL tools whereas for data warehouse teradata, amazon redshift, snowflake, greenplum etc are widely adopted in the industry.

#ETL #DataWarehouse #OLAP #OLTP

#️⃣ Social Media #️⃣

[mohammadsyariefali]

I've watched 3 videos before this and no one explained it as good, fast, and clear as you do. Thank you!

[sumitpatil]

I went through lots of Google search and read this topic but it was not clear to me but you made it very simple and I got overall idea of main 3 topics 1) ETL 2) DW and 3) OLTP &OLAP just in 8 minutes ...Thank you

[jithindas]

Felt like I got 20 pages worth of information in just 8 mins, thank you so much!

[naturelovers]

I remember this was first video i saw and i decided to become ETL developer after seeing that video just clear some concepts from that day to now after lots of hardwork a ETL developer. Working on talend, matillion, informatica and abinitio. This journey is quite amazing.

[sahilkadu]

ur really great teacher. I learnt a whole warehouse tool without understanding what warehouse and ETL actually does is. and here this 8 min video explained me in the best way possible.

[SpaceMusicOutofWorld]

You explained it clearly in 8 minutes!! My teacher took one hour of our times to explain the difference, and he failed to.

[gracechan]

Wow, you're a really great teacher. It's very clear and concise. Thank you!

[pattapukhannaji]

excellent over view for ETL learners. I've watched similar videos before this and no one explained it as good, fast, and clear as you do. Thank you so much.

[pranaykumarperla]

i have watched no of videos on OLAP and OLTP, i am not 100 % sure. But by watching your video i got full clarity sir.

[guidocasella]

never heard so much clear than like you are explaining, thanks mate!
greetings from argentina

[vanshverma]

My god, this is by far the best explanation of all those jargons. Very well explained sir. Thank you very much. Best wishes to you.

[ЕвгенийГеров]

The best explanation of OLTP and OLAP I have watched in YT so far. Thanks a lot, bro

[SK-kgen]

This man is a genius. Summarised so much in a single go. Thank you and keep up doing the good work!

[anirbanc]

you are the best teacher, ever! thank you for making videos on youtube, i may become somebody because of the help from your videos

[p.sarankumarpatro]

In a span of time I got a descriptive knowledge about ETL .Thank you.

[flamboyantperson]

This is the best tutorial given by you because nobody has so far touched it

[johnblackstockmusic]

Appreciate this video! We're learning ETL in my Business Intelligence class and this summed up an entire chapter in 8 minutes!

[career-calling]

Great job simplifying concepts in plain English which is the need of the hour in today's jargon-filled world. Thank You.

[sowmya]

Extreamly useful. A quick brush up video for interview preparations. I had a very complex understanding on these concept. Now its 100% clear.

[MohamedSaid-obug]

Simple explaination of the relation between ETL en Data warehouse. THNX!!