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
- Core dbt philosophy and principles / An introduction to dbt
- dbt compared to conventional ETL methodologies
- A summary of dbt features and underlying architecture
- Looking beyond the basics: An overview of dbt Cloud
Gaining Insight into dbt Cloud
- The lifecycle of a dbt project when using dbt Cloud
- How dbt Cloud integrates with data warehousing and transformation pipelines
Getting Started with dbt Cloud
- Configuring the Development Environment on dbt Cloud
- Establishing the connection between dbt Cloud and your data warehouse
- Initiating a dbt project within dbt Cloud
- Executing dbt commands via dbt Cloud
- Facilitating team collaboration on a dbt project in dbt Cloud
Managing dbt Models
- Comprehending the structure of dbt models
- Constructing a dbt model
- Performing data transformations using dbt
- Utilizing incremental models within dbt
- Developing macros and custom functions in dbt
Overseeing dbt Projects in dbt Cloud
- Utilizing the dbt Cloud interface for project management and deployment
- Defining schedules and initiating dbt jobs
- Establishing and maintaining environments in dbt Cloud
- Releasing dbt projects to production
- Configuring notification and alert systems
Connecting dbt Cloud with External Tools
- Integrating dbt Cloud with Git and version control systems
- Linking dbt Cloud with other cloud-based data warehousing and transformation platforms
Diagnosis and Resolution
- Strategies for debugging and troubleshooting dbt projects in dbt Cloud
- Leveraging logs to identify and resolve issues
- Best practices for sustaining dbt Cloud projects
Summary and Future Directions
Requirements
- A solid grasp of data modeling concepts and SQL
- Practical experience with SQL and command-line interfaces (CLI)
- Proficiency 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.
