وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

ETL in Python and SQL

سرفصل های دوره

Data is increasing exponentially as the world continues to generate an immense amount. In this course, a data engineer with over 5 years of experience, Jennifer Ebe, will show you how to build systems that gather data from various sources, transform it and store data so you can derive insights from it effectively. We will go over what ETLs are and how you create them. We will learn how to use Python to extract and transform data, we will explore our data using pandas and SQL. And finally, load data into our target system. You will also get practice scheduling ETL jobs using Python. Each chapter comes with helpful, hands-on challenges to help you practice what you learn.


01 - Introduction
  • 01 - Create an ETL in Python and SQL
  • 02 - Tools used in this course

  • 02 - 1. What Are ETLs
  • 01 - What are ETLs and how do you create them
  • 02 - ETL process overview
  • 03 - Exploring your data with pandas (Python) and SQL
  • 04 - Understanding your data
  • 05 - Challenge Reading data using Python
  • 06 - Solution Reading data using Python

  • 03 - 2. Extracting and Transforming Data with Python
  • 01 - Loading data from different sources
  • 02 - Extracting your data
  • 03 - Cleaning, preprocessing data, and data formatting
  • 04 - Standardization, handling duplicates, and missing values
  • 05 - Challenge Load the data using SQLAlchemy and pandas
  • 06 - Solution Load the data using SQLAlchemy and pandas

  • 04 - 3. Loading Data into Target Systems
  • 01 - Introduction to data warehouses and data lakes
  • 02 - Loading data into relational databases
  • 03 - Data quality checks and validation with SQL
  • 04 - Challenge Transform the data and remove duplicates and nulls
  • 05 - Solution Transform the data and remove duplicates and nulls

  • 05 - 4. Automating ETL Jobs Scheduling ETL Jobs with Python
  • 01 - Querying your data with SQL
  • 02 - Scheduling ETL jobs with Airflow Part 1
  • 03 - Scheduling ETL jobs with Airflow Part 2
  • 04 - Challenge Load the data into a database and automate
  • 05 - Solution Load the data into a database and automate

  • 06 - Conclusion
  • 01 - Expand your knowledge of ETLs
  • 54,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 37242
    حجم: 184 مگابایت
    مدت زمان: 81 دقیقه
    تاریخ انتشار: 6 تیر 1403
    طراحی سایت و خدمات سئو

    54,900 تومان
    افزودن به سبد خرید