What is ETL (Extract, Transform, Load)?

Sdílet
Vložit
  • čas přidán 31. 07. 2024
  • Learn more about ETL → ibm.biz/learn-about-etl
    Blog Post: ELT vs. ETL: What's the Difference? → ibm.biz/elt-vs-etl-blog-post
    Check out Cloud Databases on IBM Cloud → ibm.biz/IBMCloudDBs
    Wondering what ETL is all about? Jamil Spain explains what ETL is and what it can do for you to improve your data analysis and productivity.
    Want to learn about database options? Check out the videos below:
    DBaaS: • What is DBaaS? Should ...
    SQL vs NoSQL: • SQL vs. NoSQL: What's ...
    CouchDB: • CouchDB Explained
    MongoDB: • What is MongoDB?
    Redis: • What is Redis?
    Get started on IBM Cloud at no cost → ibm.biz/free-tier-IBM-Cloud
    Subscribe to see more videos like this in the future → ibm.biz/subscribe-now
    #ETL #Databases #DatabaseManagement
  • Věda a technologie

Komentáře • 43

  • @Padishascandal
    @Padishascandal Před 2 lety +77

    Just have to say, the fact that you flawlessly wrote everything backwards perfectly was amazing 🤩

    • @dryjhna
      @dryjhna Před rokem +1

      i am stunned

    • @jaredwsavage
      @jaredwsavage Před rokem +23

      He's writing normally and then flipping the image. Nice trick though.

    • @mabb6969
      @mabb6969 Před rokem +1

      Is he writing on a mirror? Looks very nice!

    • @odosmatthews664
      @odosmatthews664 Před 5 měsíci

      @@jaredwsavage his watch and wedding band are on his left though.

  • @alokdand1712
    @alokdand1712 Před rokem +1

    Loved the content and the video. Especially the way it was presented and put together. Great job!!!

  • @user-fl1ip3gr1f
    @user-fl1ip3gr1f Před rokem +3

    Amazing explanation. Simple and Concise to absorb.

  • @bigstone8612
    @bigstone8612 Před 2 lety +1

    Thank you for the explanation, Jamil!

  • @xXHelsingGamingXx
    @xXHelsingGamingXx Před rokem

    Looking for this!!! and I am sure I am going to Enjoy it.

  • @sheiladikshit5110
    @sheiladikshit5110 Před rokem +1

    excellent explanation! thank you for putting this into plain english 👍

  • @sakshamgarg9046
    @sakshamgarg9046 Před 2 lety +15

    Very well timed - just what I needed to know

    • @IBMTechnology
      @IBMTechnology  Před 2 lety +2

      We're glad this was useful to you! Thanks for watching, Saksham! 👍

  • @donngg
    @donngg Před 3 měsíci

    Thank you very much sir, great explanation, very interesting topic indeed.

  • @nsambataufeeq1748
    @nsambataufeeq1748 Před 2 lety +1

    You have a good vibe

  • @raheelzamir2597
    @raheelzamir2597 Před rokem +1

    Alright! I have got few knowledge about ETL from this video, for advance level or practical what should I do? thank for your support buddy

  • @ThinhLe-eh9re
    @ThinhLe-eh9re Před rokem

    Thanks for your sharing bro's

  • @GodIsWithin3
    @GodIsWithin3 Před 9 měsíci

    Awesome, thanks!

  • @pratikkumarsingh8114
    @pratikkumarsingh8114 Před rokem

    Thank you sir!!!

  • @honeybunny9977
    @honeybunny9977 Před 2 lety

    What other AWS services use ETL? Other than data warehouse.

  • @codymckinney4934
    @codymckinney4934 Před rokem

    super gifted to be writing like that.

  • @ExplainedThroughRap
    @ExplainedThroughRap Před 2 lety

    Really good information I just dropped a rap about project management on my channel, your content has been a great source of education for me, thank you very much

  • @HokYanPun-pc7wn
    @HokYanPun-pc7wn Před 5 měsíci

    Why call "analysis of data" consolidation though? What does it really mean?

  • @abdulraheemshahzad5886

    Great video but you didn't explained "productivity -> manual = no"

  • @CaribouDataScience
    @CaribouDataScience Před rokem

    What is the difference between ETL and EDA?

    • @adiseshyeragudi4275
      @adiseshyeragudi4275 Před 11 měsíci

      ETL - Extract, Transform, Load. Usually the process described in the video. EDA - Exploratory Data Analysis. This is generally the approach to understand the data better/find general patterns

  • @happytux77.68
    @happytux77.68 Před rokem

    I'm the only one impressed by the way he is writing in a transparent board??

  • @Graanvlok
    @Graanvlok Před 2 lety +1

    Where do you "load" it to?

    • @joshalton6968
      @joshalton6968 Před 2 lety +2

      Whatever you'd use to view the data. Things like data dashboard tech like Power BI or Tableau or Looker.

    • @PAULA-bi6fy
      @PAULA-bi6fy Před rokem

      it can be a dataware

  • @DanWatson2012
    @DanWatson2012 Před měsícem

    Are you writing backwards? :-O

  • @madhavkwatra5888
    @madhavkwatra5888 Před 26 dny

    Everyone on IBM videos just comments and commends your ability to write backwards. But they dont know the light board techonology behind it. 😂

  • @anonomyss
    @anonomyss Před 8 měsíci

    Took me half the video to realize you were writing backwards wow

    • @IBMTechnology
      @IBMTechnology  Před 8 měsíci

      See ibm.biz/write-backwards for how it was done.

  • @Flankymanga
    @Flankymanga Před 2 lety +32

    Dude this whiteboard sessions was totally useless.... I mean if you need to explain some acronyms you don't have to do artistic "painting" to do that.... Write all the terms ahead of the session on the board and then deep dive into each one during the recording session or explain the concepts by drawing diagrams. Things like where ETL is used - a simple practical case, how is it typically done? In other words paint a real life use case picture for ETL.

    • @IBMTechnology
      @IBMTechnology  Před 2 lety +5

      Thanks for taking the time to give us your input, you make a good point - we'll work on a more dynamic use of graphics and use-case examples.

    • @djozerwright1206
      @djozerwright1206 Před rokem +6

      @@IBMTechnology I’m a software engineer. This was helpful to me. I and being trained on the job to help other teams within my organization with data engineering, ETL, etc.

    • @JustinLietz
      @JustinLietz Před 3 měsíci

      czcams.com/video/2AN6tCYgWpg/video.htmlsi=-VOhl5tn4eyyHCgK
      I found this video helpful

  • @567goodmusic
    @567goodmusic Před 2 lety +2

    amazing ability to write backwards > ETL
    kappa

  • @powerademonke
    @powerademonke Před rokem

    Talking and writing everything backwards at the same time. Insane.