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.
Course Outline
Introduction
- The philosophy behind dbt and an answer to the question: What is dbt?
- Comparing dbt with traditional ETL processes
- A high-level view of dbt’s features and architecture
- Going beyond the basics: An introduction to dbt Cloud
Gaining Insight into dbt Cloud
- The complete lifecycle of a dbt project within dbt Cloud
- The role of dbt Cloud in data warehousing and transformation pipelines
Commencing with dbt Cloud
- Configuring the Development Environment in dbt Cloud
- Establishing a connection between dbt Cloud and your data warehouse
- Initializing a new dbt project in dbt Cloud
- Executing dbt commands via the dbt Cloud interface
- Collaborating with team members on dbt Cloud projects
Developing dbt Models
- Core concepts of dbt models
- Constructing effective dbt models
- Data transformation techniques using dbt
- Utilizing incremental models in dbt
- Writing macros and custom functions to extend functionality
Oversight of dbt Projects in dbt Cloud
- Managing and deploying projects using the dbt Cloud interface
- Defining schedules and triggering dbt jobs
- Setting up and maintaining different environments in dbt Cloud
- Transitioning dbt projects to production
- Configuring notifications and alerts for status updates
Integrating dbt Cloud with External Tools
- Synchronizing dbt Cloud with Git and version control systems
- Connecting dbt Cloud with other cloud-based data warehousing and transformation platforms
Diagnosis and Resolution
- Techniques for debugging and troubleshooting dbt projects in dbt Cloud
- Leveraging logs to pinpoint and fix issues
- Best practices for long-term maintenance of dbt Cloud projects
Wrap-up and Future Directions
Requirements
- Familiarity with 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
21 Hours
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.
