Learn to master DBT data build tool online course

Learn to master DBT data build tool online course
Learn to master DBT data build tool online course

Learn to master DBT data build tool online course

hands-on, examples, case study, homework and more

DBT data build tool helps data teams work like software engineers, transform data and control the flow to ship trusted data, faster. DBT data build tool is an exciting tool in modern data manipulation, due to the shift from ETL to ELT in companies that rely on
MPP databases in the cloud for example Snowflake, Redshift, Bigquery and others. In the course, I explain the differences, but as a general idea. It means that we first load the data as is to the target and then use SQL (DBT data build tool ) to transform it.DBT data build tool is the infrastructure to manage the sequence and control over the SQL – transformation using simple yet powerful components. DBT data build tool will materialize your SQL selects into table | views and manage the flow of executing the SQL, by using SQL it means that you don’t need a senior python developer or an ETL tool developer.

Audience
ETL developers, DBA, BI developers, decision-makers that consider DBT, SQL programmers, data analysts, data engineers.

Background
SQL, GIT (nice to have)

This course will teach you the fundamentals of DBT data build tool. you will learn the structure of DBT data build tool, the main components:
  • Install DBT data build tool
  • YAML files – configuration
  • Create models
  • Materialization
  • Create tests
  • Get to know macros, hooks, jinja
  • Deploy DBT data build tool
  • And many more…
What you’ll learn?
  • DBT building blocks
  • DBT environment – yml files and structure
  • Develop transformations from staging to DWH schema
  • concepts of macro, Jinja and hooks
  • Test your code and transformations
  • Case study – DVD rental chain from stg to dwh
  • Deploy DBT to remote ubuntu server and DBT cloud
Requirements:
  • SQL
  • GIT
  • relational database and analytics schema – nice to have
Course content
1. introduction
—————
2. hello word example
—————
3. what is DBT
—————
4. hello word – dim date example 2
—————
5. materials – zip file attached
—————
2. Installation
1. Installation overview
—————
2. GIT install
—————
3. Dbeaver install
—————
4. Postgres and Sakila install
—————
5. Python and DBT install
—————
3. DBT main components
1. YAML files
—————
2. materialization table  view
—————
3. incremental
—————
4. tests
—————
5. ephemeral
—————
4. Advance components
1. variables
—————
2. alias
—————
3. custom schema
—————
4. macros and packages
—————
5. hooks
—————
5. The project
1. project overview
—————
2. clear DWH homework
—————
3. dim date
—————
4. arrange hw
—————
6. Dim customer
1. dim customer overview
—————
2. dim customer base
—————
3. dim customer conflict
—————
4. dim customer source
—————
5. dim customer minus one
—————
7. Dim staff  store  film
1. dim staff
—————
2. dim staff consideration
—————
3. dim store
—————
4. dim film explain
—————
5. dim film result
—————
6. dimensions schema yml
—————
8. Fact rental  payment
1. fact rental hw prepare
—————
2. fact rental prepare solve
—————
3. fact rental solve additional
—————
4. fact rental explain
—————
5. fact rental model
—————
6. fact rental incremental
—————
7. fact payment homework
—————
8. fact payment solution
—————
9. Project finalize
1. project final and homework
—————
2. project final incremental solution
—————
10. deploy DBT
1. deployment – remote server ubuntu
—————
2. DBT cloud – getdbt
—————
3. congratulations

Source: https://www.udemy.com/course/learn-to-master-dbt-data-build-tool-online-course/