Home

All courses

Snowflake Decoded - Master the Fundamental Concepts

IT & Software

IT Certifications

Snowflake

Snowflake Decoded - Master the Fundamental Concepts

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

4.6

(16010)

59324 enrolled on this course

Last updated 11/2021

Hamid Qureshi

₹ 3999.0

₹ 5499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

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

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

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction

1.1-Introduction to this Course

1.2-Introduction to the instructor

1.3-Introduction to Snowflake

1.4-Snowflake Editions

1.5-Signup for a Snowflake Trial Account

1.6-Signup for a Snowflake Trial

1.7-Snowflake Web User Interface

1.8-Create a virtual warehouse

1.9-Introduction to Snowflake

2-Snowflake Architecture

2.1-Snowflake Architecture sets it apart!

2.2-Traditional Database Architecture

2.3-Snowflake Hybrid Architecture

2.4-Compute Layer - Virtual Warehouses

2.5-Lab: Creating a new Virtual Warehouse

2.6-Storage Layer - Micropartitions

2.7-Cloud Services Layer

2.8-Compute Layer - additional aspects of virtual warehouses

2.9-How is Snowflake costed

2.10-Architecture

3-Snowflake Interfaces & Tools

3.1-Introduction

3.2-Hands-on: Install SnowSQL & connect to your Snowflake instance

3.3-Snowflake Tools & Interfaces

4-Getting Data into & out of Snowflake

4.1-High level view of data loading in Snowflake

4.2-Role of Stage in Data Loading

4.3-Internal stages & Named Internal Stage

4.4-Hands-on: Loading data using named internal stage

4.5-Lab: Data Loading from on-premises via internal stage

4.6-External Stage

4.7-Hands-on: Loading data using an external stage

4.8-Lab: Loading data using an External Stage

4.9-Tables Stage & User Stage

4.10-Lab: Data Loading using a Table Stage

4.11-Basic Data Transformations while loading data

4.12-External Tables: sometimes an alternate to data loading

4.13-Unloading / Exporting data from Snowflake

4.14-Loading & Unloading Data

5-Continuous Data Protection

5.1-Continuous data protection in Snowflake

5.2-Back to the future with Time Travel

5.3-How Time Travel works in Snowflake

5.4-Time Travel Syntax

5.5-Hands-on: Time Travel in Action

5.6-Lab: Time Travel in Action

5.7-Hands-on: Undrop using Time Travel

5.8-Lab: Undrop using Time Travel

5.9-Introduction to Fail-Safe Storage

5.10-Time Travel & Fail-Safe storage costs

5.11-Types of tables in Snowflake

5.12-Hands-on: Temporary & Transient Tables

5.13-Lab: Create Temporary and Transient tables

5.14-Continuous Data Protection

6-Cloning in Snowflake

6.1-Introduction to Zero-Copy Cloning

6.2-How Cloning works in Snowflake

6.3-Hands-on: Clone a table

6.4-Lab: Clone a Table

6.5-Hands-on: Clone a complete database & a complete schema

6.6-Lab: Clone a complete schema & a complete database

6.7-Hands-on: Cloning with Time Travel

6.8-Lab: Cloning with Time Travel

6.9-Cloning in Snowflake

7-Data Sharing in Snowflake

7.1-Secure data sharing in Snowflake

7.2-How Data Sharing works

7.3-Snowflake offerings for Data Sharing

7.4-Direct Sharing

7.5-Hands-on: Share a table with another Snowflake account

7.6-Lab: Direct Sharing using SQL

7.7-Hands-on: Share a table with another account using the UI

7.8-Lab: Direct Sharing using User Interface

7.9-Hands-on: Share table with a non-Snowflake customer

7.10-Snowflake Marketplace

7.11-Hands-on: Explore Snowflake Marketplace

7.12-Lab: Explore Snowflake Marketplace

7.13-Data Exchange

7.14-Data Sharing

8-Performance Optimization in Snowflake

8.1-Introduction to Performance Optimization in Snowflake

8.2-Understanding Query Execution in Snowflake

8.3-Hands-on: Access & View Query Profile

8.4-Lab: Access and Explore Query Profile

8.5-Caching in Snowflake

8.6-Query Result Cache

8.7-Hands-on: Demonstrate Query Result Cache

8.8-Lab: Demonstrate Query Result Cache

8.9-Metadata Cache

8.10-Hands-on: Demonstrate Metadata Cache

8.11-Lab: Demonstrate Metadata Cache

8.12-Virtual Warehouse or Local Disk Cache

8.13-Hands-on: Demonstrate Virtual Warehouse Cache

8.14-Lab: Virtual warehouse cache reuse

8.15-Partition Pruning & Clustering Keys

8.16-Scaling up and down a virtual warehouse

8.17-Multi-cluster virtual warehouse - scaling out

8.18-Materialized Views

8.19-Introducing Search Optimization Service

8.20-Performance Optimization in Snowflake

9-Security & Access control in Snowflake

9.1-Introduction to Security in Snowflake

9.2-Encryption at Rest

9.3-Multifactor Authentication or MFA

9.4-Authentication - other aspects

9.5-Access Control in Snowflake

9.6-Authorization - other aspects

9.7-Out of the box roles in Snowflake

9.8-Network Layer Security

9.9-Security & Access Control in Snowflake

10-Extending Snowflake Functionality

10.1-Extending Snowflake

10.2-Secure UDFs

10.3-Stored Procedures

10.4-Snowpark

10.5-Snowflake Scripting

10.6-Extending Snowflake Functionality

11-Resource Management

11.1-Introduction to Resource Monitors

11.2-Viewing Usage & Billing in Snowflake

11.3-Account Usage Schema

11.4-Information Schema

11.5-Resource Management

Course Categories

Popular Courses

Snowflake Decoded - Master the Fundamental Concepts

Description

What you'll learn

Requirements

Course Content

You May Like