コース概要
Introduction
- dbt philosophy and principles / What is dbt?
- dbt vs traditional ETL
- Overview of dbt features and architecture
- Beyond dbt: What is dbt Cloud?
Understanding dbt Cloud
- The lifecycle of a dbt project in dbt Cloud
- How dbt Cloud fits in with data warehousing and transformation workflows
Getting Started with dbt Cloud
- Setting up the Development Environment on dbt Cloud
- Connecting dbt Cloud to your data warehouse
- Creating a dbt project in dbt Cloud
- Running dbt commands in dbt Cloud
- Collaborating with team members on a dbt project in dbt Cloud
Working with dbt Models
- Understanding dbt models
- Building a dbt model
- Transforming data using dbt
- Working with incremental models in dbt
- Implementing macros and custom functions in dbt
Managing dbt Projects in dbt Cloud
- Using the dbt Cloud interface to manage and deploy projects
- Creating schedules and triggering dbt jobs
- Creating and managing environments in dbt Cloud
- Deploying dbt projects to production
- Setting up notifications and alerts
Integrating dbt Cloud with Other Tools
- Using dbt Cloud with Git and version control
- Integrating dbt Cloud with other cloud-based data warehousing and transformation tools
Troubleshooting and Debugging
- How to debug and troubleshoot dbt projects in dbt Cloud
- Using logs to diagnose issues
- Best practices for maintaining dbt Cloud projects
Summary and Next Steps
要求
- An understanding of data modeling and SQL
- Experience with SQL and command-line interface (CLI)
- Python programming experience
Audience
- Data Engineers
- Data Analysts
- Data Scientists
お客様の声 (5)
トレーナーは教材と内容を私たちにとって最適だと考えたものに適応させ、成功しました。トレーニングの質は素晴らしかったです。
Jorge Sanchez Hernandez - CSMART - Carnival
コース - QGIS for Geographic Information System
Machine Translated
A lot of patience
Mateusz - WestWind Energy Polska Sp. z o.o.
Machine Translated
プロフェッショナルで非常に実用的、日常業務で役立ちます
Jozefin Rékasi - SC Automobile Dacia SA
コース - Advanced Data Analysis with TIBCO Spotfire
Machine Translated
このコースでは、私がコース開始前に興味があると言った領域、つまりデータ関係や Python スクリプトの使用について説明しました。データベースへの接続については、上級モジュールで説明します。
Cristian Tudose - SC Automobile Dacia SA
コース - Introduction to Spotfire
Machine Translated
I genuinely enjoyed the lots of labs and practices.