The Data Bootcamp: Transform your Data using dbt™
The Data Bootcamp: Transform your Data using dbt™, available at $69.99, has an average rating of 4.38, with 25 lectures, based on 743 reviews, and has 3628 subscribers.
You will learn about 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 This course is ideal for individuals who are Anyone wanting to get more experience in dbt (Data Build Tool) or Anyone wanting to know more about Extract, Load and Transform Process or Anyone wanting to start a career in Data Engineering or Anyone wanting to gain more experience in Data Analytics It is particularly useful for Anyone wanting to get more experience in dbt (Data Build Tool) or Anyone wanting to know more about Extract, Load and Transform Process or Anyone wanting to start a career in Data Engineering or Anyone wanting to gain more experience in Data Analytics.
Enroll now: The Data Bootcamp: Transform your Data using dbt™
Summary
Title: The Data Bootcamp: Transform your Data using dbt™
Price: $69.99
Average Rating: 4.38
Number of Lectures: 25
Number of Published Lectures: 25
Number of Curriculum Items: 25
Number of Published Curriculum Objects: 25
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- 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
Target Audiences
- 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
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.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction to the Course
Lecture 2: What is dbt™?
Lecture 3: ELT vs ETL – What is better?
Lecture 4: How the Course is Structured
Chapter 2: Setting up dbt
Lecture 1: Reading the Project Brief
Lecture 2: Setting up dbt™ Cloud
Lecture 3: Setting up Snowflake Data Warehouse
Lecture 4: Setting up Github
Lecture 5: Connecting to the Database and Github
Chapter 3: Getting Started with dbt
Lecture 1: Initialising dbt™ Cloud
Lecture 2: Taking a Tour of dbt™ Cloud
Chapter 4: Models and Modularity in DBT
Lecture 1: Developing Models in dbt™
Lecture 2: Understanding Modularity and REF Functions in dbt™
Chapter 5: Working with YML files
Lecture 1: Working with dbt_project.yml
Lecture 2: Working with Sources in dbt™
Chapter 6: Testing and Documentation on dbt™
Lecture 1: Introduction to Testing in dbt™
Lecture 2: How to Create Generic Tests in dbt™
Lecture 3: How to Create Singular Tests in dbt™
Lecture 4: How to Generate and work with dbt™ Documentation
Chapter 7: Using Macros, Packages and Seeds in DBT
Lecture 1: How to use JINJA in dbt™
Lecture 2: How to Create Macros in dbt™
Lecture 3: How to use Packages in dbt™
Lecture 4: How to use Seeds (CSV files) in dbt™
Chapter 8: Deploying on dbt
Lecture 1: Deploying on dbt™
Lecture 2: A Quick Goodbye Note
Instructors
-
Vantage Data
Learn with the team @ Vantage Data
Rating Distribution
- 1 stars: 7 votes
- 2 stars: 15 votes
- 3 stars: 65 votes
- 4 stars: 296 votes
- 5 stars: 360 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024