Course curriculum

    1. Announcement 001 - You MUST Create a FREE Snowflake account

    1. Labs - Overview

    2. Lab 1 - Load Taxi Trajectory Data

    3. Lab 2 - Transactions

    4. Lab 3 - Unload To Internal Stage

    5. Lab 4 - Load Data to Multiple Tables

    6. Lab 5 - Load Tobacco Data Using Internal Stage - Unguided

    7. Lab 6 - Create Integration Object

    8. Lab 7 - Using Snowflake as Query Engine

    9. Lab 8 - AWS Open Data

    10. Lab 9 - Loading Parquet File

    11. Lab 10 - Finding Bug During Upload to S3

    12. Lab 11 - Loading Json Book Data

    13. Lab 12 - Loading Twitter Data Unstructured

    1. Chapter 1 - Overview and Learning Objectives

    2. Chapter 1.1 - Signing up for Snowflake Trial

    3. Chapter 1.2 - The Snowflake Story

    4. Chapter 1.3 - Creating our first Database & Table

    5. Chapter 1.4 - Snowflake Pricing Overview

    6. Assignment - Create, Load & Query a Table

    7. Quiz - Snowflake Overview

    1. Chapter 2 - Overview and Learning Objectives

    2. Chapter 2.1 - What is a Data Warehouse?

    3. Chapter 2.2 - Why Cloud Computing?

    4. Chapter 2.3 - Snowflake Architecture

    5. Chapter 2.4 - Virtual Warehouse and Scalability

    6. Chapter 2.5 - Snowflake Pricing

    1. Chapter 3 - Overview and Learning Objectives

    2. Chapter 3.1 - Install Snow CLI

    3. Chapter 3.2 - Introduction to Stages

    4. Chapter 3.3 - Types of Internal Stages

    5. Chapter 3.4 - External Internal Stage Diff

    6. Chapter 3.5 - Creating Stage Obj (Fileformat Obj)

    7. Chapter 3.6 - Upload Data Using Snow CLI

    8. Chapter 3.7 - Download Data Using Snow CLI

    9. Chapter 3.8 - Using Different Stage Types

    10. Chapter 3.8A - Taxi Trajectory - Data Load Demo - 1( Preparing Data)

    11. Chapter 3.8B - Taxi Trajectory - Data Load Demo - 2 (Loading Sample File)

    12. Chapter 3.8C - Taxi Trajectory - Data Load Demo 3 ( Understanding Copy Command Performance )

    13. Chapter 3.8D - Taxi Trajectory Copy Command Performance

    14. Chapter 3.9 - Policy for External Stage

    15. Chapter 3.10 - Role for External Stage

    16. Chapter 3.11 - Creating Integration Obj

    17. Chapter 3.12 - Load from S3 to Snowflake

    18. Chapter 3.13 - Upload to S3 from Snowflake

    19. Chapter 3.14 - Snowpipe Demo

    20. Lab 3.1 - Connect Tasks Together

    21. Lab 3.2 - Create a Stream

    22. Lab 3.3 - Create a Task

    23. Lab Submission - Module 3 (Submit all labs for this module AT ONCE, in a single file)

    1. Chapter 4 - Overview and Learning Objectives

    2. Chapter 4.1 - Performance Optimisation

    3. Chapter 4.2 - Dedicated Virtual Warehouse

    4. Chapter 4.3 - Dedicated Virtual Warehouse Hands On

    5. Chapter 4.4 - Scale Up Virtual Warehouse

    6. Chapter 4.5 - Scale Out Virtual Warehouse

    7. Chapter 4.6 - Auto Scaling

    8. Chapter 4.7 - Maximize Cache Usage

    9. Chapter 4.8 - Lab - Maximize Cache Usage

    10. Chapter 4.9 - Clustering Keys

    11. Chapter 4.10 - Lab - Clustering Keys

About this course

  • Free
  • 94 lessons
  • 5.5 hours of video content