Module 1: Introduction to DBT Fundamentals
- What is DBT
- Typical data transformation challenges
- How does DBT eliminate traditional Data challenges?
Module 2: Set up DBT Cloud
- Data Built Tool and databases
- Version Control
- Data loading into the data warehouse
- Data repository set up & connect to DBT cloud
- Fundamentals of DBT cloud IDE
- The process to connect to Repository
- The process to connect to your warehouse
- Target Audience
Module 3: Models
- Overview of Models and types
- The process to build a model
- Basics of modularity
- Ref functions
- Data modeling fundamentals
- Naming conventions
- Project reorganization
- Course Prerequisites
Module 4: Tests
- What is Testing?
- Need of Testing
- Data tests
- Schema tests
- Live test scenarios
Module 5: Documentation
- Fundamentals of Documentation
- Importance of documentation
- The process to write doc blocks
- Documentation writing
- Documentation generation and view
- Working with real-time documentation & gaining hands-on experience
Module 6: Sources
- Introduction to Sources
- Source Configuration
- Selecting from sources
- Testing Sources
- Documenting Sources
- Source Freshness
- Working with real-time source scenarios
Module 7: Deployment
- What is Deployment
- The process to schedule a job in the DBT cloud
- Reviewing scheduled jobs
Module 8: Jinja Premier
- Introduction to Jinja
- Jinja fundamentals
- Jinja basics
- Jinja applications
- Working with real-time Jinja scenarios
Module 9: Macros
- What are Macros?
- Cents to dollar Macros
- Dry code vs readability
- Limit data in dev macro
Module 10: Packages
- What are packages
- Packages with Macros
- Installing packages
- Packages with models
Module 11: Materializations
- Introductions to Materialization
- Tables, views
- Ephemeral models
- What are snapshots?
- Snapshot implementations
Module 12: Analyses & Seeds
- What are analyses?
- Implementing analysis
- What are seeds?
- Implementing Seeds