Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 21 hours
Course Outline
Introduction
- dbt philosophy and core principles / What is dbt?
- dbt compared to traditional ETL
- Overview of dbt features and architecture
- Beyond dbt: An introduction to dbt Cloud
Comprehending dbt Cloud
- The lifecycle of a dbt project within dbt Cloud
- The role of dbt Cloud in data warehousing and transformation workflows
Getting Started with dbt Cloud
- Configuring the Development Environment on dbt Cloud
- Linking dbt Cloud to your data warehouse
- Initiating a dbt project in dbt Cloud
- Executing dbt commands via dbt Cloud
- Collaborating with team members on a dbt project in dbt Cloud
Managing dbt Models
- Concepts behind dbt models
- Constructing a dbt model
- Transforming data utilizing dbt
- Utilizing incremental models in dbt
- Applying macros and custom functions in dbt
Administering dbt Projects in dbt Cloud
- Leveraging the dbt Cloud interface for project management and deployment
- Establishing schedules and initiating dbt jobs
- Creating and managing environments in dbt Cloud
- Releasing dbt projects to production
- Configuring notifications and alerts
Integrating dbt Cloud with External Tools
- Using dbt Cloud alongside Git and version control systems
- Connecting dbt Cloud with other cloud-based data warehousing and transformation platforms
Troubleshooting and Debugging
- Strategies for debugging and troubleshooting dbt projects in dbt Cloud
- Diagnostics using logs
- Best practices for maintaining dbt Cloud projects
Conclusion and Next Steps
Requirements
- Familiarity with data modeling and SQL
- Proficiency in SQL and command-line interfaces (CLI)
- Background in Python programming
Target Audience
- Data Engineers
- Data Analysts
- Data Scientists
Testimonials (3)
Learning that the QGIS and a tool that can used by other different professionals such land survey
Bame Duncan Koko - Bentel Technologies (Pty) Ltd
Course - QGIS for Geographic Information System
How to use open satellites data for real applications
Tshering Dorji - Druk Holding and Investments
Course - Advanced Geographic Information Systems (GIS)
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.
