English | Size: 2.01 GB
Genre: eLearning
What you’ll learn
Learn to use the dbt™ platform professionally through the creation of an exhaustive, real-world, hands-on dbt – Airbnb project covering both Theory and Practice
Set up the complete development environment on Mac & Windows, Connect to Snowflake and BI, Configure dbt profile, extend the IDE with dbt tools
Learn core dbt concepts such as Models, Materialization, Sources, Seeds, Snapshots, Packages, Hooks, Exposures, Analyses, write complex SQL queries
Understand the dbt project structure and learn about dbt tips & tricks, advanced techniques and best practices, extend dbt with your own / third-party macros
Implement singular and generic dbt tests, work with additional arguments and default config values, customize dbt built-in tests
Document your models and pipeline, customize the dbt docs page, Explore and analyse dependencies between transformation steps
Understand how dbt fits into the modern data stack, learn about the stages of the Data-Maturity Model, and well functioning Data Architectures
Master ETL/ELT procedures, Data Transformations, Database Normalization, Slowly Changing Dimensions, Common Table Expressions and Analytics Engineering
Understand what is a Data Warehouse, Data Lake, or Data Lakehouse and when to use which, handle Data Collection, Data Wrangling and Data Integrations
Greetings to the MOST COMPLETE, CONTINUOUSLY UPDATED independent dbt™ (Data Build Tool) software course in the world – as of 2022!
Thank you for joining us for 2022 Complete dbt (Data Build Tool) Bootcamp: Zero to Hero – we are super excited to have you in the course!
The structure of the course is designed to have a top-down approach. It starts with the theory – all you need to know is to put dbt (Data Build Tool) in context and to have an understanding of how it fits into the modern data stack. We start with the big picture, then we go deeper and deeper. Once you learned about the pieces, we are going to shift to the technicalities – a practical section -, which will focus on putting together the dbt “puzzle”. The practical section will cover each and every single dbt feature present today through the construction of a complete, real-world project; Airbnb. This presents an opportunity for us to show you which features should be used at what stage in a given project, and you will see how dbt is used in the industry.
THEORETICAL SECTION:
Among several other topics, the theoretical section puts special emphasis on transferring knowledge in the following areas;
Data-Maturity Model
Well-functioning Data Architectures
Data Warehouses, Data Lakes, and Data Lakehouses
ETL and ELT procedures and Data Transformations
Fundamentals of dbt (Data Build Tool)
Analytics Engineering
Normalization
Slowly Changing Dimensions
CTEs
Once we understood the theoretical layer and how dbt fits into the picture, we are going to start building out a dbt project from scratch, just how you would do this in the real world.
PRACTICAL SECTION:
The practical section will go through a real-world Airbnb project where you will master the ins and outs of dbt! We put special focus on getting everyone up and ready before the technical deep dive, hence we will start off by setting up our Development Environment:
MAC Development Environment Setup
WINDOWS Development Environment Setup
IDE dbt Extension Installation
Creation and Activation of Virtual Environments
Setting up Snowflake
Once we are ready – among several other technical topics, the following features will be covered;
dbt Models
dbt Materializations
dbt Tests
dbt Documentation
dbt Sources, Seeds, Snapshots
dbt Hooks and Operations
Jinja and Macros
Analyses, Exposures
dbt Seeds
Data Visualization (Preset)
Once the theory and the practical stages are finished, we are going to dive into the best practices and more advanced topics. The course is continuously updated, whenever dbt publishes an update we adjust the course accordingly, so you always be up to date!
Who is this course for?
Data Engineers
Data Analysts
Data Scientists
BI Developers
BI Analyst
… and anyone who interacts with data lake/data warehouse/data lakehouse or uses SQL!
nitro.download/view/4259313DEC6E68C/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part1.rar
nitro.download/view/DB3099CB351B752/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part2.rar
nitro.download/view/4B72BA6F8738E6A/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part3.rar
nitro.download/view/705254745142739/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part4.rar
nitro.download/view/A922F9DF1F10DB4/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part5.rar
nitro.download/view/FB7A91866616ABE/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part6.rar
rapidgator.net/file/99abf622183d14d745de800500c7ee14/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part1.rar.html
rapidgator.net/file/1817e1d28eb078a5e4d3fd43da5de00e/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part2.rar.html
rapidgator.net/file/f18cf94c9cd3fa2666f786f8976046ae/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part3.rar.html
rapidgator.net/file/f0eb79f4fc446bef1a214f3d855bceee/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part4.rar.html
rapidgator.net/file/adee79280cd04fa79f7a834e524a2e67/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part5.rar.html
rapidgator.net/file/a62e25b9fb32fff7a81ea04d5c8c2cd8/UD-CompletedbtDataBuildToolBootcamp-FromZerotoHero.4.5.1.part6.rar.html
If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9