Programming Study日本語

Disclosure: We earn a commission from Udemy when you buy a course through links on this page.

Analytics Engineering with dbt on Snowflake

Analytics Engineering with dbt on Snowflake

Udemy · English

About this course

Language
English
Category
Provider
Udemy
Data updated

Analytics engineering is one of the fastest-growing roles in data, and dbt on Snowflake is one of its most in-demand skill sets. This course takes you from your first SQL query to deploying a tested, production-ready dbt project on Snowflake. Most dbt tutorials stop at "run your first model." This course goes further. You'll learn how real data teams structure, test, document and deploy their transformation layer, and you'll build a complete e-commerce analytics project step by step. What you'll work through: Analytics Engineering Overview: what the role is, where it sits in a data team, and how data moves from source systems into warehouses, lakes and lakehouses through ETL and ELT pipelinesData Modeling: the Medallion architecture, star and snowflake schemas, fact and dimension tables, slowly changing dimensions, Data Vault and the BEAM methodologySQL Crash Course: filtering, aggregations, joins, subqueries, CTEs and window functions, with five hands-on assignmentsSnowflake Fundamentals: architecture, virtual warehouses, loading data with stages, COPY INTO and Snowpipe, Time Travel, zero-copy cloning, Streams, Tasks and Stored ProceduresAnalytics Engineering with dbt: models and the DAG, ref() and source(), materializations and incremental strategies, unit tests, data tests, data contracts, snapshots, Jinja, macros, packages, documentation, and running dbt in production with Git and CI/CDLearn by doing. The course includes 16 hands-on assignments with clear success criteria, so you can check your own work as you go. Your instructor: Ricardo Gonçalves has more than 10 years of experience working with data as a Data Analyst, Data Scientist and Data Engineer. The course reflects how these tools are used in real projects, not only how they're describe…

Courses in the same category