Watch the intro video

A real-world scenario in the real estate industry

Course curriculum

    1. Introduction to ETL in Python

      FREE PREVIEW

    2. The ETL process

      FREE PREVIEW

    3. Before we begin

      FREE PREVIEW

    4. What we need

    5. Exercises

    6. Exercise structure

    7. Downloading a ZIP file

    8. Exploring a ZIP file

    9. Ask the right questions

    10. Extracting

    11. Reading from a CSV file - part 1

    12. Reading from a CSV file - part 2

    13. Writing to CSV

    14. Downloading the new dataset file from web

    15. Project folder structure

    16. Extract 'em all!

    17. Chapter feedback

    1. SQLAlchemy core components

    2. Engines and Sessions

    3. Table class definition

    4. Columns definition

    5. Price and description

    6. Lower string and date format

    7. Setup base script

    8. Create tables

    9. Transform 'em all!

    1. Date data type definition

    2. Unique key definition

    3. Querying

    4. Insert and delete

    5. Insert operation

    6. Delete operation

    7. Load 'em all!

    1. Sales for Dublin and Cork

    2. First month 2023 sales

    3. Average, max and min functions

    4. Creating the insights view

    5. How many counties?

    6. Create a simple Excel file

    7. Add a table into Excel file

    8. Export monthly insights

About this course

  • $49.00
  • 41 lessons

What you will learn

  • ETL Mastery

    Master building ETL pipelines to efficiently process and analyze data for informed business decisions

  • Data Insights

    Transform raw data into meaningful insights using SQL queries and Excel, driving strategic decision-making

  • Tool Proficiency

    Learn to improve your skills with Python, Docker and SQLAlchemy for advanced data manipulation

Who am I?

Something about me...

Stefano Francavilla

Hi! I'm Stefano, CEO and co-founder of Geowox, a company using AI and big data to value residential properties. In a previous life, I studied Computer Science at the Polytechnic University of Milan while founding a software development company. I worked as a product engineer at Intercom and advised portfolio startups at Growing Capital, a seed investment firm.

FAQ

  • Who is this course for?

    Ideal for data professionals, analysts, and beginners interested in mastering ETL processes and data engineering.

  • What prior knowledge do I need?

    Basic Python and SQL knowledge is helpful, but beginners are welcome.

  • How long is the course?

    Duration varies based on individual pace, designed for flexibility.

  • What will I learn?

    Build and optimize ETL pipelines, transform data into insights, and use tools like SQLAlchemy.

  • Is there hands-on experience?

    Yes, with a real-world project involving a fictional private equity firm.

  • Are there certifications upon completion?

    Yes, a certificate indicating your proficiency in ETL processes and data manipulation.

  • What is the refund policy?

    100% money-back guarantee if you find the course unsatisfactory after completing the first chapter, provided you request a refund within 90 days of enrollment. My goal is to ensure that you find immense value in my learning materials.

Coming soon!

Be the first to learn about the course launch and secure an exclusive 50% discount!

Thank You