Course Outline
Introduction
- The Philosophy and Principles of dbt / What is dbt?
- dbt vs Traditional ETL Processes
- An Overview of dbt Features and Architecture
- Beyond dbt: An Introduction to dbt Cloud
Understanding dbt Cloud
- The Lifecycle of a dbt Project in dbt Cloud
- How dbt Cloud Integrates with Data Warehousing and Transformation Workflows for Government
Getting Started with dbt Cloud
- Setting Up the Development Environment on dbt Cloud for Government
- Connecting dbt Cloud to Your Data Warehouse for Government
- Creating a dbt Project in dbt Cloud for Government
- Running dbt Commands in dbt Cloud for Government
- Collaborating with Team Members on a dbt Project in dbt Cloud for Government
Working with dbt Models
- Understanding dbt Models for Government
- Building a dbt Model for Government
- Transforming Data Using dbt for Government
- Working with Incremental Models in dbt for Government
- Implementing Macros and Custom Functions in dbt for Government
Managing dbt Projects in dbt Cloud
- Using the dbt Cloud Interface to Manage and Deploy Projects for Government
- Creating Schedules and Triggering dbt Jobs for Government
- Creating and Managing Environments in dbt Cloud for Government
- Deploying dbt Projects to Production for Government
- Setting Up Notifications and Alerts for Government
Integrating dbt Cloud with Other Tools
- Using dbt Cloud with Git and Version Control for Government
- Integrating dbt Cloud with Other Cloud-Based Data Warehousing and Transformation Tools for Government
Troubleshooting and Debugging
- How to Debug and Troubleshoot dbt Projects in dbt Cloud for Government
- Using Logs to Diagnose Issues for Government
- Best Practices for Maintaining dbt Cloud Projects for Government
Summary and Next Steps
Requirements
- An understanding of data modeling and SQL for government applications
- Experience with SQL and command-line interface (CLI) in a government context
- Python programming experience relevant to public sector projects
Audience
- Data Engineers for government agencies
- Data Analysts working in the public sector
- Data Scientists supporting government initiatives
Testimonials (3)
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
All the topics which he covered including examples. And also explained how they are helpful in our daily job.
madduri madduri - Boskalis Singapore Pte Ltd
Course - QGIS for Geographic Information System
The thing I liked the most about the training was the organization and the location
