Home

All courses

Programming in Snowflake Masterclass Hands-On

IT & Software

Other IT & Software

Programming in Snowflake Masterclass Hands-On

for Intermediate Level! by World-Class Snowflake Expert

4.4

(239)

5214 enrolled on this course

Last updated 11/2021

Cristian Scutaru

₹ 3299.0

₹ 4799.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

IMPORTANT:
This course requires an
INTERMEDIATE
level and it may
NOT
be for you if you just recently started with Snowflake, relational databases, with SQL and/or Python programming. It occasionally deals with advanced notions about security, software and data engineering, REST APIs etc, that are not explained here. Check the minimum
Requirements
for this course, and the "
What is NOT Included in This Course
" section below, before buying this course!
Who I Am
The only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.
SnowPro Certification SME (Subject Matter Expert): i.e. many exam questions have been created by me.
Passed four SnowPro certification exams to date (with no retakes): Core, Architect, Data Engineer, Data Analyst.
Specialized in Snowflake for the past few years, I worked for Snowflake Partner companies, and I served dozens of clients in this capacity or as an independent consultant.
Today I continue to work with Snowflake, but I am no longer affiliated with their company in any capacity. I recently left their programs to keep my professional independence.
What You Will Learn
How to access, expand and automate Snowflake through most if not ALL their existing APIs.
How to build useful real-life tools and small apps with Snowflake APIs.
How to ingest CSV and JSON data into Snowflake, through data pipelines and Snowpipe.
How to write medium to complex data analytics queries for Snowflake.
How to optimize queries, compute, storage and overall costs for Snowflake.
How to process and render semi-structured and hierarchical data and metadata in Snowflake.
I tried to cover almost EVERYTHING from Snowflake, only from a programming perspective.
What Snowflake APIs You Will Learn About
SQL (DDL/DML/DCL) and Snowflake Scripting
Stored Procedures, User-Defined Functions (UDFs), User-Defined Table Functions (UDTFs)
Python Client, Snowpark for Python, Python Worksheets
Streamlit Web Apps, Streamlit for Snowflake, Snowflake Native Apps Framework
Secure Data Sharing and Data Clean Rooms
Sharing with private Data Exchange or public Marketplace
Snowflake SQL REST API and Snowpipe REST API
Querying metadata from Account Usage and Information Schema
I tried to cover indeed ALL possible APIs that Snowflake offers today!
What is NOT Included in This Course
Data Science and Machine Learning APIs.
Most external integrations, such as external functions, or Kafka and Spark connectors.
Integrations with data transfer applications or other third-party partner apps.
Client driver programming in Go, PHP, Java etc.
Snowpark programming in Java or Scala.
Main focus was on SQL and Python, with small extra snippets in JavaScript, C#, Java, Scala.
Real-Life Applications You Will Learn To Build
CDC Data Pipelines with streams and tasks, or dynamic tables
Generic hierarchical data viewer
Hierarchical metadata viewer (for data lineage and object dependencies, role hierarchy, etc.)
Enhanced query profile
Script automation accessing the SQL REST API
We’ll build all apps from scratch. We’ll use then Streamlit – for many of them - to create simple web apps, local or remote. We may deploy them into Snowflake, as Streamlit Apps. Or even share them with local partner accounts, as Native Apps.
I sold tools similar to these to real-life clients and Snowflake partners!
No other course, book or documentation around - including those from Snowflake! – will offer as much insights, hands-on exercises and knowledge transfer as my course here, guaranteed!
Enroll today, to keep this course forever. And help me continue to update it with new APIs Snowflake comes frequently up with.
Who this course is for:
Data Engineers new to Snowflake, looking to acquire deep knowledge of the APIs
Software Engineers and Developers looking to access Snowflake in different ways
Data Analysts looking for medium to complex queries they can write for Snowflake
Data Architects looking to design data pipelines for Snowflake
Software Architects looking to design apps and tools with and for Snowflake
Any other practitioner who enjoys data and coding, new or not to Snowflake

