Snowflake for Developers
4.3 (197 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,267 students enrolled

Snowflake for Developers

Fastrack yourselves to using Snowflake like a pro in about 4 hours.
4.3 (197 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,267 students enrolled
Created by Ashish Khaitan
Last updated 4/2020
English
English [Auto]
Current price: $20.99 Original price: $29.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 14 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand the basics of data warehousing for our beginner audience
  • Start using the Snowflake cloud data warehouse after this course as a pro
  • Understand deep architectural concepts and firm their understanding on the technical implementation of the Snowflake Cloud Data Warehouse. Enhance understanding of Snowflake cloud Data warehouse's performance tuning and debugging of complex issues.
  • Interact with Snowflake cloud data warehouse user interface and create database objects
  • Understand Snowflake cloud data warehouse 's data loading and querying options and best practices
  • Learn Snowflake features like Snowpipes, SnowSQL, Time Travel, Secured Views, and Secured Data Sharing.
  • Use Python connector and code to work with the Snowflake Cloud Data warehouse as an example for use in the daily implementation.
Requirements
  • Understanding of Databases and SQL basic knowledge
  • Some exposure to programming languages for advanced topics
Description

This course assists in developing a solid understanding of Snowflake's Cloud Data Warehouse.

Snowflake for Developers is not a scripted course with a steady pace of reading and death by power-point. It is an intense, involved, and engaging course that has its ups and downs, success and on-purpose failures, and the aha moments. This course is your ultimate companion to take you on a journey of learning Snowflake Cloud Data warehouse.

I would recommend previewing the "Introduction to Data Warehouse" lecture completely for its full 10 minutes length to understand what I mean.

Snowflake for Developers starts with the basics of data warehousing concepts to bring our beginner audience up to speed before going deep into Snowflake.

The course is not designed intentionally for any Certification exam preparation but geared more towards practical use in day to day implementations for Engineers and Architects.


Welcome aboard to Snowflake for Developers!

Who this course is for:
  • Existing Data Professionals, Full Stack Developers, Data Analysts, Data Engineers, and Software Developers.
  • Database developers, Database Administrators, Business intelligence professionals
  • Anyone curious to understand cloud-scale data warehousing and has basic SQL knowledge.
  • If you are currently a Teradata, HP Vertica, Netezza, or Oracle Professional, this course makes your resume match current trends and market-ready.
Course content
Expand all 23 lectures 04:20:42
+ Getting Started
4 lectures 21:12

A brief introduction to your trainer, information about his background and his experience with Snowflake cloud data warehouse

Preview 01:38

This lecture provides a brief overview of the course Snowflake for Developers. Discussed sections and topics covered during this entire training and what to expect.

Preview 02:56

This lecture introduces users to Data Warehouse Basic concepts. Users will understand the definition and typical architecture of a data warehouse system whether on-premises or cloud, Snowflake or otherwise.

Preview 10:08

This lecture provides a a beginners introduction to Snowflake Cloud Data warehouse. Develop understanding of what SaaS means from Snowflake's perspective and give an overview of its features as a SaaS offering.

Introduction to Snowflake
06:30
+ Snowflake Architecture
4 lectures 44:39

This lecture provides users with high level concepts in distributed computing and how Snowflake utilizes those concepts to create its own unique architecture. The lecture introduces the three architectural layers of Snowflake Cloud Data Warehouse namely

  1. Data Storage

  2. Virtual Warehouse

  3. Cloud Services

Overview of Snowflake Architecture
08:26

This lecture will review the snowflake Data storage architecture.

It will develop understanding of:

  1. Blob Storage – AWS's S3 Capabilities and its influence on Snowflake's design decisions

  2. How data is stored in a table structure

  3. Concept of clustering

Deep Dive - Data Storage
10:19

This lecture will review Snowflake’s Virtual Warehouse Architectural Concepts. The lecture will take a deep dive into concepts like

  1. Caching mechanism of Snowflake

  2. File Stealing process

  3. Execution engine capabilities

Deep Dive - Virtual Warehouse
15:50

This lecture will review Snowflake’s 3rd layer in its architecture – The Cloud Services.

  1. We will understand the functions of Cloud Services

  2. Learn about query management.

  3. Take a deep dive into concurrency control

  4. We will understanding the concept of query pruning.

Deep Dive - Cloud Services
10:04
Review our Snowflake Architecture Knowledge
5 questions
+ Working with Snowflake - I
7 lectures 01:08:15

A brief description of content of sections here

Section Overview
01:15

Quick walk through on creating a trial account with snowflake.

Create a Trial Account
02:22

Description of various Editions available within Snowflake and their differences. Also discusses Snowflake's Pricing model which is separate storage and compute

Snowflake Editions and Pricing
03:58

Covers basics of Snowflake's features that are either different or new concepts from traditional databases or data warehouse. Covers topics like

1. Stages

2. File Formats

3. Sequences

4. Security Basics

Things We should know
09:16

The first part of web interface walk through covers basics of Snowflake's Web User Interface. This part covers functions like Help, Partner, Profile management.

Snowflake Web Interface - I
12:52

The Second part in the Web user interface walk through covers more detail coverage on features and functions like History, Worksheets, Warehouses and Shares

Snowflake Web Interface - II
12:54

This final lecture in Snowflake Web user interface takes a deep dive into the database function and digs deeper into Databases, Schema, Tables, creating a table and loading data via Stage etc..

Closer Look - Snowflake Database
25:38
Web Interface Skills Test
5 questions
+ Working with Snowflake - II
3 lectures 01:02:21

This Lecture Helps understand various options to load data into snowflake. It also provides a demo using python code to automated data loading.

Loading data to Snowflake
21:15

This lecture helps understand Snowflake's Transformation capability while loading data and once data is in snowflake. It highlights Snowflake's Transform (T) capabilities in the  Extract Load and Transform (ELT) realm of things. Demo includes transformation during load and after load and JSON object capabilities.

Data Transformation in Snowflake
25:55

This Lecture provides in depth understanding of how to consume data from Snowflake for Analytical other purposes. Demo includes usage of Purpose Built Snowflake Connectors, JDBC Drivers, ODBC Drivers etc..

Consuming Data From Snowflake
15:11
+ Snowflake Features
5 lectures 01:04:15

Describes Snowflake's Snowpipes - Its auto ingestion mechanism for data stored in cloud storage and ingestion pipeline as soon as the file hits the source location.

Snowpipes
12:43

This Lecture highlights Snowflake's Time Travel Capabilities

Time Travel in Snowflake
07:39

Provides Introduction to Snowflake CLI called SnowSQL

Introduction to Snowflake CLI - SnowSQL
07:21

This lecture explains the Snowflake Secured Views, why they are essential, and how to use them.

Secured Views
11:20

This lecture is a complete overview of Snowflake Data Sharing concepts. It discusses the importance of data sharing, its limitations, and other restrictions. It explains how to set data sharing up and running and its top Use-cases. The lecture also talks about reader accounts and their use with data sharing.

Data Sharing
25:12