dbt(data build tool): dbt for Analytical Engineers

[nieriorefasow63]

dbt(data build tool): dbt for Analytical Engineers
Published 6/2023
Created by Saad Qureshi
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 45 Lectures ( 6h 20m ) | Size: 2.55 GB

Comprehensive dbt (Data Build Tool) course covering basic to advanced level dbt concepts

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

Requirements
Very basic knowledge of SQL and database are required
No High Level programming knowledge/Background is required
All you need a Computer machine; windows, Mac, and Linux users are all welcome

Description
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 warehousedbt  in simple words is an open-source command line tool that helps analysts and engineers transform data in their warehouse more effectively and more efficientlydbt is a modern data stack tool. Modern data stack tools are used to analyse data and uncover new insights and improve efficiencyWhat 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 levelData 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 SetupData Warehousing Conceptsdbt Models and their deployment to databaseMaterialization and its different typesSlowly Changing DimensionSnapshot in dbtdbt(data build tool) Sources and SeedsMacros and PackagesBasic Overview of Jinja Templating language and it's usage in dbt modelsMacro and dbt Testingdbt(data build tool) documentation and Job deploymentAfter this CourseOnce 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!

Who this course is for
Data Engineer Professionals who want to learn modern data stack transformation tools
University Students/Fresh Graduates looking for a career in the field of Analytical Engineer


HOMEPAGE

[To see links please register or login]

DOWNLOAD

[To see links please register or login]