Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Snowflake Decoded - Master the Fundamental Concepts

Name: Snowflake Decoded - Master the Fundamental Concepts
Rating: 4.5 (16954 reviews)

Become a Snowflake Professional with hands-on training and expert guidance from an industry pro

Created byHamid Qureshi

Last updated 8/2023

English

What you'll learn

Explore the Snowflake essentials: it’s unique architecture and differentiation
Master the staging and ingestion of bulk and streaming data from cloud storage
Discover Snowflake’s value proposition through its pricing model
Harness scalability with virtual warehouse complete clusters
Uncover unique features like zero-copy clones and time travel
Share data securely with Snowflake and non-Snowflake users

Course content

11 sections • 83 lectures • 4h 56m total length

Introduction to this Course2:29
Introduction to the instructor1:22
The instructor brings twenty years of data warehouse and analytics experience, including Snowflake, Teradata, Oracle and Hadoop, blending theory with hands-on exercises to empower professionals to design scalable data solutions.
Introduction to Snowflake3:10
Explore how Snowflake, a cloud-only data warehouse as a service, decouples storage and compute to enable pay-as-you-go scalability on public clouds with virtual warehouses and object storage.
Snowflake Editions1:44
Learn about Snowflake editions—standard, enterprise, business critical, and virtual private snowflake—and how each edition adds features such as time travel, multi-cluster warehouses, dynamic masking, PCI compliance, and isolated compute resources.
Signup for a Snowflake Trial Account6:26
Sign up for a Snowflake trial to receive 30 days of full functionality and $400 in free credit, choose an edition and cloud provider, then activate and log in.
Signup for a Snowflake Trial
Snowflake Web User Interface5:13
Create a virtual warehouse
Introduction to Snowflake

High level view of data loading in Snowflake3:29
Role of Stage in Data Loading2:45
Internal stages & Named Internal Stage2:10
Hands-on: Loading data using named internal stage9:44
Load on-premises data into Snowflake by creating a target table and a named internal stage, then upload with Snow SQL and copy into the airport table.
Lab: Data Loading from on-premises via internal stage
External Stage2:15
Hands-on: Loading data using an external stage12:49
Lab: Loading data using an External Stage
Tables Stage & User Stage2:13
Lab: Data Loading using a Table Stage
Basic Data Transformations while loading data0:55
External Tables: sometimes an alternate to data loading3:18
Unloading / Exporting data from Snowflake4:13
Loading & Unloading Data

Continuous data protection in Snowflake1:06
Back to the future with Time Travel1:54
How Time Travel works in Snowflake2:59
Time Travel Syntax2:16
Hands-on: Time Travel in Action8:06
Lab: Time Travel in Action
Hands-on: Undrop using Time Travel3:34
Lab: Undrop using Time Travel
Introduction to Fail-Safe Storage3:03
Time Travel & Fail-Safe storage costs2:07
Types of tables in Snowflake3:29
Hands-on: Temporary & Transient Tables5:27
Lab: Create Temporary and Transient tables
Continuous Data Protection

Introduction to Zero-Copy Cloning1:47
Learn how Snowflake's zero-copy cloning creates copies of tables, schemas, and databases without physically duplicating data. The clone command captures a snapshot, yielding independent clones with no extra storage.
How Cloning works in Snowflake4:28
Hands-on: Clone a table6:15
Lab: Clone a Table
Hands-on: Clone a complete database & a complete schema4:33
Lab: Clone a complete schema & a complete database
Hands-on: Cloning with Time Travel4:34
Lab: Cloning with Time Travel
Cloning in Snowflake

Secure data sharing in Snowflake2:41
How Data Sharing works2:30
Snowflake offerings for Data Sharing2:32
Direct Sharing3:01
Hands-on: Share a table with another Snowflake account7:58
Share a table between two Snowflake accounts (provider and consumer) by creating a share, granting usage and select, and let the consumer create a read-only database from the share.
Lab: Direct Sharing using SQL
Hands-on: Share a table with another account using the UI6:31
Lab: Direct Sharing using User Interface
Hands-on: Share table with a non-Snowflake customer5:16
Snowflake Marketplace4:46
Explore how Snowflake Marketplace enables many-to-many data sharing of third-party datasets, with free and paid listings, ready-to-query access, and personalized buy requests.
Hands-on: Explore Snowflake Marketplace9:05
Lab: Explore Snowflake Marketplace
Data Exchange2:56
Create and manage a Snowflake data exchange, a private hub for invite-only data sharing where owners invite members, publish listings, and control access for providers and consumers.
Data Sharing

