Prerequisites
- Basic SQL knowledge
- Familiarity with relational databases
- Understanding of data warehouses
- Basic command line usage
- Interest in analytics engineering or data engineering
What Will You Learn
- Introduction to dbt modeling concepts
- Understanding ELT architecture
- Creating basic SQL models
- Model dependencies and project structure
- Running transformations and builds
- Incremental models for large datasets
- Data testing frameworks
- Documentation generation
- Model materializations and optimization
- Analytics workflow management
- Enterprise data transformation architecture
- Performance tuning for warehouse workloads
- Security and access control practices
- Scalable analytics engineering patterns
- Data pipeline reliability and monitoring