What you'll learn

Query anything in Snowflake through SQL and Snowflake Scripting

Use most if not all programming APIs offered by Snowflake

Access and use Snowflake as a software or data developer

Build real-life tools and apps with and for Snowflake

Process and access hierarchical data and metadata in Snowflake Data Cloud

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-This course might NOT be right for you if...

1.2-Welcome to this Course

1.3-Best Ways to Benefit from this Course

1.4-SnowPro Snowflake Certifications: Added Material!

1.5-Initial Requirements and Project Setup

2-Warehouses and Cost Estimates

2.1-Introduction

2.2-Hands On: Sign-up for a Free Trial Account

2.3-Hands On: Use a Very Small Warehouse

2.4-Hands On: Run Query with a Very Large Warehouse

2.5-Hands On: Just Start a Large Multi-Cluster Warehouse

2.6-Review: Overview of the Snowflake Architecture

2.7-Hands On: Apply Best Practices for Data and Warehouses

2.8-Review: Snowflake Best Practices for Compute and Storage

2.9-Check Your Knowledge

3-Loading and Accessing CSV Data

3.1-Introduction

3.2-Hands On: Create Query Context

3.3-Hands On: Infer Schema from Staged CSV Files

3.4-Hands On: Copy Data into Tables

3.5-Hands On: Create External S3 Stage

3.6-Review: End-to-End CSV File Uploading

3.7-Check Your Knowledge

4-Loading and Processing JSON Data

4.1-Introduction

4.2-Review: File Formats

4.3-Hands On: Upload JSON Data

4.4-Hands On: Transform JSON Data

4.5-Review: JSON Data Transformations

4.6-Hands On: Flatten JSON Data

4.7-Review: JSON Data Flattening

4.8-Hands On: Add Constraints and Materialized Views

4.9-Review: Temporary Tables and Materialized Views

4.10-Check Your Knowledge

5-Sample Data Extraction and Generation

5.1-Introduction

5.2-Hands On: Extract Data Samples with Snowflake

5.3-Hands On: Generate Synthetic Data with Snowflake

5.4-Hands On: Generate Synthetic Data with Python

5.5-Review: Data Sample Extraction and Generation

5.6-Review: Sequences and Identity Columns

5.7-Check Your Knowledge

6-Stored Procedures and Recursive SQL

6.1-Introduction

6.2-Hands On: Prepare Hierarchical Data

6.3-Hands On: Query Hierarchical Data with Joins

6.4-Hands On: Query Hierarchical Data with Recursive SQL

6.5-Review: SQL Queries for Hierarchical Data

6.6-Hands On: Create UDFs in SQL

6.7-Hands On: Create Stored Procedure in JavaScript

6.8-Review: Stored Procedures and Functions

6.9-Check Your Knowledge

7-SQL and Snowflake Scripting

7.1-Introduction

7.2-Hands On: Use Case Sensitive Identifiers

7.3-Hands On: Use Identifier References

7.4-Hands On: Access JSON Object Properties

7.5-Review: Identifiers and Variables in Snowflake SQL

7.6-Hands On: Clone Table Data

7.7-Review: Duplicating Table Data and Zero-Copy Cloning

7.8-Hands On: Snowflake Scripting Procedure with Cursor

7.9-Hands On: Snowflake Scripting Procedure with ResultSet

7.10-Hands On: Snowflake Scripting Procedure Calling a JavaScript Function

7.11-Hands On: Test the Generic Hierarchical Viewer in SQL

7.12-Review: Snowflake Scripting

7.13-Hands On: Implement Transaction

7.14-Hands On: More Transaction Use Cases

7.15-Review: Transactions in Snowflake

7.16-Check Your Knowledge

8-Snowflake Data Pipelines

8.1-Introduction

8.2-Batch & Stream Data Transfer to Snowflake

8.3-Hands On: Manual CDC with MERGE Statement

