Course curriculum

  • 1

    Welcome to the course!

    • About this course: Overview, Learning Outcomes, Who Should Enroll...
    • Curriculum Description
    • Instructor bio - Hamid Qureshi
    • Instructor bio - Pradeep HC
    • Key pointers for this program
    • Some added benefits
  • 2

    Calendar, Teams Channel and More

    • Course Calendar
    • Teams Channel (Discussion Forum)
  • 3

    Program Announcements

    • Announcement 001 - You MUST Create a FREE Snowflake account
    • Announcement 002 - Copy of file to "share a table" with Snowflake
  • 4

    Live Sessions - Recordings and Slides

    • SLIDES - Kick-Off Webinar - Spark, Hadoop and Snowflake
    • SLIDES (OF LIVE SESSIONS) - Week 1 - Session #01
    • RECORDING (OF LIVE SESSIONS) - Week 1 - Session 01 - Intro to Program Webinar
    • RECORDING (OF LIVE SESSIONS) - Week 1 - Session 01
    • SLIDES (OF LIVE SESSIONS) - Week 1 - Session #02
    • RECORDING (OF LIVE SESSIONS) - Week 1 - Session 02
    • SLIDES (OF LIVE SESSIONS) - Week 1 - Session #03
    • RECORDING (OF LIVE SESSIONS) - Week 1 - Session 03
    • SLIDES (OF LIVE SESSIONS) - Week 1 - Session #04
    • RECORDING (OF LIVE SESSIONS) - Week 1 - Session 04
    • SLIDES (OF LIVE SESSIONS) - Week 2 - Session #05
    • RECORDING (OF LIVE SESSIONS) - Week 2 - Session 05
    • RECORDING (OF LIVE SESSIONS) - Week 2 - Session 06 (Pradeep)
    • RECORDING (OF LIVE SESSIONS) - Week 2 - Session 06 (Hamid)
    • RECORDING (OF LIVE SESSIONS) - Week 2 - Session 07
    • RECORDING (OF LIVE SESSIONS) - Week 3 - Session 08
    • RECORDING (OF LIVE SESSIONS) - Week 3 - Session 09
    • Labs - Final Session
    • RECORDING (OF LIVE SESSIONS) - Week 4 - Session 10
  • 5

    Labs - Data Loads and Processing

    • Labs - Overview
    • Lab 1 - Load Taxi Trajectory Data
    • Lab 2 - Transactions
    • Lab 3 - Unload To Internal Stage
    • Lab 4 - Load Data to Multiple Tables
    • Labs Submission - 1 - 4 (Submit all labs for this module AT ONCE, in a single file)
    • Lab 5 - Load Tobacco Data Using Internal Stage - Unguided
    • Lab 6 - Create Integration Object
    • Lab 7 - Using Snowflake as Query Engine
    • Lab 8 - AWS Open Data
    • Labs Submission - 5 - 8 (Submit all labs for this module AT ONCE, in a single file)
    • Lab 9 - Loading Parquet File
    • Lab 10 - Finding Bug During Upload to S3
    • Lab 11 - Loading Json Book Data
    • Lab 12 - Loading Twitter Data Unstructured
    • Labs Submission - 9 - 12 (Submit all labs for this module AT ONCE, in a single file)
  • 6

    Module 1 - Snowflake Introduction

    • Module 1 - Overview and Learning Objectives
    • Module 1.1 - Signing up for Snowflake Trial
    • Module 1.2 - The Snowflake Story
    • Module 1.3 - Creating our first Database & Table
    • Module 1.4 - Snowflake Pricing Overview
    • Assignment - Create, Load & Query a Table
    • Quiz - Snowflake Overview
  • 7

    Module 2 - Snowflake Architecture

    • Module 2 - Overview and Learning Objectives
    • Module 2.1 - What is a Data Warehouse?
    • Module 2.2 - Why Cloud Computing?
    • Module 2.3 - Snowflake Architecture
    • Module 2.4 - Virtual Warehouse and Scalability
    • Module 2.5 - Snowflake Pricing
  • 8

    Module 3 - Data Loading in Snowflake

    • Module 3 - Overview and Learning Objectives
    • Module 3.1 - Install Snow CLI
    • Module 3.2 - Introduction to Stages
    • Module 3.3 - Types of Internal Stages
    • Module 3.4 - External Internal Stage Diff
    • Module 3.5 - Creating Stage Obj (Fileformat Obj)
    • Module 3.6 - Upload Data Using Snow CLI
    • Module 3.7 - Download Data Using Snow CLI
    • Module 3.8 - Using Different Stage Types
    • Module 3.8A - Taxi Trajectory - Data Load Demo - 1( Preparing Data)
    • Module 3.8B - Taxi Trajectory - Data Load Demo - 2 (Loading Sample File)
    • Module 3.8C - Taxi Trajectory - Data Load Demo 3 ( Understanding Copy Command Performance )
    • Module 3.8D - Taxi Trajectory Copy Command Performance
    • Module 3.9 - Policy for External Stage
    • Module 3.10 - Role for External Stage
    • Module 3.11 - Creating Integration Obj
    • Module 3.12 - Load from S3 to Snowflake
    • Module 3.13 - Upload to S3 from Snowflake
    • Module 3.14 - Snowpipe Demo
    • Lab 3.1 - Connect Tasks Together
    • Lab 3.2 - Create a Stream
    • Lab 3.3 - Create a Task
    • Lab Submission - Module 3 (Submit all labs for this module AT ONCE, in a single file)
  • 9

    Module 4 - Performance Optimization

    • Module 4 - Overview and Learning Objectives
    • Module 4.1 - Performance Optimisation
    • Module 4.2 - Dedicated Virtual Warehouse
    • Module 4.3 - Dedicated Virtual Warehouse Hands On
    • Module 4.4 - Scale Up Virtual Warehouse
    • Module 4.5 - Scale Out Virtual Warehouse
    • Module 4.6 - Auto Scaling
    • Module 4.7 - Maximize Cache Usage
    • Module 4.8 - Lab - Maximize Cache Usage
    • Module 4.9 - Clustering Keys
    • Module 4.10 - Lab - Clustering Keys
  • 10

    Module 5 - Time Travel

    • Module 5 - Overview and Learning Objectives
    • Module 5.1 - Back to the Future with Snowflake
    • Module 5.2 - Lab - Travel to a Time or Before a Query
    • Module 5.3 - Undrop Databases, Schemas & tables
    • Module 5.4 - Fail Safe in Snowflake
    • Module 5.5 - Lab - Failsafe Storage Usage
    • Module 5.6 - Zero Copy Cloning
    • Module 5.7 - Zero Copy Cloning with Time Travel
  • 11

    Module 6 - Secure Data Sharing

    • Module 6 - Overview and Learning Objectives
    • Module 6.1 - Secure Data Sharing
    • Module 6.2 - Sharing Views
    • Module 6.3 - Sharing with a Snowflake User
    • Module 6.4 - Sharing Who's Compute is Used
    • Module 6.5 - Sharing Data Always Uptodate
    • Module 6.6 - What is a Share?
    • Module 6.7 - Sharing with Non-Snowflake Users
    • Module 6.8 - Sharing Complete Databases and Schemas
    • Module 6.9 - Lab - Sharing - Through Web UI
  • 12

    Module 7 - Snowflake Access Management

    • Module 7 - Overview and Learning Objectives
    • Module 7.1 - Snowflake Approach to Access Control & Key Concepts
    • Module 7.2 - Out of the Box Snowflake Roles
    • Module 7.3 - Role Hierarchy in Snowflake
    • Module 7.4 - ACCOUNTADMIN role
    • Module 7.5 - Outline of the IAM Hands on Lectures
    • Lab - Demonstrating ACCOUNTADMIN role
    • Module 7.6 - SECURITYADMIN role
    • Lab - Demonstrating SECURITYADMIN role
    • Module 7.7 - SYSADMIN role
    • Lab - Demonstrating SYSADMIN role
    • Lab - Demonstrating use of the Custom Roles
    • Module 7.8 - Custom Roles
    • Module 7.9 - Public Role
    • Assignment - Assign Privileges Through a New Custom Role