Comprehensive dbt (Data Build Tool) course covering basic dbt to advanced level dbt concepts
What is dbt(data build tool)?
What you’ll learn
- dbt(data build tool) Cloud and Core Configuration to Snowflake.
- dbt Models and their deployment.
- Materialization and its different types.
- Basic Data Warehouse Concepts.
- Slowly Changing Dimensions and Snapshot in dbt.
- dbt Sources and Seeds.
- Jinja basic fundamentals.
- Macros and Packages.
- Testing of Different Models.
- Basic Overview of Jinja Templating language and it’s usage in dbt models.
- dbt documentation and Job deployment.
Course Content
- dbt(data build tool) Connections –> 7 lectures • 1hr.
- dbt(data build tool) : Data Warehouse Fundamentals –> 5 lectures • 36min.
- dbt(data build tool) Models –> 5 lectures • 49min.
- dbt(data build tool): Sources and Seeds –> 3 lectures • 30min.
- Materialization in dbt(data build tool) –> 6 lectures • 56min.
- Snapshots in dbt(data build tool) –> 3 lectures • 17min.
- Jinja Basic Fundamentals –> 4 lectures • 28min.
- dbt(Data build tool): Macros and Hooks –> 3 lectures • 31min.
- dbt documentation & Job Deployment –> 2 lectures • 16min.
- dbt Testing –> 9 lectures • 1hr 10min.
Requirements
What is dbt(data build tool)?
- dbt is not an ETL tool that you use in you warehouse to extract data from multiple heterogeneous sources and then transform it and then finally load the data in the data warehouse
- dbt in simple words is an open-source command line tool that helps analysts and engineers transform data in their warehouse more effectively and more efficiently
- dbt is a modern data stack tool. Modern data stack tools are used to analyse data and uncover new insights and improve efficiency
What makes dbt more more secure,fast and easier to maintain is the ability to do all the calculation at the database level rather than memory level
Data engineers work in different ways to collect, manage, and convert raw data into usable information for data scientists and business analysts to interpret.Their main goal is to make data available and accessible for the organisation so that timely and effective decisions are taken for the business.
Why to Learn dbt(data buildTool):
dbt(data build tool) is becoming the most popular tool in Data Warehouse industry.Many big companies like IBM,Jet Blue,Dyson, Capgemini etc are using this tool,around the world in 2023 over 3000 companies have started using this tool in their Data Warehouse department.
Career Perspective:
If you want to pursue a career in the field of Data Warehouse as a Data Engineer,Data Analyst or Data Scientist then you must learn this modern data stack tool.The pre-requisite of this course is basic SQL,no advance knowledge of SQL is required,neither any programming concepts are needed.
Important topics:
- Introduction to dbt(data build tool)
- dbt(data build tool) Cloud and Core Configuration and Setup
- Data Warehousing Concepts
- dbt Models and their deployment to database
- Materialization and its different types
- Slowly Changing Dimension
- Snapshot in dbt
- dbt(data build tool) Sources and Seeds
- Macros and Packages
- Basic Overview of Jinja Templating language and it’s usage in dbt models
- Macro and dbt Testing
- dbt(data build tool) documentation and Job deployment
After this Course
Once you’re done with the course,you will have maximum knowledge of this tool,plus you will get to see hands-On examples of using this tool.Moreover after attaining all the practical knowledge you can apply these concept in different field as mentioned above.
Cheers..!!
Having a Great Learning!