Grow Data Skills

Low Code SQL Driven ETL - DBT Bootcamp (Live Classes)

LanguageEnglish
Sessions 12
Duration 1.5 Months
Starts On 11-May-2024
Validity 1 Year
Mode Live

INR 2400

Admission Open

This course includes

30+ hours content lecture
Live doubt session after each class
2 Industry level real world projects
Learn while solving real life examples in lectures
Projects will be covered from scratch
Hands on exercises & quizzes after each module
Career & interview preparation guidance
Resume preparation session
Linkedin profile making session
Certificate of completion

Show More

Tools you'll learn

Course Content

Data Architecture Overview
Warehousing Fundamentals
Modern Data Stack
DBT Overview: Introduction, Market Share, Competitors, and Architecture Overview

Installation & Setup of the tools & environment (dbt, python, snowflake)
Interface Walkthrough of dbt
dbt concepts - Models, project setup, and materializations
Creating the dbt data models
SQL queries for dbt - DQL Commands
Creating Low Code SQL ETL Pipeline using dbt

dbt advance concepts - snapshots, hooks
dbt data loading techniques - full load vs incremental load
dbt templating using jinja
Creating Row Level Security in dbt
Orchestrating dbt pipelines
CI/CD of dbt pipelines with Github
dbt Best practices

dbt version control
dbt governance of data models
dbt testing of data models
dbt documentation

Project 1: An e-commerce company has its raw, unclean data from source systems present in snowflake warehouse. Their goal is to setup a end to end data pipeline that includes data extraction, data cleansing, and the creation of a golden layer for storing the transformed data.

Approach:
- 📍 Setup Snowflake + Data Loading
- 📍 Setup dbt
- 📍 Creating Low Code SQL dbt Pipelines
- 📍 Creating Transformed Models (Facts and datamarts)
- 📍 Testing the dbt pipeline
- 📍 Deploying the model using Airflow

Project 2: A leading edtech platform, is setting up an initiative to modernize their ELT pipelines, data transformation & management practices. They want to setup a pipeline that should enable them to do the data transformation while following best practices of Software engineering like CI/CD, Documentation, testing the pipelines & finally deploying the pipeline.

Approach:
- 📍 Setup dbt
- 📍 Creating the dbt Pipelines
- 📍 Setting up the data transformation pipelines to clean the data
- 📍 Creating the documentation of the datamodel using yaml files
- 📍 Unit testing the deployed pipeline using dbt generic & custom tests
- 📍 Setting up CI/CD pipeline with Github

Attention Seeking Resume Preparation and Interview Strategies
Strategies To Crack Tech Interviews
Linkedin Profile Making
How To Expand Your Professional Network On Linkedin
How To Use Various Job Portals
How To Approach For Referrals

Course Schedule

Course Starts:

Live

11-May-2024

Total Sessions:

12

Class Schedule:

LIVE [Saturday, Sunday]

Class Timings:

Saturday & Sunday [12:00 PM - 02:00 PM Live Teaching, 02:00 PM to 02:45 PM Live Doubt Session] (IST)

Mode of the Course:

Live mode

Class Duration:

2 Hours Live Teaching, 45 minutes Doubt Solving

Class Recording Provided:

Yes

Course Validity:

1 year

Prerequisite:

Passion And Willingness To Learn

Instructor

Sahil Choudhary

Sahil is a Google Certified Data Analyst and a Senior Data Analyst at Sigmoid Analytics. He has worked with startups and Fortune 500 companies, helping them make scalable data-driven decisions. He mentored over 350 students in analytics domain and developed third party products and has written multiple whitepapers for BI applications.

Low Code SQL Driven ETL - DBT Bootcamp (Live Classes)

INR 2400

Copyright © 2023 Grow Data Skills All Rights Reserved

How can I help you?