8.4-Hands On: Enable Change Tracking on a Table

8.5-Hands On: CDC with Streams and Tasks

8.6-Hands On: CDC with Dynamic Table

8.7-Review: CDC (Change Data Capture) in Snowflake

8.8-Hands On: Continuous Data Loading with Snowpipe on S3

8.9-Review: Snowpipe on Amazon S3

8.10-Check Your Knowledge

9-Hierarchical Data Visualizations

9.1-Introduction

9.2-Hands On: Transform Tabular Data into JSON Format

9.3-Review: Hierarchical Data Formats (JSON, XML, and YAML)

9.4-Hands On: Show Graphs (with GraphViz)

9.5-Hands On: Show Hierarchical Charts (with Plotly)

9.6-Hands On: Show Animated Charts (with D3)

9.7-Check Your Knowledge

10-Streamlit Web Applications

10.1-Introduction

10.2-Hands On: Create Your First Streamlit Web App

10.3-Hands On: Add Functionality with a Streamlit Tab Control

10.4-Review: Introduction to Streamlit

10.5-Review: Streamlit Layout Components and Interactive Widgets

10.6-Hands On: Cache Streamlit Data

10.7-Review: Streamlit Session and Data Caching

10.8-Hands On: Deploy and Share a Web App in Streamlit Cloud

10.9-Review: Deploying a Web App in Streamlit Cloud

10.10-Check Your Knowledge

11-Client Programming with Snowflake

11.1-Introduction

11.2-Hands On: Install Snowflake Tools and Utilities

11.3-Review: Snowflake Tools and Utilities

11.4-Hands On: Connect to Snowflake from a Python Client

11.5-Hands On: Connect to Snowflake from .NET in C#

11.6-Hands On: Connect to Snowflake from NodeJS in JavaScript

11.7-Review: Snowflake Connector for Python

11.8-Hands On: Connect the Hierarchical Data Viewer to Snowflake

11.9-Check Your Knowledge

12-Snowpark API

12.1-Introduction

12.2-Review: Snowpark for Python Architecture

12.3-Hands On: Create Query with DataFrame API

12.4-Snowpark API: The Object Model

12.5-Hands On: Create Stored Procs and UDFs in Python/Java/Scala

12.6-Review: Procedures and UDFs in Python, Java, Scala

12.7-Hands On: Customize Stored Proc from Python Worksheet

12.8-Review: Python Worksheets

12.9-Hands On: Create and Call Stored Procs and UDFs from Python

12.10-Review: Snowpark for Python

12.11-Check Your Knowledge

13-Streamlit in Snowflake

13.1-Introduction

13.2-Hands On: Deploy a Streamlit Web App in Snowflake

13.3-Review: Streamlit in Snowflake

13.4-Review: Event Tables and Alerts

13.5-Check Your Knowledge

14-Access Control in Snowflake

14.1-Introduction

14.2-Hands On: Create Script for Users, Roles and Privileges

14.3-Hands On: Inspect Users, Roles and Privileges

14.4-Review: Users, Roles and Privileges

14.5-Hands On: Run SnowSQL Scripts using Variable Substitution

14.6-Review: Multi-Tenant Architectures with Var Substitution

14.7-Check Your Knowledge

15-Snowflake REST APIs

15.1-Introduction

15.2-Hands On: Configure Key Pair Authentication and Generate JWT

15.3-Review: Key Pair Authentication in Snowflake

15.4-Hands On: Run a Query from Script with the SQL REST API

15.5-Review: The Snowflake SQL REST API

15.6-Hands On: Ingest Files with Snowpipe REST API

15.7-Review: The Snowpipe REST API

15.8-Check Your Knowledge

16-Data Governance in Snowflake

16.1-Introduction

16.2-Hands On: Tag Objects

16.3-Hands On: Classify Data

16.4-Review: Data Governance in Snowflake

16.5-Hands On: Create a Restricted View

16.6-Hands On: Create a Masking Policy

