Snowflake

Snowflake Course

Dr. Emily Carter

AI Research Scientist

Module 1: Cloud Data Warehousing Concepts

  • Introduction to Data Warehousing & Modern Cloud Platforms

  • Traditional vs. Cloud Data Warehousing

  • Snowflake Overview & Key Features (Elasticity, Pay-per-use, Security)

  • Data Warehousing on Multi-Cloud (AWS, Azure, GCP)

  • Hands-on Labs:

    • Set up a Snowflake trial account

    • Load sample data into Snowflake warehouse

  • Introduction to AWS Cloud & Global Infrastructure
  • Identity & Access Management (IAM) – Users, Groups, Roles, Policies
  • Compute with Amazon EC2 (Launching, Configuring, Auto Scaling)
  • Storage with Amazon S3 (Buckets, Versioning, Lifecycle Policies)
  • Networking with Amazon VPC (Subnets, Routing, Security Groups, NAT)
  • Real-World Applications (Hosting, Security, Networking)

Module 2: Snowflake Architecture (Virtual Warehouse, Storage, Compute)

  • Snowflake Multi-Cluster Shared Data Architecture

  • Virtual Warehouses: Sizing, Scaling, Cost Management

  • Data Storage Layers & Data Compression

  • Secure Data Storage and Access Controls

  • Hands-on Labs:

    • Configure and manage virtual warehouses

    • Load structured/semi-structured data (CSV, JSON, Parquet)

Module 3: SQL Operations, Views, Streams & Tasks

  • Writing SQL Queries in Snowflake

  • Views: Standard vs. Secure Views

  • Time-based Data Pipelines with Streams

  • Tasks for Scheduling & Automation

  • Snowflake Functions & Procedures

  • Hands-on Labs:

    • Create and query views

    • Automate data pipeline with Streams & Tasks

Module 4: Data Sharing, Time Travel & Cloning

  • Secure Data Sharing across Accounts & Regions

  • Data Marketplace in Snowflake

  • Time Travel for Historical Data Recovery

  • Zero-Copy Cloning for Dev/Test Environments

  • Best Practices in Data Governance with Snowflake

  • Hands-on Labs:

    • Share data securely with another Snowflake account

    • Use Time Travel & Cloning for data recovery and testing

Module 5: Capstone Projects

Build a BI Dashboard with Snowflake + Power BI/Looker

  • Load & Transform Business Data in Snowflake

  • Automate ETL Workflow with Streams & Tasks

  • Connect Snowflake with Power BI/Looker for Visualization

  • Deliverable: Interactive BI Dashboard with real-time data from Snowflake

Tools Covered

  • Snowflake Features: Virtual Warehouse, Secure Data Sharing, Time Travel, Cloning
  • SQL Operations: Views, Streams, Tasks, Stored Procedures
  • ETL/BI Tools: Power BI, Looker, Tableau (integration with Snowflake)
  • Cloud Platforms: Snowflake on AWS, Azure, GCP

$199

Join Class

Class Features

  • Hands-on Snowflake Labs with Real-Time Datasets
  • Enterprise Use-Cases in Data Warehousing & BI
  • Resume-Ready Capstone Project for Data Engineer/BI Rol
  • Certification Guidance: SnowPro Core Certification
  • Verified Certificate of Completion

FAQS

Frequently Asked Question

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.