|
Snowflake Introduction & Open forum discussion
|
|
|
|
DAY-1
|
|
|
|
Analytics Engineering Bootcamp-DAY 1 (Snowflake Introduction)
150:00
|
|
|
|
SNOWFLAKE_intorduction.pptx
|
|
|
Snowflake Introduction & Core Concepts
|
|
|
|
Snowflake Introduction & Architecture
|
|
|
|
Snowflake Virtual Warehouse
|
|
|
|
First Quiz to evaluate Architecture fundamentals
|
|
|
|
Query Execution flow
|
|
|
|
Caching in Details
|
|
|
|
Data types and Constraints
|
|
|
|
Common Table Types (Permanent,Transient,Temporary)
|
|
|
|
Analytics Engineering Bootcamp-DAY2
140:00
|
|
|
Data loading in Details
|
|
|
|
File formats & mandatory Parameters
|
|
|
|
Stages & its Type
|
|
|
|
UI Data loading
|
|
|
|
Complete Guide on SnowSQL
|
|
|
|
COPY INTO <TABLE>/<LOCATION>
|
|
|
|
Quiz 2 (Data loading)
|
|
|
|
Analytics Engineering Bootcamp-DAY3
161:00
|
|
|
|
Analytics Engineering Bootcamp-DAY4
158:00
|
|
|
Data Recovery Steps
|
|
|
|
Time travel
|
|
|
|
Zero Copy clone
|
|
|
|
Fail Safe
|
|
|
|
Quiz 3
|
|
|
|
Analytics Engineering Bootcamp-DAY 7
|
|
|
Continuous Data Integration
|
|
|
|
External Stages : Creation & configuration
|
|
|
|
AWS/AZURE Data Integration
|
|
|
|
Snowpipe
|
|
|
|
External Table
|
|
|
|
CDC using Streams
|
|
|
|
Scheduling using TASK
|
|
|
|
SCD type 2 Implementation
|
|
|
|
Analytics Engineering Bootcamp-DAY5
145:00
|
|
|
RBAC & Internals
|
|
|
|
Micro partition & Clustering
|
|
|
|
System Roles & responsibilities
|
|
|
|
Create Custom Roles & Users
|
|
|
|
Implement Data security using Dynamic Masking
|
|
|
|
Analytics Engineering Bootcamp-DAY 6
|
|
|
|
Analytics Engineering Bootcamp-DAY 8
|
|
|
Snowflake Advanced chapter-1
|
|
|
|
Dynamic & Event Tables
|
|
|
|
Directory & Iceberg Tables
|
|
|
|
Hybrid Tables
|
|
|
|
UDF & Stored Procedure for Dynamic SQL
|
|
|
Snowflake Advanced Chapter-2
|
|
|
|
Getting Start with Snowpark
|
|
|
|
Hands on Project with Snowpark
|
|
|
|
Build your firs app with Streamlit
|
|
|
|
Data engineering with Snowflake Notebooks
|
|
|
Snowflake Advanced Chapter-3
|
|
|
|
GIT Integration with Notebook & Worksheets
|
|
|
|
Data Sharing in details
|
|
|
|
Performance optimization in depth
|
|
|
|
Query Profile, QAS, SOS etc
|
|
|
|
Reporting using Snowflake Dashboards
|
|
|
MATILLION - Introduction & UI
|
|
|
|
ETL vs ELT
|
|
|
|
Matillion Introduction & UI deep dive
|
|
|
|
Matillion Different Products
|
|
|
|
Build your first Matillion Pipeline
|
|
|
MATILLION - Transformation Jobs
|
|
|
|
Understand all READ components
|
|
|
|
Practice with JOIN components
|
|
|
|
Common Structured Transformation (Calculator,Filter, Aggregate etc)
|
|
|
|
Semi Structured Transformation (Extract Nested, Flatten etc)
|
|
|
Matillion - Orchestration Jobs
|
|
|
|
Data extraction using S3,ADLS or SFTP etc
|
|
|
|
In Depth Database query component
|
|
|
|
Iterator & Variables
|
|
|
|
Calling Child job from Parent
|
|
|
|
Incremental / Full load pipeline
|
|
|
|
Implement SCD type 2 using matillion
|
|
|
DBT- Introduction & Configuration
|
|
|
|
DBT fitment into ETL world
|
|
|
|
DBT Core /Cloud setup
|
|
|
|
DBT configs & YAML
|
|
|
DBT -Models
|
|
|
|
DBT Model & Sources
|
|
|
|
DBT Materialization
|
|
|
|
DBT seeds
|
|
|
|
CLI commands
|
|
|
DBT - Advanced
|
|
|
|
DBT Jinja's & Macros
|
|
|
|
DBT Hooks
|
|
|
|
DBT Snapshots
|
|
|
|
DBT Variables
|
|
|
DBT Testing & Documentation
|
|
|
End to End Data Migration project-1
|
|
|
Data Analytics Project-2
|
|