get to know DBT data build tool - free introduction
Requirements
- SQL
Description
DBT data build tool introduction course:
In this course you learn how to install DBT data build tool ,
learn the concept of DBT data build tool
you will see the environment how to run it,
understand how to materialize tables and views from a select query (SQL)
what is DBT data build tool:
DBT data build tool is designed to help you materialize select queries into tables or views with override or incremental on a different database or schema.
The idea is to take data sources and transform them into a data warehouse.
The first phase (that is not a part of DBT data build tool) is to bring the data into a staging area (schema for example).
When all the data you need to transform resides inside the staging (that can be from several sources for example CRM, ERP, call center, sensors…)
you can develop a select query with all the functionality of SQL,
that includes joins, calculations, windows functions, and more goodies in order to materialize it into another schema.
you can create complex transformations with dependencies between SQL code (reference) to form a data flow and use variables and configuration YAML to control the DBT data build tool Job.
You can also create tests like we do in programming.
The course is an overview for beginners,
in case you want to learn to develop with DBT data build tool
I recommend the course “learn to master DBT data build tool online course”
Audience
ETL developers, DBA, BI developers, decision makers that consider DBT data build tool, SQL programmers, data Analysts, data engineers.
Background
SQL, GIT (nice to have)
My name is Steinberg itamar, I am in the fields of data engineering, that is: ETL, ELT, DWH and Business intelligence for the last 15 years as a developer, team leader and manager, I developed and managed many projects in those areas. always keeping hand-on capabilities.
Who this course is for:
- ETL developers
- BI developers
- DBA
- decision makers that consider DBT
- SQL programmers
- data Analysts
Instructor
- 4.4 Instructor Rating
- 855 Reviews
- 12,798 Students
- 5 Courses
My name is Steinberg itamar,
I am in the field of information technology is for more than 15 years now,
I have a Master's degree (MBA) in information technology is an management.
My BA is also in the area of information technology from the University of Manchester.
During those years I was serving as manager and information technology expert
especially in the field of business intelligence and data integration.
all that time i used Pentaho kettle as the leading Data integration tool.
I started as a developer through team manager of development, head of the application department - responsible for all software, business processes and implementations,
also as project manager, my last role as an employee I was the CIO of the large company.
I was dealing with ERP, CRM business intelligence of course from all aspects of running a business. sales, transportation, customer service, imports, inventory, suppliers and manufacturing.
All of these areas gave me a unique perspective on business processes and how to analyze a company by looking at one large picture – that is the BI.
Of course that in order to combine all of those systems together you'll need data integration.
I have more than eight years working with pentaho kettle.
Six years ago I decided to start my own company - inflow systems and focus myself to business intelligence and data integration.
On those six years I, as CEO, was leading large business intelligence projects.
I hired several employees, very gifted, specific oriented to data integration and business intelligence. We have developed tens of projects from scratch at large companies like Alcatel Lucent (embedded solution), online gaming, binary options (stock market) and traditional businesses like food supplementary and organic food.
Today, I want to give from my knowledge to you because I believe that to share is the right way to go, during my learning phase I was reading a lot of books, struggling with the technology and I think I can make your life easier.