Skip to content
UdemyData AnalysisPaid courseIntermediate levelCertificate

ETL using Python: from MySQL to BigQuery (Udemy.com)

A course for supercharged analysts

Created by: Oscar Valles

Last updated April 2026

icon
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

icon
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!

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

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.

icon
More Data Analysis courses

Free

$79.99

$12.99

$74.99

$69.99

Free

icon
Reviews

4.6

915 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

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 !!!.

Showing all 10 reviews on CourseDuck

Read all 915 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100