Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Business Intelligence Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Email Marketing Google Analytics Startup Advertising Strategy

DevelopmentData Sciencedbt (Data Build Tool)

The Data Bootcamp: Transform your Data using dbt™

Learn dbt™ from scratch. Build data models, perform testing, generate documents & become an all rounded Data Engineer!
Rating: 4.5 out of 54.5 (76 ratings)
501 students
Created by Vantage Data
Last updated 6/2022
English
English [Auto]

What you'll learn

  • Learn how to use dbt end-to-end through a realistic project, hands-on project
  • Learn the fundamentals of dbt including connecting to a data warehouse, developing models, working with sources, creating tests, deploying and much more
  • Understand how dbt is beneficial in a modern data stack and how the Extract, Load and Transform process works
  • Learn how to use Macros and Packages in dbt to simplify and reuse your code
  • Learn how dbt can work with complex SQL queries
  • Perform Testing in dbt such as singular tests, generic tests and source testing
  • Develop documentation for your models, understand modularity and dependancies in dbt
  • Learn about the dbt Project Structure and how to set up your own project
  • Understand how to use JINJA in dbt
  • Learn how to deploy in dbt under a schedule and investigate run time errors
  • Learn how to use Seeds and Analysis in dbt

Requirements

  • Basic SQL knowledge (optional)

Description

Are you looking for a cutting-edge way to extract load and transform your data? Do you want to know more about dbt™ and how to use it? Well, this is the course for you. Welcome to The dbt™ Bootcamp: Transform your Data using dbt™.


In this course you are going to learn all about dbt™, from setting up dbt™ cloud, connecting it to Snowflake or a warehouse of your choice, developing models, creating sources, doing testing, working with the documentation and much more.


This course is for beginners, we will go through a realistic project and cover each of the steps mentioned in a practical approach.


dbt™ is a data modelling tool that makes life much easier for analysts and engineers. It allows you to write SQL queries without having to worry about dependencies. dbt™, like traditional databases, is built on SQL, but it has additional functionality built on top of it utilizing templating engines such as JINJA.

This effectively lets you to retrieve, rearrange, and organize your data using additional logic in your SQL. You may then compile and run this code using dbt's™ run command to retrieve just the pieces you need in the transformations. It can also be swiftly coded, tested, and adjusted without having to wait for it to process all your data. In addition to that, it’s automated documentation is a big time saver.

The project we will be working on is about a fictitious company called GlobalMart. GlobalMart sells household items like furniture, office equipment, Appliances and Electronics. They are in the process of hiring a small data team and would like to try out dbt™ for their data transformations. They require some reporting tables about their profits and want to use dbt™ to transform their data to get them what they want.


By the end of this course, we will work through the project and end up accomplishing the following:


1. Setting up a dbt™ Cloud Account

2. Connecting to a Database (in this case Snowflake)

3. Connecting dbt™ to a repository like GitHub

4. Understanding the dbt™ cloud interface

5. Building and Running Models in dbt™

6. Using Modularity in dbt™

7. Creating and Referencing Sources

8. Performing Tests in dbt™ including Singular and Generic Tests

9. How to Create and Generate Documentation in dbt™

10. How to Deploy in dbt™

11. How to use Jinja

12. Using Macros and Packages in dbt™

13. Using Seeds and Analyses in dbt™


This is a great, comprehensive which will really up-skill you not only in dbt but the extract, load and transform process as well.


Thank you so much for choosing this course and I’ll see you in the next lecture.


Who this course is for:

  • Anyone wanting to get more experience in dbt (Data Build Tool)
  • Anyone wanting to know more about Extract, Load and Transform Process
  • Anyone wanting to start a career in Data Engineering
  • Anyone wanting to gain more experience in Data Analytics

Instructor

Vantage Data
Learn with the team @ Vantage Data
Vantage Data
  • 4.5 Instructor Rating
  • 76 Reviews
  • 501 Students
  • 1 Course

Hey, we're the team at Vantage Data. We are a group of data specialists who have decided to create fun, practical and comprehensive courses about currents tools, platforms and technology in the data space.

Other than being data nerds, we have a platform called Vantage Point which is a no-code, click & go business acceleration tool which enables data driven decisions across businesses all over the world.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.