Scratch the image to get a discount on your course. You'll be able to apply the coupon at checkout.

5.0 /5
(32)

84
Bienvenidos al curso de ETL con Python!
Cómo Sacarle el Máximo Partido al Curso
Aprende con Amigos a través de Discord
Materiales del curso
Toma notas de tu curso en tiempo real en Frogames Formación
Presentación del módulo
Presentación del tema
¿Qué vas a aprender?
Metodología del curso
El contexto general
Introducción a los servicios cloud
Introducción a los sistemas de gestión empresariales
Presentación del tema
Introducción al concepto de ETL
ETLs vs ELTs
El proceso de diseño de una ETL
Extract / Extracción
Transform / Transformación
Load / Carga
Pipelines, flows y ETLs
Orquestración y automatización de pipelines
Casos de uso y mercado
Presentación del módulo
Introducción al caso
El objetivo
Los retos
Presentación del módulo
Introducción a Prefect
Introducción a la arquitectura y componentes de Prefect
Introducción a Prefect Core
Refresco: Python en paradigma Object Oriented Programming (OOP)
Refresco: Python para análisis de datos. NumPy & Pandas.
Flows y tasks
Creando tasks de Prefect
Implementando Flows
Flows y tasks: scripting
Presentación de las primeras prácticas
Práctica 1.1: Hello World
Práctica 1.2: Primera ETL (I)
Presentación del tema
Scheduling/programación de los flows
Scheduling simple
Scheduling complejo
Particionado de datos
Calidad de datos
Manejo de errores
Trazabilidad
Documentación
Práctica 2: ETL (II)
Apunte
Presentación del tema
Orquestración y administración centralizada de flows
Prefect Agent
Proyectos y equipos
Vinculando agentes y registrando flows en Prefect Cloud
Control de versiones de los flows
Secretos y parámetros
Práctica 3: ETL en Prefect Cloud
Presentación de los bonus
Expresiones Regulares en Python
Práctica: Extrayendo ocurrencias de un patrón desde un texto
Práctica: Extrayendo ocurrencias de un patrón desde un texto (correción)
Web scraping en Python
Código para la práctica
Práctica: Obteniendo datos desde páginas web mediante webscraping
Presentación del módulo
Presentación del tema
APIs REST
Ficheros JSON en Python para el análisis de datos
Bases de datos
Recursos cloud
Introducción al entorno de desarrollo y definición de la ETL
Libreta Jupyter con el enunciado del caso
Extract
Transform
Nota sobre los recursos cloud
Load (I): creando nuestra base de datos SQL
Load (II): desarrollando la conexión a la base de datos
IMPORTANTE: correccion del codigo del caso
Registro en Prefect Cloud y programación
Importando datos a Python desde SQL para su posterior tratamiento o análisis
Monitorizando las ejecuciones de los flows
Eliminando los recursos cloud que hemos generado
Hemos terminado una aventura juntos, ¡pero vamos a por la siguiente!

instructor

