inflearn logo

DBT with a Silicon Valley Engineer

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

(4.8) 14 reviews

378 learners

Level Basic

Course period Unlimited

SQL
SQL
Data Engineering
Data Engineering
data-analysis
data-analysis
dbt
dbt
Data literacy
Data literacy
SQL
SQL
Data Engineering
Data Engineering
data-analysis
data-analysis
dbt
dbt
Data literacy
Data literacy

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

gs

100% enrolled

It was great because the concepts were easy to understand. If you create an advanced application course, I will study hard and take it.

5.0

Ji Hyun Kim

33% enrolled

First of all, both the conceptual explanations and the hands-on exercises feel like they contain only the essentials without any fluff. I also like that the explanations aren't overly difficult.

5.0

김두현

57% enrolled

The instructor explains the practice environment and source code examples very well. (If my English were better, I would have been even more satisfied.)

What you will gain after the course

  • Understanding the complete workflow of how modern data teams work with dbt

  • Organize and extend complex SQL into structured models

  • Practical analytical engineering sense that can be applied immediately to real work

  • Improving Data Reliability through Testing and Documentation

🚀 Beyond SQL, Real Analytics: dbt Analytics Engineering That Works in Practice

In this course, you'll learn how to build a modern data analytics environment using dbt.
Going beyond simply writing SQL queries, we cover the process of designing maintainable analytical models and creating
reliable data pipelines through testing and documentation..

You can understand the core concepts of analytics engineering used by actual data teams in a practical way, connecting modeling, testing, and documentation in one unified flow.

#SQL, #Database, #DataModeling, #dbt, #HandsOn

🏢 What fields is this mainly used in?

The dbt and analytics engineering approaches covered in this course are widely used in the following fields.

  • 📊 Data Analytics Team (Analytics / BI)

  • 🧠 Analytics Engineer

  • 🏗️ Data Engineering Organizations

  • 🏢 Modern data stack environments from startups to large enterprises

  • ☁️ Cloud-based data warehouses (BigQuery, Snowflake, Redshift, etc.)

🎯 Course Planning Background

In practice, many teams still struggle with
"SQL that works but nobody trusts"
"analysis queries where no one knows who created them."

I also repeatedly experienced these problems in the field,
and have been adopting dbt and analytics engineering approaches as the solution.

This course is designed to help you understand and apply dbt not through theoretical explanations, but exactly as it's used in real data teams. It's created to help those who want to turn data into 'manageable assets' beyond just SQL.

👉 What you'll learn

🔑 Analytics Engineering with dbt

You'll learn the complete workflow of how modern data teams use dbt to build analytical data. You'll understand how to transform ad-hoc SQL into reusable and manageable analytical models. You'll clearly define dependencies between models and design a structure that refines data step by step.

🧪 Testing & Documentation for Trusted Data

You'll learn how to transform data from "plausible-looking results" into trusted analytical assets. Leverage dbt's testing features to validate data quality and build an analytical environment that the entire team can understand through automated documentation.

Modern analytics starts here.

📌 Notes Before Taking the Course

🖥️ Practice Environment

  • Operating System and Version (OS): Windows, macOS, Linux, Ubuntu

  • Tools Used:

    • dbt Core (Open Source)

    • Python 3.9 or higher

    • Docker & Docker Compose (for unified practice environment)

    • Visual Studio Code or your preferred code editor

  • PC Specifications:

    • CPU: 2 cores or more

    • Memory (RAM): 8GB or more recommended (minimum 4GB)

    • Disk: 10GB or more of free space

📘 Learning Materials

  • Lecture slides (PDF / PPT)

  • Source code for hands-on practice (entire dbt project)

⚠️ Prerequisites and Important Notes

  • Basic SQL usage experience is required.

    (SELECT, JOIN, GROUP BY level)

  • In the course, we will be using PostgreSQL in a Docker environment.

    Don't worry if Docker is still unfamiliar to you! 😊

    I have a free Docker course available, so if you need it, feel free to check it out and you'll be able to follow along quickly. 👉 https://inf.run/KkNw9

