ETL using Python: from MySQL to BigQuery (Udemy.com)
A course for supercharged analysts
Created by: Oscar Valles
Last updated April 2026
What you will learn
- Connect to MySQL using Python
- Connect to BigQuery using Python
- ETL data from MySQL to BigQuery using Python
- Setting up their environment to use Python with MySQL and BigQuery
How it compares
Against the other 371 rated Udemy courses in Data Analysis on CourseDuck:
- Rating4.6 out of 5higher than 73% of them
- Reviews915#146 of 372 by number of reviews
- Length3 hoursshorter than 65% of them
- Last updatedApril 2026more recently than 70% of them
Course Description
This is a direct and to the point course that will get you quickly ETL'ing data from MySQL to BigQuery.
The lessons in this course are broken out into short How-Tos. Therefore you can take this course over the weekend and be ready to show off your skills on Monday morning!
Things that we will cover:
Setup
Setting up a GCP Account
Credential and Authentication for security
Python Environment Setup
Extract
Use Python to connect to MySQL
Use Python's pandas to export data
Python library usage for saving files to file paths
Transform
Use Python functions to transform data
Use Python pandas to transform data
Use inline SQL during Extract for data transformation
Load
Use the BigQuery Python library
Connect to BigQuery
Load data to BigQuery
Incremental Loads vs Truncate and Load
Other data handling options during Load
After taking this course, you'll be comfortable with the following pretty cool things:
Connect to MySQL using Python
Learn how to obscure your database credentials so you're not exposing them in your code
Usage of the os module for the purpose of saving files and hard coding fewer things.
Use both Python and the pandas library to transform data on the fly during the Transformation phase of your ETL
Learn how to use GBQ's modules/libraries to make the loading of the data a very easy, straightforward task
Have fun, enjoy and keep growing!
Instructor Details
- 4.6 Rating
915 Reviews
Oscar Valles
As Analytics and Business Intelligence professional, I've had the privilege to apply analytical, technical and business expertise across a variety of domains such Marketing, Customer Success, Research and Development, Retail and Ecommerce.
Each course that I create will be aimed at helping you focus on the key aspects of the technical skills you desire to develop for the purpose of immediate application and personal acclimation.
I'm excited that you are here because it means that you want to grow your career and I want to be the there to help. I'm happy to share my experiences so that your track to success is better than mine! I've been in your shoes and together, we will get you where you want to be.
More Data Analysis courses
Complete neural signal processing and analysis: Zero to hero (2026)
4.8 (2,013 Reviews)
Provider: Udemy
Time: 46.9h
$12.99
Excel for Business Analysts Online Course (2023)
4.8 (636 Reviews)
Provider: Udemy
Time: 9.3h
$74.99
Alteryx Designer Advanced Certification Mega Bundle (2023)
4.8 (468 Reviews)
Provider: Udemy
Time: 16.9h
$69.99
Reviews
By Urvish Devani on 7/6/2025
Explained all basic things accurately. Just want to add feedback here to use windows PC because large portion of learner has windows PC and it will be difficult to follow command and instructions for windows user if instructor is using Mac.
By Amir Syafiq Bin Abu Saiere on 1/25/2025
I don't usually write reviews, but this course is a good and concise course for an introduction to ETL with Python and BigQuery. However, it has the potential to be a better course if the author is willing to polish and update some areas of the course (eg. MySQL connection config / Database plugin for PyCharm / VScode) Hope Oscar takes the reviews into consideration for future courses. I'd be happy to learn from him again
By Rajat Arora on 1/18/2025
Very good course and content is very crisp and easy to understand. Flow is explained in very easy way and I would say overall very good course especially if someone is looking to start how Python will work for ETL. Thank you.
By Andy Bai on 12/29/2024
Thank you so much for the course! It truly helped me gain hands-on experience with ETL, and I found it incredibly valuable. I especially appreciated the bonus lecture and the final thoughts, which offered great recommendations for future career paths. It felt like learning from a friend—engaging, relatable, and supportive. I genuinely appreciate your effort. You are awesome!
By Daniel Neiman on 4/22/2024
Well structured code. I would suggest for a similar future course, to put the rest of the code into funcitons so that learners can get the basics of modular programming. Otherwise, the core concepts were presented clearly and concisely. Very good course for entry-level ETL processing knowledge.
By Onkar Ambuse on 2/11/2024
Course is really great, In under three hours, you will have all of the information you need about ETL utilizing Python and Google's BigQuery. I learnt a lot in his three-hour course, and I appreciate you giving vital information in the last session. These recommendations are truly helpful, and I will utilize them in my career. Thank you so much for producing such an excellent training. I'm waiting for the whole course for ETL developers.
By Anonymized User on 1/21/2024
This course was amazing! The instructor is very knowledgeable and straight to the point. I could get a great idea about what ETL is and actually how to do it! I recommend to everybody who would like to know better about it and have some "hands on" experience.
By ITyDATA LTD on 8/26/2023
ETL using Python: From MySQL to BigQuery is a good introduction to the world of ETL for beginners. The best thing about the course is that the code actually works! The second best thing is that the instructor explains things step by step. One area to improve the course will be to add more examples/case studies. Overall, a great course for Python programmers who want to get hands-on learning experience in ETL development.
By Bucur Emil Constantin on 2/5/2023
The course is what I expected for. I'm giving a 4 out 5 stars review because he didn't put the sql tables in resources to be able to follow, exact step by step, what is he doing. Beside that everything on point. Just be sure you have intermediate knowledge of python because this course is not beginner friendly. Make sure you at least understand how virtual enviroments and some basic libraries like os and pandas work and you are good to go. His explanation are so good and I love when he recaps, also I love that the course is straigth to the point. I recomend taking this course especially if you are a data analyst and want to transition to data/cloud engineer.
By Sai on 9/21/2022
Excellent course, Thoroughly enjoyed while learning ,Highly recommended course for ETL pipelines using python. @Oscar Valles if u have a chance please make the course on ETL pipeline (MYSQL-TO-Google Cloud Storage-BigQuery) using python. It would be very much helpful !!!.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100






