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

Поділитися
Вставка
  • Опубліковано 29 січ 2025

КОМЕНТАРІ • 417

  • @codebasics
    @codebasics  2 роки тому +6

    Do you want to learn technology from me? Check codebasics.io/ for my affordable video courses.

  • @mohammadsyariefali2978
    @mohammadsyariefali2978 3 роки тому +85

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

    • @codebasics
      @codebasics  3 роки тому +6

      You're very welcome! Glad it was helpful!

  • @sumitpatil9648
    @sumitpatil9648 3 роки тому +37

    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

    • @codebasics
      @codebasics  3 роки тому +3

      👍☺️

    • @anika7277
      @anika7277 Рік тому

      I totally agree , I was looking for something that gives us an overall idea and this video did the job !!!

  • @jithindas6084
    @jithindas6084 3 роки тому +9

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

  • @pattapukhannaji780
    @pattapukhannaji780 3 роки тому +20

    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.

  • @gracechan3039
    @gracechan3039 4 роки тому +111

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

  • @sahilkadu5409
    @sahilkadu5409 3 роки тому +1

    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
    @SpaceMusicOutofWorld 2 роки тому +1

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

  • @tarakpalati
    @tarakpalati 3 місяці тому +1

    FAST and CLEAR explanation man!!!

  • @shobogenzo
    @shobogenzo 23 дні тому

    Extremely helpful and concise. I love how you broke down what ETL is without using the term ETL at first. Subscribed!

  • @ЕвгенийГеров
    @ЕвгенийГеров Рік тому

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

  • @flamboyantperson5936
    @flamboyantperson5936 5 років тому +2

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

  • @naturelovers457
    @naturelovers457 Рік тому +1

    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.

  • @guidocasella2066
    @guidocasella2066 Рік тому

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

  • @p.sarankumarpatro9773
    @p.sarankumarpatro9773 4 роки тому +4

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

  • @vanshverma2115
    @vanshverma2115 9 місяців тому

    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.

  • @SK-kg6en
    @SK-kg6en 4 місяці тому

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

  • @johnblackstockmusic
    @johnblackstockmusic 4 роки тому +12

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

    • @codebasics
      @codebasics  4 роки тому +1

      Glad it helped John

    • @rayray7244
      @rayray7244 3 роки тому +3

      I'm telling you if I had to do it over again I'd get my education from UA-cam and Udemy! Would've saved me 100k in student loan.

  • @porrasbrand
    @porrasbrand 2 роки тому

    What a Great and simple explanation - finally - after so many videos that are so complicated and with youtubers showing their faces and talking talking talking and they don't go to the poin.
    This was on the point !! Directly and Well Explained!! Great!!

  • @anirbanc88
    @anirbanc88 2 роки тому

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

  • @samdawg12
    @samdawg12 3 роки тому +2

    You helped me understand OLAP in 5 minutes. Thank you so much, Dhaval.

  • @mindlospikiri7723
    @mindlospikiri7723 Рік тому +1

    The best explanation on youtube

  • @lcsmrt
    @lcsmrt 2 роки тому

    I don't usually comment on videos, but this one deserves the effort. What a great explanation. Congrats

  • @pranaykumarperla1224
    @pranaykumarperla1224 Рік тому

    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.

  • @career-calling
    @career-calling Рік тому

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

    • @codebasics
      @codebasics  Рік тому

      Thank you so much for your kind words!

  • @tylerdurden9411
    @tylerdurden9411 8 місяців тому +1

    I really like your explanation very clear and with examples. Thank you so much men!!!!!! I almost forget your english speaking is so good thank you also for that, because is an extra effort and that give you extra points also!!!!

  • @equiwave80
    @equiwave80 3 роки тому +1

    Excellent video. Simplest explanation of OLTP, OLAP, ETL & Data warehouse

  • @MarkBelain
    @MarkBelain 3 роки тому +1

    At first, I disliked the video because I felt it was skirting around the actual core topic of ETL”
    Right around 5:30, though, everything you said came together and this just became one of the most elegant ways to explain ETL that I’ve seen so far.
    Suffice it to say, I went back and put a like back on the video.

    • @codebasics
      @codebasics  3 роки тому

      Ha ha.. thanks mark for showing Patience 👍😊

  • @Jean-PaulCh
    @Jean-PaulCh 3 роки тому

    I just wanted to say that I was really impressed by the way you explained this. Keep it up.

  • @sowmya6471
    @sowmya6471 10 місяців тому

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

  • @hall_of_fame_suraj
    @hall_of_fame_suraj Рік тому

    really great explanation know one is not in youtube that they are properly cleared this topic with the right examples, but you have done.

  • @ashcb77
    @ashcb77 2 роки тому +3

    Wonderful exaplanation Mr Dhawal... Quite impressive .. I'm a new aspiriant of Data Analytics serching for genuien content for understaing the process of Data Analytics, which landed me on ur channle. Thanks for imparting ur valuable knowledge.

  • @tejrupsai7396
    @tejrupsai7396 3 роки тому +1

    The best explanation that I have ever seen it's very simple to understand and most of the information has been explained within few minutes.

  • @krishnachaitanya5965
    @krishnachaitanya5965 3 роки тому

    This is the best video I've seen so far. Great content for beginners.

  • @anika7277
    @anika7277 Рік тому

    Very Clear , Concise and to the point explanation. Thanks so much !!!!

  • @MohamedSaid-ob3ug
    @MohamedSaid-ob3ug 2 роки тому

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

  • @trikavyam8101
    @trikavyam8101 Рік тому

    Very good explanation.....before this video i had lot of confusion on elt but now its very clear...thanks

  • @sumanthaddala6924
    @sumanthaddala6924 9 місяців тому

    Thank you very much sir🙏, the concept which you've explained is crystal clear, very calm and on point without fogging brain.

  • @sohelakhtar8044
    @sohelakhtar8044 Рік тому

    So precise, accurate and smooth.
    Cleared the concept very well

  • @bouihabdelouahed1579
    @bouihabdelouahed1579 Рік тому

    I love the way you explained it all.
    Very much appreciated mate.

  • @boppanibhanuprasad4612
    @boppanibhanuprasad4612 3 роки тому +1

    Simple crisp and clear. loved it!

  • @SurajKumar-by9fh
    @SurajKumar-by9fh 2 місяці тому +1

    Just had an online interview in Paytm and they asked what's OLTP & OLAP.... I said I didn't know because I had no idea what it was but I knew what ETL is.....man I feel dumb🥹😭

  • @tejas4054
    @tejas4054 Рік тому

    Best clarity no one is better than you

  • @shreyasingh550
    @shreyasingh550 2 роки тому

    One of the best explained videos on ETL so far. Looking forward to learning more from your videos

  • @saikatnextd
    @saikatnextd 2 роки тому

    Wow !! Even a non techie like me can understand……awesome is a understatement !! Keep up the great work 👍👍

  • @ravikishorergajavalli
    @ravikishorergajavalli 3 роки тому

    Nice explanation. Non IT guy can easily understand the basic information about all these terminology. Thank you for sharing your knowledge.

  • @readerko
    @readerko 3 роки тому +2

    Thanks for this video, you are a very good teacher, it was really fast and simple to understand. Great work man. Greetings from Slovakia

  • @saumyasrivastava4064
    @saumyasrivastava4064 2 роки тому

    10 out of 5 STAR for the explanation and the way you taught it. Compelled me to comment for the first time on any educational content.
    I really feel a teacher, a mentor should understand his audience first, talking about things in your jargons/terminology is easy but explaining it in a way where even a non-technical person can understand the business value behind it, is RARE. You absolutely did that! The way you started it with business case, added crisp context before bringing the jargon and then connected it all, was just super awesome. Please keep up the good work!
    Inspiring!
    P.S. Sorry, I understand the efforts that goes behind making these videos but mostly other videos (of other people) are like; you extract from database, you transform and then you load for analytical purpose - this is ETL. Such videos should add a disclaimer - intended for audience with tech background.

  • @abhishekbhatia651
    @abhishekbhatia651 3 роки тому +1

    BEST EXPLANATION EVER! Thankyou :)

  • @shuaidongyu4010
    @shuaidongyu4010 7 місяців тому

    The best explanation on data warehouse. Thx!

  • @danalex2991
    @danalex2991 2 роки тому

    Best video for OLAP and OLTP concepts.

  • @jayasriravisankar4059
    @jayasriravisankar4059 Рік тому

    Awesome video, As everyone said , i have watched several videos and several documents to learn these topics, None of them have cleared all my queries on my mind in regards to these terms, but you made me to understand it so easily. Thank you

  • @rajeshbhosale2008
    @rajeshbhosale2008 Рік тому

    Excellent video on the simplification of confusing jargons of the database domain! Thanks 👍🏻

  • @UKXcalibur
    @UKXcalibur 7 місяців тому

    that war really clarifying, you explained the best!

  • @ahmadmarzodandy6054
    @ahmadmarzodandy6054 6 місяців тому

    Amazingly cristal clear! Thank you so much for creating this video

  • @pjthamg
    @pjthamg 2 роки тому

    Best explanation on YT

  • @yashmathur5609
    @yashmathur5609 2 роки тому

    wow ,your teaching techniques are really good .. straight to mind concept

  • @Call-me-Avi
    @Call-me-Avi 2 роки тому

    This was the most awesome explanation i found. Thank you. I finally understand.

  • @muskanvij4811
    @muskanvij4811 4 роки тому

    This is one of the best video on this topic , I have come across.

  • @wallysonruan4246
    @wallysonruan4246 Рік тому +1

    As some already said, I've watched lots of video before landing here but you were the one to make me go "mind blowing". Thanks a lot, man!
    Special compliments for the way you designed your representation of the pipeline as well as the difference between OLTP and OLAP!

  • @MubQ10
    @MubQ10 3 роки тому +1

    hey man ! great stuff !! much better than the lecturers that i have here in the UK

  • @amritgurung3520
    @amritgurung3520 3 роки тому

    this is what i wanted to know for few days. Amazing video. Really appreciated

  • @AnilKumar-pb7eo
    @AnilKumar-pb7eo 3 роки тому

    Sir excellent explanation 👏👌 now I got clarity

  • @rssinghtoor
    @rssinghtoor 3 роки тому +1

    Amazing, just amazing Tutorial!…subscribed your channel right away. Needed this for my work purpose. Thank you so much 🙏

  • @minute_syntax
    @minute_syntax 2 роки тому

    Great video..never seen such a simple way of explaining ETL

  • @Pablo-zf7ml
    @Pablo-zf7ml 2 роки тому

    Excellent video, short, clear and very informative....thanks a lot great job

  • @AnkitChoudhary-st2is
    @AnkitChoudhary-st2is 3 роки тому

    BEST OVERVIEW VIDEO, BIG THANKSS!

  • @sambitpati6129
    @sambitpati6129 2 роки тому

    what a video just♥ wow♥ explanation !!!👏👏👏👏👏👌👌👌🙌🙌🙌🙌

  • @emamulmursalin9181
    @emamulmursalin9181 3 роки тому

    Simple, directly to the actual point and useful .....

  • @viveksivalingam9181
    @viveksivalingam9181 4 роки тому +1

    This is the best to the point video. Cheers 👌

  • @hanmuster
    @hanmuster 4 роки тому +4

    This is a very vivid example!

  • @thatguyadarsh
    @thatguyadarsh 5 років тому +2

    Very easily explained... Awesome

    • @JainmiahSk
      @JainmiahSk 5 років тому

      Hi Adarsh, thanks for complement. Checkout more videos from playlist. Keep sharing CodeBasics videos to your friends as #ImCodeBasicsMember

  • @mohammadfaizanmadgaonwala51
    @mohammadfaizanmadgaonwala51 2 роки тому

    The best video with examples
    Thank you so much

  • @sadreddude
    @sadreddude 3 роки тому

    Nice clean, direct Olap description with hi quality visuals. Good content, thank you ✔️ will check your other videos 🤓

  • @gsmoon97
    @gsmoon97 3 роки тому

    superb explanation 🔥🔥🔥 couldn't have broken it down any better than this

  • @jessechichi5609
    @jessechichi5609 11 місяців тому

    i love how you have explained this, thank you.

  • @sinan6212
    @sinan6212 2 роки тому

    Thank you for the clear and simple explanation

  • @shahariarsarkar3433
    @shahariarsarkar3433 8 місяців тому

    Please upload a video on implementing a data warehouse practically using the tools like teradata etc.

  • @pratikkumarsingh8114
    @pratikkumarsingh8114 2 роки тому

    well explained, cleared all the concepts, Thank you sir!!

  • @yeahnahshityeah
    @yeahnahshityeah 2 роки тому

    This is a perfect explanation! Thank you

  • @vaijayantigulve4883
    @vaijayantigulve4883 Рік тому

    Very clear and concise...!! Thank you...

  • @louvierejacques
    @louvierejacques 2 роки тому

    thank you so much, this is excellent! subscribed, now i'm off to check out your courses. really, really great.

  • @anupriyaap5461
    @anupriyaap5461 3 роки тому +1

    Awesome 🙂 Sir .. video is like " Simple, Short and Clear", that all I want.. thank you for sharing 👍

  • @lucashonore6941
    @lucashonore6941 11 місяців тому

    Do you have interview questions for data governance? I like the way you explain.. You're definitely a great teacher.

  • @hassanosseiran6405
    @hassanosseiran6405 8 місяців тому

    Super well explained, great work!

  • @ad3
    @ad3 2 роки тому

    Clean and simple explanation. Thank you.

  • @ashish31416
    @ashish31416 2 роки тому

    You inherited teaching skills from parents, I am more than sure now. 😄

  • @Muskan-wi2zz
    @Muskan-wi2zz 2 роки тому

    That was a quite precise and clear explanation. It would have been even better if some hands on was also shown at the end.

  • @nikitakhandelwal872
    @nikitakhandelwal872 3 роки тому

    Explained in a very simple manner.. Thanks a lot!

  • @roshanramesh7307
    @roshanramesh7307 2 роки тому

    Beautifully explained. Thank you

  • @tushararora6665
    @tushararora6665 2 роки тому

    I am amazed,it was so easy to understand,Thanks a ton.

  • @reggied1811
    @reggied1811 4 роки тому +2

    Very good explanation. Helped me tremendously. Thanks!

  • @shubhamgophane5414
    @shubhamgophane5414 2 роки тому

    Best explanation! Thank you🙏🏻

  • @esraaykut4022
    @esraaykut4022 Рік тому

    Thank you so much such an simple and great explanation!

  • @adityasingh-vc7wf
    @adityasingh-vc7wf 3 роки тому +3

    Just one word....WOW

  • @akash-kaha-hai
    @akash-kaha-hai 4 роки тому +1

    Well explained. You're a good teacher.

  • @madanchanti
    @madanchanti 3 роки тому

    Best explanation with good understanding in less time. Thanks !

  • @bhavanimaddela7252
    @bhavanimaddela7252 3 роки тому

    Thanks for the video. Keep rocking with your videos.

  • @anthonysekgota3224
    @anthonysekgota3224 3 роки тому

    The best definition Ever

  • @srb1855
    @srb1855 2 роки тому

    excellent & concise explanation.