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