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

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 มิ.ย. 2024
  • 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.
    Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
    #ETL #DataWarehouse #OLAP #OLTP
    🌎 My Website For Video Courses: codebasics.io/?...
    Need help building software or data analytics and AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
    #️⃣ Social Media #️⃣
    🔗 Discord: / discord
    📸 Dhaval's Personal Instagram: / dhavalsays
    📸 Codebasics Instagram: / codebasicshub
    🔊 Facebook: / codebasicshub
    📱 Twitter: / codebasicshub
    📝 Linkedin (Personal): / dhavalsays
    📝 Linkedin (Codebasics): / codebasics
    🔗 Patreon: www.patreon.com/codebasics?fa...

ความคิดเห็น • 401

  • @codebasics
    @codebasics  2 ปีที่แล้ว +4

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

  • @mohammadsyariefali2978
    @mohammadsyariefali2978 3 ปีที่แล้ว +70

    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 ปีที่แล้ว +5

      You're very welcome! Glad it was helpful!

  • @gracechan3039
    @gracechan3039 3 ปีที่แล้ว +111

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

    • @codebasics
      @codebasics  3 ปีที่แล้ว +4

      Glad it was helpful!

  • @sumitpatil9648
    @sumitpatil9648 2 ปีที่แล้ว +29

    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  2 ปีที่แล้ว +2

      👍☺️

    • @anika7277
      @anika7277 ปีที่แล้ว

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

  • @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.

    • @codebasics
      @codebasics  3 ปีที่แล้ว +1

      Glad it was helpful!

  • @p.sarankumarpatro9773
    @p.sarankumarpatro9773 3 ปีที่แล้ว +4

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

  • @flamboyantperson5936
    @flamboyantperson5936 4 ปีที่แล้ว +2

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

  • @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!!

  • @jithindas6084
    @jithindas6084 3 ปีที่แล้ว +6

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

    • @codebasics
      @codebasics  3 ปีที่แล้ว +1

      Great to hear!

  • @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.

  • @suck-myballs1152
    @suck-myballs1152 4 หลายเดือนก่อน +1

    Man, this was BEAUTIFUL!!! A real-world example makes all the difference!!

  • @user-ll5bh6jf6p
    @user-ll5bh6jf6p 5 หลายเดือนก่อน

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

  • @tylerdurden9411
    @tylerdurden9411 หลายเดือนก่อน +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!!!!

  • @shreyasingh550
    @shreyasingh550 ปีที่แล้ว

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

  • @shuaidongyu4010
    @shuaidongyu4010 วันที่ผ่านมา

    The best explanation on data warehouse. Thx!

  • @boppanibhanuprasad4612
    @boppanibhanuprasad4612 2 ปีที่แล้ว

    Simple crisp and clear. loved it!

  • @Jean-PaulCh
    @Jean-PaulCh 2 ปีที่แล้ว

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

  • @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.

  • @krishnachaitanya5965
    @krishnachaitanya5965 2 ปีที่แล้ว

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

  • @sahilkadu5409
    @sahilkadu5409 2 ปีที่แล้ว +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.

    • @codebasics
      @codebasics  2 ปีที่แล้ว

      👍👍🤗🙏

  • @emamulmursalin9181
    @emamulmursalin9181 3 ปีที่แล้ว

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

  • @bouihabdelouahed1579
    @bouihabdelouahed1579 10 หลายเดือนก่อน

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

  • @abhishekbhatia651
    @abhishekbhatia651 2 ปีที่แล้ว +1

    BEST EXPLANATION EVER! Thankyou :)

  • @anika7277
    @anika7277 ปีที่แล้ว

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

  • @readerko
    @readerko 2 ปีที่แล้ว +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

  • @mohammadfaizanmadgaonwala51
    @mohammadfaizanmadgaonwala51 ปีที่แล้ว

    The best video with examples
    Thank you so much

  • @rajeshbhosale2008
    @rajeshbhosale2008 10 หลายเดือนก่อน

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

  • @anirbanc88
    @anirbanc88 ปีที่แล้ว

    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 2 ปีที่แล้ว +2

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

  • @amritgurung3520
    @amritgurung3520 2 ปีที่แล้ว

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

  • @roshanramesh7307
    @roshanramesh7307 2 ปีที่แล้ว

    Beautifully explained. Thank you

  • @yeahnahshityeah
    @yeahnahshityeah ปีที่แล้ว

    This is a perfect explanation! Thank you

  • @vaijayantigulve4883
    @vaijayantigulve4883 7 หลายเดือนก่อน

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

  • @rssinghtoor
    @rssinghtoor 2 ปีที่แล้ว +1

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

  • @MohamedSaid-ob3ug
    @MohamedSaid-ob3ug 2 ปีที่แล้ว

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

  • @danyalimtiaz6925
    @danyalimtiaz6925 2 ปีที่แล้ว

    Awesome! Simple and Clear. Thank you so much.

  • @vanshverma2115
    @vanshverma2115 2 หลายเดือนก่อน

    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.

  • @jessechichi5609
    @jessechichi5609 3 หลายเดือนก่อน

    i love how you have explained this, thank you.

  • @johnblackstock298
    @johnblackstock298 3 ปีที่แล้ว +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  3 ปีที่แล้ว +1

      Glad it helped John

    • @rayray7244
      @rayray7244 2 ปีที่แล้ว +3

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

  • @sinan6212
    @sinan6212 ปีที่แล้ว

    Thank you for the clear and simple explanation

  • @ravikishorergajavalli
    @ravikishorergajavalli 2 ปีที่แล้ว

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

  • @gsmoon97
    @gsmoon97 2 ปีที่แล้ว

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

  • @Call-me-Avi
    @Call-me-Avi 2 ปีที่แล้ว

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

  • @tejas4054
    @tejas4054 ปีที่แล้ว

    Best clarity no one is better than you

  • @nishaprabhudesai2714
    @nishaprabhudesai2714 2 ปีที่แล้ว

    Thank you for sharing it so simply...makes it easy to understand!

  • @AnkitChoudhary-st2is
    @AnkitChoudhary-st2is 2 ปีที่แล้ว

    BEST OVERVIEW VIDEO, BIG THANKSS!

  • @esraaykut4022
    @esraaykut4022 4 หลายเดือนก่อน

    Thank you so much such an simple and great explanation!

  • @Pablo-zf7ml
    @Pablo-zf7ml 2 ปีที่แล้ว

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

  • @equiwave80
    @equiwave80 3 ปีที่แล้ว +1

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

    • @codebasics
      @codebasics  3 ปีที่แล้ว

      Glad it was helpful!

  • @danalex2991
    @danalex2991 ปีที่แล้ว

    Best video for OLAP and OLTP concepts.

  • @saikatnextd
    @saikatnextd 2 ปีที่แล้ว

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

  • @MubQ10
    @MubQ10 3 ปีที่แล้ว +1

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

  • @19belaz
    @19belaz 5 หลายเดือนก่อน

    Thanks. Very clear explanations!

  • @harshadmhatre9434
    @harshadmhatre9434 ปีที่แล้ว

    sirji best explanation Thank u

  • @mindlospikiri7723
    @mindlospikiri7723 ปีที่แล้ว +1

    The best explanation on youtube

  • @justwatching2960
    @justwatching2960 2 ปีที่แล้ว

    It is so clear and well explained. Thanks a lot.

  • @metaprog46and2
    @metaprog46and2 2 ปีที่แล้ว

    Informative yet succinct. Nicely done.

  • @pratikkumarsingh8114
    @pratikkumarsingh8114 ปีที่แล้ว

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

  • @harshithatm6369
    @harshithatm6369 2 ปีที่แล้ว

    Thank you for keeping it simple and covering all necessary topics.

    • @codebasics
      @codebasics  2 ปีที่แล้ว

      Glad it was helpful!

  • @sumanthaddala6924
    @sumanthaddala6924 2 หลายเดือนก่อน

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

  • @madhuratatkari8405
    @madhuratatkari8405 10 หลายเดือนก่อน

    Thanks for simple explanation.

  • @srb1855
    @srb1855 2 ปีที่แล้ว

    excellent & concise explanation.

  • @abhishekms7407
    @abhishekms7407 3 หลายเดือนก่อน

    Very Good Explanation .Thank you.

  • @hassanosseiran6405
    @hassanosseiran6405 หลายเดือนก่อน

    Super well explained, great work!

  • @lcsmrt
    @lcsmrt 2 ปีที่แล้ว

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

    • @codebasics
      @codebasics  2 ปีที่แล้ว

      Glad you liked it!

  • @sowmya6471
    @sowmya6471 3 หลายเดือนก่อน

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

  • @gwizdeq
    @gwizdeq ปีที่แล้ว

    Best explanation on YT

  • @viveksivalingam9181
    @viveksivalingam9181 3 ปีที่แล้ว

    This is the best to the point video. Cheers 👌

  • @blackmayza1
    @blackmayza1 2 ปีที่แล้ว

    Thank you this was so well explained.

  • @ad3
    @ad3 2 ปีที่แล้ว

    Clean and simple explanation. Thank you.

    • @codebasics
      @codebasics  2 ปีที่แล้ว

      Glad it was helpful!

  • @louvierejacques
    @louvierejacques 2 ปีที่แล้ว

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

  • @oumaymaredissi5213
    @oumaymaredissi5213 6 หลายเดือนก่อน

    great video ! thank you for the clear explanation

  • @gnanasuriyanramachandran9895
    @gnanasuriyanramachandran9895 2 ปีที่แล้ว

    Simple, neat and clear explanation. Thank you!!

    • @codebasics
      @codebasics  2 ปีที่แล้ว

      🙏🙏👍👍

  • @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

  • @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.

  • @abdelrahmanabumeree3903
    @abdelrahmanabumeree3903 10 หลายเดือนก่อน

    thanks a lot , useful video explain the main purpose of the ETL

  • @ganeshnmandape3025
    @ganeshnmandape3025 2 ปีที่แล้ว

    Very precise and clear. Thank you

  • @sohelakhtar8044
    @sohelakhtar8044 ปีที่แล้ว

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

    • @codebasics
      @codebasics  ปีที่แล้ว

      Glad it was helpful!

  • @raniakaabar136
    @raniakaabar136 2 ปีที่แล้ว

    you have clarified many things so thank you

  • @alykhalil1397
    @alykhalil1397 ปีที่แล้ว

    great and simple explanation, Thank you :)

  • @sangameshviraktamath6291
    @sangameshviraktamath6291 4 หลายเดือนก่อน

    Thank you very much, clear understanding

  • @bhavanimaddela7252
    @bhavanimaddela7252 2 ปีที่แล้ว

    Thanks for the video. Keep rocking with your videos.

  • @AnilKumar-pb7eo
    @AnilKumar-pb7eo 2 ปีที่แล้ว

    Sir excellent explanation 👏👌 now I got clarity

  • @shenghuipeng5081
    @shenghuipeng5081 3 ปีที่แล้ว

    So well explained! Helped to clarify a lot of my confusion previously!

  • @skh.visuals
    @skh.visuals 2 ปีที่แล้ว

    what a wonderful video thanks a lot it was so informative !!

  • @shubhamgophane5414
    @shubhamgophane5414 2 ปีที่แล้ว

    Best explanation! Thank you🙏🏻

  • @navinsiriwardena6635
    @navinsiriwardena6635 7 หลายเดือนก่อน

    Excellent explanation, on point !!!

  • @marwaneboudraa9917
    @marwaneboudraa9917 2 ปีที่แล้ว

    Great Explanation Thank you

  • @trikavyam8101
    @trikavyam8101 11 หลายเดือนก่อน

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

  • @madanchanti
    @madanchanti 2 ปีที่แล้ว

    Best explanation with good understanding in less time. Thanks !

  • @mahmudhasan1503
    @mahmudhasan1503 2 ปีที่แล้ว

    Wonderfully explained with easily understandable example. Thank you for sharing your knowledge.

    • @codebasics
      @codebasics  2 ปีที่แล้ว +1

      Glad it was helpful!

  • @reggied1811
    @reggied1811 3 ปีที่แล้ว +2

    Very good explanation. Helped me tremendously. Thanks!

  • @Alebobb
    @Alebobb 2 ปีที่แล้ว

    This helped me a lot, thanks!

  • @ashcb77
    @ashcb77 ปีที่แล้ว +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.

  • @nikitakhandelwal872
    @nikitakhandelwal872 2 ปีที่แล้ว

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

    • @codebasics
      @codebasics  2 ปีที่แล้ว

      Glad it was helpful!

  • @timothyjstrong
    @timothyjstrong 3 ปีที่แล้ว

    Excellent video! Thank you very much

  • @allan459415
    @allan459415 4 หลายเดือนก่อน

    Very informative, thanks a lot

  • @thatguyadarsh
    @thatguyadarsh 4 ปีที่แล้ว +2

    Very easily explained... Awesome

    • @JainmiahSk
      @JainmiahSk 4 ปีที่แล้ว

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

  • @jianlu1908
    @jianlu1908 2 ปีที่แล้ว

    Very helpful and great explanation!

  • @sambitpati6129
    @sambitpati6129 2 ปีที่แล้ว

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