In this video you will learn how to perform the ETL (Extract, Transform and Load) process in MySQL Workbench. With the help of a given dataset you will learn to extract the desired data, transform it as per the given objective and finally load or save the transformed data using SQL queries.
ETL is a commonly asked concept in Data Science Interviews. Give this video a try to learn the ins and outs of Extract, Transform and Load process.
00:00 - Introduction
00:22 - What is ETL (Extract, Transform, Load)?
01:06 - How to perform ETL in SQL?
02:04 - Extract the information in SQL
05:37 - How to set the Default Database in MySQL?
06:47 - Extract Transform Load process for a given dataset
07:56 - SQL Query for Extract process
08:54 - SQL Query for Transforming the data
12:31 - How do we load the data in MySQL?
13:53 - SQL query Execution Sequence
18:04 - Create Table in MySQL Workbench
26:05 - Conclusion
#etl #sqlforbeginners #extractdata #transformdata #loaddata
❓Interested in a Data Science or Data Engineering career? Check out the Ivy Pro School’s top ranked Nascomm, Govt. of India and IBM accredited Data Science and Data Engineering courses: https://ivyproschool.com/
❓Why should you learn Data Science today? https://www.youtube.com/watch?v=pQFwcd-r-Pg
❓Are you a Fresher? Watch this video to know the Data Science Journey for Freshers: https://www.youtube.com/watch?v=Xx4CcAEUV2c
✅Don’t forget to Subscribe to Ivy Pro School’s YouTube Channel: https://www.youtube.com/channel/UCDxAYHFZPY3508aftqW6Grg?sub_confirmation=1
✅Learn from Ivy Pro School’s Data Science and Data Engineering Students’ Success Stories : https://www.youtube.com/playlist?list=PL6ajVQ6jyjvCXW4Xfcn_XYXsSzfggBsW1
Liked the video? Check out below more playlists on Data Science and Data Engineering learning tutorial, alumni interview experiences, live data science case studies,etc:
⏩Students Share Interview Experiences- https://youtube.com/playlist?list=PL6ajVQ6jyjvBne1iy2SkQs_g-E4Ee-ehn
⏩Data Cleaning using excel- https://youtube.com/playlist?list=PL6ajVQ6jyjvDOEdgM1TM_6zi8i9vkd6Ih
⏩SQL Interview questions solved in Hindi - https://youtube.com/playlist?list=PL6ajVQ6jyjvCsVxAVALBuYL0g9aKFVhkE
⏩PowerBI Tutorials - https://youtube.com/playlist?list=PL6ajVQ6jyjvC3asMS9NKP48_SfoadiYgw
⏩Industry case studies and projects by students - https://youtube.com/playlist?list=PL6ajVQ6jyjvBNzNS9GBB1QfiNzRJ--F1t
⏩Data Science for Beginners - https://youtube.com/playlist?list=PL6ajVQ6jyjvAgu1bLmexOfYgW7DaJ_3te
⏩Excel VBA tutorial - https://youtube.com/playlist?list=PL6ajVQ6jyjvAQmJhulbREz7JYE8yAuZCB
⏩Excel Tutorials by Eeshani Agrawal - https://youtube.com/playlist?list=PL6ajVQ6jyjvDWWeqOfgt4UN1dhnxw9IOY
⏩Tableau Tutorials by Eeshani Agrawal - https://youtube.com/playlist?list=PL6ajVQ6jyjvBQFKXzpMbhdBp1Lb3zgPvl
For more updates on courses and tips don’t forget to follow us on:
- Instagram: https://www.instagram.com/ivyproschool/
- LinkedIn: https://www.linkedin.com/school/ivy-professional-school/
- Facebook: https://www.facebook.com/ivyproschool/
- Twitter: https://twitter.com/ivyproschool/
- Telegram: https://t.me/learndswithexperts
Want to take a Data Science Course with Ivy Professional School - visit us at https://ivyproschool.com You can call us at +91-7676882222 or mail to [email protected].