16.7-Hands On: Create a Tag-Based Masking Policy

16.8-Hands On: Create a Row Access Policy

16.9-Review: Column Masking and Row Access Policies

16.10-Check Your Knowledge

17-Data Sharing in Snowflake

17.1-Introduction

17.2-Hands On: Create an Inbound Data Share

17.3-Hands On: Consume an Outbound Data Share

17.4-Review: Secure Data Sharing and Reader Accounts

17.5-Hands On: Create a Listing for Private Data Shares

17.6-Review: Data Exchange and Snowflake Marketplace

17.7-Hands On: Solve Yao's Millionaire Problem for Data Clean Rooms

17.8-Hands On: Create Data Clean Room with Row Access Policies

17.9-Review: Data Clean Rooms

17.10-Check Your Knowledge

18-Create a Multi-Page Hierarchical Metadata Viewer

18.1-Introduction

18.2-Review: Information Schema vs Account Usage

18.3-Hands On: Create ER Diagram Viewer

18.4-Review: ER Diagram Viewer

18.5-Hands On: Create Users and Roles Inspector

18.6-Review: Users and the Role Hierarchy

18.7-Hands On: Create Object Dependency Inspector

18.8-Review: Object Dependencies in Snowflake

18.9-Hands On: Create Data Lineage Inspector

18.10-Review: Data Lineage in Snowflake

18.11-Hands On: Create Task Dependencies Inspector

18.12-Review: Task Dependencies and Task Workflow Runs

18.13-Hands On: Deploy as Multi-Page Streamlit in Snowflake App

18.14-Check Your Knowledge

19-Snowflake Native App Framework

19.1-Introduction

19.2-Hands On: Deploy the Hierarchical Data Viewer as a Native App

19.3-Review: Snowflake Native App Framework

19.4-Check Your Knowledge

20-Create an Admin Dashboard in Snowsight

20.1-Introduction

20.2-Hands On: Create an Administration Dashboard in Snowsight

20.3-Review: System Views for Account Usage

20.4-Check Your Knowledge

21-Data Analytics with Snowflake

21.1-Introduction

21.2-Hands On: Convert Subqueries to CTEs

21.3-Hands On: Create Aggregated Queries

21.4-Hands On: Pivot and Unpivot Data

21.5-Review: Intermediate Data Analytics in SQL

21.6-Hands On: Query Data from the Past

21.7-Review: Time Travel and Fail-safe

21.8-Check Your Knowledge

22-Advanced Analytics with Snowflake

22.1-Introduction

22.2-Hands On: Query with QUALIFY

22.3-Hands On: Moving Average Query

22.4-Hands On: Query with Rank Functions

22.5-Hands On: Query with Offset Functions

22.6-Review: Window Functions

22.7-Hands On: Use Statistical Functions

22.8-Review: Statistical Functions

22.9-Check Your Knowledge

23-Snowflake Query Optimization

23.1-Introduction

23.2-Hands On: Use the Query History

23.3-Hands On: Use the Result Cache

23.4-Hands On: Interpret the Query Profile

23.5-Hands On: Interpret a Query Plan from EXPLAIN

23.6-Hands On: Enhanced Query Profile and Analyzer

23.7-Review: Query Performance Tools

23.8-Hands On: Inspect a Table Cluster Distribution

23.9-Review: Clustering Keys

23.10-Check Your Knowledge

24-The SnowPro Advanced Data Engineer Certification

24.1-About this Added Material

24.2-General Info about all SnowPro Snowflake Certifications

24.3-Overview of the Advanced Data Engineer Certification

24.4-Sample Questions for the Advanced Data Engineer Exam

24.5-SnowPro Advanced Data Engineer: Practice Tests

25-Wrapping Up

25.1-Congratulations, You Made It!

25.2-Bonus Lecture

Course Categories

Popular Courses

Programming in Snowflake Masterclass Hands-On

Description

What you'll learn

Requirements

Course Content

You May Like