🧩 Great to take together

A practical, hands-on course that allows even SQL beginners to start easily and immediately apply what they learn. ✨

Pulling data with SELECT, connecting with JOIN, organizing with GROUP BY, and more

Let's learn only the most frequently used features in real work, easily and enjoyably! 📊

We'll minimize complex explanations,

"Ah, this is why SQL is important!" The course proceeds with realistic, immediately understandable examples. 💡

Data Analyst, Developer, Data Engineer…

No matter which path you choose, SQL is an essential skill. 🚀

With this one course, you'll build a solid foundation,

I'll help you develop the data intuition to solve problems on your own in real-world situations! 🔥

Recommended for
these people

Who is this course right for?

  • 👨‍💻 Those who use SQL but always feel their analysis structure is lacking

  • 🧩 Those who want to make analysis results more reliable

  • 🚀 Those who want to learn how modern data teams work

  • 📈 Those who want to advance their data career to the next level

  • 🔥 For those who want to break free from ad-hoc SQL

Need to know before starting?

  • ✅ Basic SQL experience is sufficient.

  • 📊 If you understand SELECT, JOIN, and GROUP BY, you'll be able to follow along without any problems.

  • 🚀 If you have experience in data analysis or data engineering, you can understand it more quickly.

Hello
This is altoformula

21,606

Learners

1,092

Reviews

341

Answers

4.8

Rating

30

Courses

Are you going to finish in Korea? Penetrate the global market with English! 🌍🚀

Hello. I majored in Computer Science (EECS) at UC Berkeley 💻, have worked as a software engineer in Silicon Valley for over 15 years, and am currently a Staff Software Engineer working with Big Data and DevOps at a Big Tech headquarters in Silicon Valley.

  • 🧭 I would now like to share the technologies and know-how I learned firsthand at the forefront of innovation in Silicon Valley with all of you through online lectures.

  • 🚀 Join me, having learned and grown at the forefront of technological innovation, and develop the skills to compete on the global stage!

  • 🫡 I may not be the smartest, but I want to emphasize that you can achieve anything if you stay consistent and never give up. I will always be by your side, supporting you with great resources.

 

More

Curriculum

All

21 lectures ∙ (2hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

14 reviews

4.8

14 reviews

  • jejupeter님의 프로필 이미지
    jejupeter

    Reviews 13

    Average Rating 5.0

    5

    33% enrolled

    • altoformula
      Instructor

      Hello Jeju Peter, Thank you for taking the time to leave such a great review.

  • s1121238291님의 프로필 이미지
    s1121238291

    Reviews 80

    Average Rating 4.9

    5

    100% enrolled

    • altoformula
      Instructor

      Hello SPRING, Thank you for taking the time to leave such a great review.

  • kesugwa님의 프로필 이미지
    kesugwa

    Reviews 3

    Average Rating 5.0

    5

    33% enrolled

    • altoformula
      Instructor

      Hello kesugwa, Thank you so much for taking the time to leave such a great review!

  • sdj021876279님의 프로필 이미지
    sdj021876279

    Reviews 1

    Average Rating 5.0

    5

    33% enrolled

    First of all, both the conceptual explanations and the hands-on exercises feel like they contain only the essentials without any fluff. I also like that the explanations aren't overly difficult.

    • altoformula
      Instructor

      Hello Ji Hyun Kim, Thank you for taking the time to leave such a great review.

  • luna22ee0985님의 프로필 이미지
    luna22ee0985

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    It was great because the concepts were easy to understand. If you create an advanced application course, I will study hard and take it.

    • altoformula
      Instructor

      Hello gs, Thank you for taking the time to leave such a great review. I will also look into the advanced course.

altoformula's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$33,000.00

25%

$34.10