The Complete Snowflake & dbt Hands-On Guide
สิ่งที่คุณจะได้เรียนรู้
- Ingest data into Snowflake from multiple sources (AWS S3 and local files)
- Set up and manage internal and external stages in Snowflake
- Use SnowSQL to load and query data in Snowflake efficiently
- Build and optimize data transformation models using dbt
- Understand version control and modularity in dbt for scalable data projects
- Work with semi-structured data - JSON
- Work with Time functions and Window functions
ข้อกำหนด
- Basic SQL knowledge is recommended but not required
- Familiarity with data concepts (optional, but helpful)
- No prior experience with dbt or Snowflake required - everything will be explained step by step
คำอธิบาย
Want to build real, production-ready data pipelines with two of the most in-demand tools in the modern data stack ? This all-levels, project-based course takes you from the basics to advanced workflows with Snowflake and dbt (data build tool).
With over 11 hours of content, you’ll not just learn the concepts — you’ll apply them step by step in real projects, including a Bitcoin blockchain data pipeline designed to mirror real-world challenges.
In this course, you will:
Set up and manage Snowflake environments (databases, schemas, stages).
Ingest data from local files, S3 buckets, and external sources.
Write modular SQL with dbt models, CTEs, and window functions.
Apply ELT best practices and build maintainable data models.
Use dbt contracts, versioning, and generic tests for reliability.
Set up CI/CD with GitHub Actions and key pair authentication.
Optimize Snowflake with caching, micropartitions, and clustering.
Prepare data for analytics tools like Power BI.
This course is packed with real-world use cases, code walkthroughs, and tips I’ve implemented in production environments. By the end, you’ll be confident in building scalable, maintainable data pipelines — skills you can immediately apply in your current role or future projects. These lessons are designed to give you both technical expertise and practical confidence when working with modern data tools.
หลักสูตรนี้เหมาะกับ
- Aspiring and current data analysts and engineers looking to master Snowflake and dbt
- Developers and software engineers interested in modern ELT workflows
- Anyone who wants a hands-on, project-based approach to Snowflake and dbt
วิทยากร
- คะแนนวิทยากร 4.7
- รีวิว 211 รายการ
- ผู้เรีียน 1,768 คน
- หลักสูตร 1 รายการ
Hey! I’m Daniel, a data engineer who's worked with Snowflake and dbt across different industries and countries. I’ve helped companies set up Snowflake from scratch, managed accounts as an admin, and built entire data pipelines using dbt. I used to work at Microsoft, and I’m always learning—whether it’s through real projects or by geeking out at data conferences and events. I love breaking down complex topics into simple, hands-on lessons that you can actually use.