Fundamentals of Data Transformation with pandas and DuckDB SQL

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

Fundamentals of Data Transformation with pandas and DuckDB SQL presents the most essential concepts and best practices in a clear and concise format that allows students to side-step the noise and complexity. While this course is wide rather than narrow, it was designed to help you understand your options for development and make an informed choice about where to drill down.

Instructor Matt Palmer covers transformation in three separate environments: data transformation in a lake, data transformation in the warehouse, and data transformation in data lake houses.

01 - Introduction

01 - Welcome to data transformation

02 - What well cover and what you should know

02 - 1. Setup and Beyond

01 - Codespaces and setup

02 - Why SQL Why Python Why not Spark

03 - Types of data transformation

04 - The goal of data transformation

03 - 2. Data Transformation with SQL and DuckDB

01 - DuckDB basics and query structure

02 - Wrangling unstructured data

03 - Joins and comparisons

04 - Aggregations

05 - Windows functions A quick refresher

06 - Window functions

07 - Advanced filters

08 - Advanced joins

09 - Lambdas and UDFs

10 - Data generation

11 - SQL challenge

12 - SQL solution

04 - 3. Data Transformation with Python and pandas

01 - DataFrame basics

02 - Wrangling unstructured data

03 - Select and filter

04 - Order and aggregate

05 - Advanced filters

06 - Data generation

07 - Windows

08 - Apply

09 - pandas challenge

10 - pandas solution

05 - Conclusion

01 - What you learned, how to practice and grow, and next steps

02 - SQL bonus challenge

03 - SQL bonus solution

139,000 تومان

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

خرید دانلودی فوری

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

تولید کننده: LinkedIn Learning (Lynda)