Introduction to Performance Optimization in Snowflake2:22
Explore Snowflake's automatic performance features, including metadata, cache, query result caching, and partition pruning, along with manual options like virtual warehouse scaling and clustering keys to boost query performance.
Understanding Query Execution in Snowflake2:13
Hands-on: Access & View Query Profile7:07
Identify and interpret Snowflake query profiles to measure and improve query performance. Access profiles via query id, history, or user interface to view the graphical processing plan and component statistics.
Lab: Access and Explore Query Profile
Caching in Snowflake2:18
Query Result Cache4:34
Hands-on: Demonstrate Query Result Cache3:47
Lab: Demonstrate Query Result Cache
Metadata Cache1:26
Explore how Snowflake tracks micro partitions by recording min and max values and distinct counts in the metadata cache, enabling selective partition reads and faster queries.
Hands-on: Demonstrate Metadata Cache2:54
Lab: Demonstrate Metadata Cache
Virtual Warehouse or Local Disk Cache1:21
Hands-on: Demonstrate Virtual Warehouse Cache5:27
Demonstrate building and utilizing a virtual warehouse cache across multiple queries, then show how suspending the warehouse purges the cache, affecting subsequent query profiles.
Lab: Virtual warehouse cache reuse
Partition Pruning & Clustering Keys5:09
Scaling up and down a virtual warehouse2:55
Learn how to scale up or scale down virtual warehouses to match the query workload, including multi-cluster scaling for concurrency, with practical syntax to adjust warehouse size.
Multi-cluster virtual warehouse - scaling out3:51
Materialized Views2:51
Introducing Search Optimization Service2:01
Performance Optimization in Snowflake

Introduction to Security in Snowflake3:05
Explore Snowflake's multi-layer security architecture, from data at rest encryption and key rotation to MFA, RBAC, dynamic data masking, OAuth2, and private connectivity, with cloud-provider security layered on.
Encryption at Rest1:39
Snowflake encrypts data with 256-bit encryption, manages keys by default, and rotates them every 30 days; try secret secure combines a snowflake and customer key into a composite master key.
Multifactor Authentication or MFA3:45
Authentication - other aspects1:49
Access Control in Snowflake4:10
Authorization - other aspects5:02
Out of the box roles in Snowflake2:34
Network Layer Security3:32
Security & Access Control in Snowflake

Extending Snowflake2:13
Secure UDFs1:32
Secure UDFs protect data by preventing access to underlying tables and code, weigh security against performance, and decide when views should be secure.
Stored Procedures2:47
Explore how Snowflake stored procedures enable procedural sql with if-else logic, looping, and dynamic sql, and control execution under caller's or owner's rights for recurring administrative tasks.
Snowpark2:13
Explore Snowpark, a library that lets you write data-processing code in Java, Scala, or Python, translated to sql and executed in Snowflake with lazy and parallel execution.
Snowflake Scripting2:27
Extending Snowflake Functionality

Requirements

Basic familiarity with database & data warehousing concepts
Basic familiarity with SQL

Description

Master the fundamental Snowflake concepts and acquire the necessary skills to start implementing Snowflake-based solutions through Snowflake Decoded.

This course covers everything you need to know to become a Snowflake pro.

Whether you’re a:

novice aiming to learn Snowflake from scratch
an IT professional looking to advance your skills
or a technology leader evaluating the Snowflake eco-system…

… this course is tailored for your success.

Topics inside Snowflake Decoded (high-level view)

Introduction - Explore Snowflake’s history and what separates it from traditional databases.

Getting Started - Sign up, set up tools, and create & load our first table.

Architecture - Uncover Snowflake’s unique, decoupled architecture. Learn how it differs from traditional databases. Learn how virtual warehouses enable scalable computing as per demand.

Getting Data into Snowflake - Discover methods for loading data into Snowflake. This includes bulk copy and Snowpipe. Learn to stage data in S3 and handle semi-structured data like JSON.

Time Travel & Zero Copy Clones - Leverage Snowflake’s exclusive features. Learn how Time Travel recovers data and combines it with Cloning for historical data without extra storage costs.

Secure Data Sharing - Unlock effortless data sharing within and outside the Snowflake eco-system. Explore efficient sharing methods while minimizing storage duplication.

Why Snowflake Decoded is unique

Snowflake Decoded is unique to any other Snowflake course because we:

Cover a wide range of topics, from fundamental to advanced levels
Make advanced concepts simple to comprehend using easy-to-understand diagrams
Embrace a hands-on learning approach. You’ll apply your theory in real-world scenarios through hands-on lectures and lab assignments

Final thoughts

By the course’s conclusion, you’ll have the confidence and the skills to implement Snowflake-based solutions - just like the 44,000+ students who have completed this course.

Snowflake expertise is in high demand, opening doors to exciting career opportunities.

Since we’re so confident in the value of this course, we offer a 30-day money-back guarantee. No questions asked.

Don’t delay your journey to Snowflake mastery any longer.

Dive into the world of Snowflake today and elevate your data career to new heights by enrolling now.

Who this course is for:

Beginners aiming to learn Snowflake from scratch
IT professionals looking to advance their skills
Technology leader evaluating the Snowflake eco-system

Snowflake Decoded - Master the Fundamental Concepts

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 20min

Snowflake Architecture8 lectures • 26min

Snowflake Interfaces & Tools2 lectures • 9min

Getting Data into & out of Snowflake10 lectures • 44min

Continuous Data Protection10 lectures • 34min

Cloning in Snowflake5 lectures • 22min

Data Sharing in Snowflake10 lectures • 47min

Performance Optimization in Snowflake15 lectures • 50min

Security & Access control in Snowflake8 lectures • 26min

Extending Snowflake Functionality5 lectures • 11min

Requirements

Description

Who this course is for: