Hello sir, please provide few more info for beginners to crack on interview
Learn dbt (data build tool)
Learn dbt (data build tool) in Cloud from basic to advanced, scenarios, test cases, deployment, document generation ,etc
Updated on Sep, 2023
Language - English
This course provides detailed lectures on dbt Cloud, applying transformations using Sql Statements, performing the test cases during development and deploying the project into Production environment.
Topics covered in the course are,
In detail the course includes, Introduction of Models and implementation, Materializations (Table, View, Incremental and Ephemeral) , Tests cases with various scenarios using schema.yml file as well as within Sources , creating Seeds and Sources, managing Snapshots, creating Hooks, utilizing Jinja and Macros, Deployment process, defining connection with AWS RDS PostgreSql instance, various methods to develop a model, referencing the models, deep understanding of dbt_project.yml and schema.yml files, reusability models and functions, efficient way of transformations using Sql, defining global and local variables, defining the variables during run time, interacting with PostgreSql, dynamic schema generation, dynamic, database object creation .etc,.
By the end of the course, you will have a proficient knowledge on dbt Cloud, transforming the data in a data warehouse using simple Sql statements, managing the test cases and deploying the project into production environment.
This course is meant for Data Engineers, ETL Architects, ETL Developers, Data Analysts, Data Scientists, BI Developers, Database Developers, Data Integration Specialists, Data Architects and whoever need to enhance their skill in the field of data engineering and analytics.
Who this course is for:
- Data Engineers, ETL Architects, Data Analysts, Data Scientists and BI Developers
What will you learn in this course:
dbt Cloud from basic to advanced
Transformations using Select statements in SQL
Connecting dbt Cloud to AWS RDS PostgreSql
Materialization - Table, View, Incremental and Ephemeral
SCD's using Snapshot
Test Cases using Test functionality
Jinja and Macros
Deployment (CD/CI) - Running in Production
What are the prerequisites for this course?
Proficient in SQL and basic knowledge in Git
Check out the detailed breakdown of what’s inside the course
- What will you learn? 01:00 01:00
- About the Course? 00:43 00:43
Tests, Variables, Sources and Seeds
Snapshots and Hooks
Jinja and Macros
Jim MacaulaySenior Software Development Architect
My self Jim, am an experienced Software and Robotics Engineer with a demonstrated history of working in the financial services industry. Passionate about teaching and blogging. Am also a YouTuber and an Instructor. Skilled in Data Engineering with various ETL, Database and Cloud Technologies, and a Robotics Engineer. Strong consulting professional with a Master’s degree focused in Software Systems (Data Analytics) from Birla Institute of Technology and Science, Pilani.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now