5.0 /5
(32)

  • Avatar
    Santiago
    (5)
    Clear explanations. Easy-to-follow course. I recommend it

  • Avatar
    Jackeline
    (5)
    Clear, practical, and with real ETL examples

  • Avatar
    Silvana
    (5)
    Data transformation is no longer a headache

    Now I handle large volumes of data in Python without feeling lost. It gave me tools I use almost daily in my work.

  • Avatar
    Rosa
    (5)
    Ready for production

  • Avatar
    Balam Sinhue
    (5)
    A very complete and didactic course on ETLs and their implementation

    This course is an excellent introduction to creating ETLs with Python and how to integrate them with popular platforms like Azure. I highly recommend it for anyone looking to build this type of solutions to automate and manage data ingestion for ML and DL models. As a final note and recommendation, perhaps the course should update some classes since some of them are quite long and it would be better to break them down into smaller lessons; even so, this doesn't affect the course quality at all.

  • Avatar
    Giovanni
    (5)
    Data automation and cleaning without errors

    The transition from extraction to final loading is explained with excellent technical rigor. Now I can handle considerable data volumes with total confidence, always ensuring the integrity and cleanliness of the information at each step

  • Avatar
    Jorge
    (5)
    Complete Data Cleanup

    Spending hours organizing spreadsheets was my nightmare, but learning to automate ETL workflows with Python changed my life; now my data cleaning processes are automatic and I save a ton of operational time every week.

  • Avatar
    Javi
    (5)
    Automatic and error-free organization

    Handling lots of messy information used to be really tedious until I learned how to automate the whole cleaning and organizing process. It's amazing to see how the data sorts itself out and gets ready to use without having to spend hours reviewing file after file. It saved me an incredible amount of time on my everyday tasks.

  • Avatar
    Sergio
    (5)
    I loved the course, satisfaction guaranteed.

    Really well explained in a clear and concise way, fantastic course.

  • Avatar
    Eulogio
    (5)
    The most complete

    This course is one of the most comprehensive in data handling I've found online. I wholeheartedly recommend it, as it covers a lot of material and it's really well explained.

  • Avatar
    Jesus
    (5)
    Perfect course to get started with ETLs

    I'm very satisfied with everything I've learned. I didn't know the potential of using ETLs and this course has opened up a whole new world for me to discover. Clear and straightforward explanations!

  • Avatar
    Samuel
    (5)
    It opened up a world of possibilities for me

    I loved how this course took me from zero to feeling confident that I have a solid level in handling data with Python

  • Avatar
    Joel
    (5)
    Excellent ETL course

    A very complete course to learn the ETL process from scratch, explaining each step really well

  • Avatar
    Alberto
    (5)
    What a great acquisition!

    Thanks to this course I've been able to improve across the wide spectrum of possibilities that Python offers us.

  • Avatar
    Nicolás
    (5)
    Crystal-clear explanations. The extract, transform, and load flow was crystal clear.

  • Avatar
    Nieves
    (5)
    Tratamiento de datos en Python: ETL de cero a experto

    This course teaches you how to build ETL (Extract, Transform, Load) processes with Python from scratch, applying best practices, automation, and deployment in hybrid environments (local and cloud).

  • Avatar
    Gustavo
    (5)
    From Zero to Expert: The Art of ETL Mastered with Python

    The Data Processing in Python: ETL from Zero to Expert course is a true revelation for those who want to master the process of extracting, transforming, and loading data (ETL) with modern and efficient tools. From the first module, you can see the practical and progressive approach: whether you're starting from scratch, the content is designed so you advance with confidence and clarity.

  • Avatar
    Rocío
    (5)
    Very clear course; explains the ETL process step by step with Python.

  • Avatar
    María
    (5)
    This course saved my life at work

    Before I spent hours cleaning data, but now I'm an expert and I finish everything in a blink of an eye

  • Avatar
    Sara
    (5)
    Great course

  • Avatar
    Carlos
    (5)
    Essential for data handling

    One of the most important aspects in any data project is cleaning and transforming information, and this course covers it perfectly. Now I feel much more prepared to face challenges in data science. Highly recommended!

  • Avatar
    Gabriela
    (5)
    From Zero to Data Treatment Expert

    The practical examples were key to understanding each step. Now I can handle large data volumes without any issues. Highly recommended!

  • Avatar
    Alexander
    (5)
    Excellent

    I loved the course, the topic, the teaching style, the content, and the final exercise. Thank you so much.

  • Avatar
    Caty
    (5)
    Structured and organized

    The fundamentals and basics applied in Python with the explanations are the best

  • Avatar
    DAVID VICTOR
    (5)
    ETL Python

    Even though it's basic, super clear and very practical

  • Avatar
    Joiser
    (5)
    Great course

    I'm loving the course so far, very well structured

  • Avatar
    Marc
    (5)
    Great course

  • Avatar
    Yvonne
    (5)
    recommended

    Great course, excellent in every way. I'll keep going to learn more and improve my skills

  • Avatar
    Alvaro
    (5)
    Bacano

    Awesome

  • Avatar
    Alvaro Isaias
    (5)
    Congratulations

    Great course, it's been really useful for implementing ETL in my work.

  • Avatar
    BORJA
    (5)
    Excellent

    A really comprehensive course, explained really well.

  • Avatar
    Yeison
    (5)
    Complements my ETL experience

    A course that helps me complement my knowledge in ETL and data processing to improve my machine learning models. Thanks so much to the Frogames team

View More Reviews

PLANS TO MATCH YOUR GOALS AND NEEDS

Buy the individual course, get all the learning path or access to the entire platform

Choose the payment method that works best for your needs and budget with a one-time course payment, monthly or yearly access to the learning Path, or even to the entire platform.

One-Time Payment

Buy the course once and access it for life

49.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Popular

Bronze Frog

Access all Frogames courses, communities and extras

39 /month

  • Single payment of 39€ per month
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress

Path of Data Analysis

Access all courses in the Data Analysis Path

19.99 /month

  • Single payment of 19.99€ per month
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress

One-time payment

Buy the course once and access it for life

49.99

  • A single payment
  • Instant lifetime access to the course
  • Access the course community
El Más
Valorado

Gold Frog

Access all Frogames courses, communities and extras

349 /year

  • Single payment of €349 per year
  • 3 months of discount
  • Instant access to all courses
  • Access the platform and communities 24/7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Resource Library
  • Monthly Q&A livestreams
  • Premium support

Path of Data Analysis

Access all courses in the Data Analysis Path

199 /year

  • Single annual payment of €199
  • 4 months of discount
  • Instant access to the +10 courses in the Path
  • Access the Path 24 / 7, wherever and whenever you want
  • Cancel anytime without losing your progress
  • Premium support

* All prices include taxes.

For your security, all orders will be processed on a secure server.

Path of Data Analysis

The ultimate pack with all our Data Analysis courses with R and Python to turn you into a well-paid Data Scientist. Includes upcoming courses and updates and improvements to current ones

Introducción al Machine Learning con Python

Learn Python fundamentals for Machine Learning with a deep dive into Pandas, Numpy and Matplotlib and apply it to a final project

27 classes

Fundamentos de Matemáticas para Machine Learning

The essential foundations of Linear Algebra and practical Calculus explained in Python's three star libraries: NumPy, TensorFlow and PyTorch

121 classes

Fundamentos Intermedios de Matemáticas para Machine Learning

Master the essential math for ML: Probability, Information Theory and statistics with NumPy, TensorFlow and PyTorch—all totally hands-on

102 classes

Una semana de ciencia de datos en Python

Master the fundamentals of Data Science quickly and efficiently in just one week! A course designed especially for busy people!

155 classes

Fundamentos Avanzados de Matemáticas para Machine Learning

Master the advanced mathematics you need for ML: optimization, gradients, Hessian matrices, data structures and sorting algorithms with TensorFlow, PyTorch and practical tools

93 classes

Machine Learning from A to Z

Learn over 40 Machine Learning algorithms in both Python and R with Data Science experts. Complete source code and a bonus book included! Over 50 hours of video tutorials to help you master ML!

304 classes

Probabilidad y Estadística aplicada a Negocios y Empresas

Learn to apply statistics and probability to business and company problems using your own data or your clients' data

162 classes

Curso completo de R para Data Science con Tidyverse

Learn to manipulate data in R with the free tidyverse library: visualize your data with ggplot and create professional reports from RStudio

226 classes

Curso completo de Machine Learning: Data Science con RStudio

Learn to analyze data and get started in Machine Learning with Juan Gabriel Gomila's professional tricks applied with the statistical language R

237 classes

Tratamiento de datos en Python: ETL de cero a experto

Master the essential data processing operations with Python: data extraction, transformation, and loading. Take your Python library skills to the next level

84 classes

Curso completo de Machine Learning: Data Science en Python

The course that's taught thousands of people in Spanish. Learn Machine Learning algorithms with Python to become a Data Scientist and download the code from minute one

235 classes

Databases: Learn SQL from scratch

Learn SQL, the language of databases, from scratch with practical exercises to master loading, querying, modifying and managing your data while learning all the key SQL commands.

82 classes

Aprende a analizar los datos del COVID19 con R y Python

Apply data analysis and statistics knowledge in R and Python to COVID-19 epidemiological data

59 classes

Data Science aplicado a Negocios | 6 Casos de Estudio Reales

Solve 6 real-world business problems: Build AI, DL, and NLP models to predict sales, boost marketing, or optimize HR and PR operations

79 classes