Snowflake Database - Tips, Techniques and Cool Stuff

This course is packed with tips, techniques and just cool stuff that demonstrates why Snowflake is so popular

4.61 (123 reviews)
Udemy
platform
English
language
Other
category
instructor
919
students
5 hours
content
May 2021
last update
$54.99
regular price

What you will learn

Web UI tips and techniques

Working with query and results history

Dozens of SQL tips and techniques

Many cool features and functions of Snowflake

Techniques for analyzing data

Tips for monitoring warehouse usage

Description

Snowflake was founded in 2012 and released in late 2014. The company was founded by Benoit Dageville, Thierry Cruanes and Marcin Żukowski, who, between them, have over 120 patents. Dageville (PhD) spent 16 years at Oracle as an architect. Cruanes spent 13 years at Oracle focused on the optimization and parallelization layers in Oracle databases including as lead for the optimization group. Zukowski invented vectorized query execution for databases. His innovation emerged from his PhD research into optimizing database query execution for modern processors. These three legends have created a company that has currently has 250 petabytes under management, 1,300 partners, over 4,000 customers and $265M in revenue in 2020.

Since its release it has acquired close to 20% of the data warehouse market. It's no wonder. Snowflake is built from the ground up to be unique and purely cloud-based. In this course we show you dozens of tips, tricks and demonstrations of cool things Snowflake can do. We cover numerous SQL tips and tricks. We cover cool features such as resource monitors, the amazing Web UI, generators, using Snowflake as a data lake (which you could, and should, be doing), analytical functions in Snowflake, monitors warehouse usage and so much more.



Content

Introduction

Introduction

Snowflake User Interface (Web UI) Techniques

A Quick Tour of the Web UI
Finding Objects in Your Account and/or Database
Getting Object information
Executing SQL Statements
Search and Replace
Commenting Your Code
Copying and Moving Code
Query and Results History - Part 1
Query and Results History - Part 2

SQL Tips and Techniques

Information_Schema
Databases and Schemas
Tables
Table Constraints
Columns
Views
Data Types
User-defined Functions
Users and the Result_Scan Function
Users Never Logged In
Query History
Virtual Warehouses (Compute)
Dates
Converting Time zones

Cool Features and Functions in Snowflake

10 Features That Make Snowflake Cool - Plus a Bonus 11th.
Generators
Using Snowflake as a Data Lake
Data Masking
Creating a Table from a Clone and Time Travel
Resource Monitors
Dropping and Un-dropping Objects

Windowing Functions and Analytical Techniques

Overview
Rank
Lead and Lag
First and Last
Ratio_To_Report
Moving Averages
Techniques for Percentiles
Grouping Sets

Miscellaneous

Terminology Tips
Parameters - A Technique for Controlling the Environment
ListAgg
The Qualify Function
The ILIKE Function
The HASH_AGG Function and Comparing Two Objects
Killing a Session (Connection)
Monitoring Warehouse Usage
Date Extraction Confusion
Convert a Permanent Table to Transient
Generate a DDL Statement for an Object
20 Performance and Money-Saving Tips

Test Your Knowledge

Test Your Knowledge

Screenshots

Snowflake Database - Tips, Techniques and Cool Stuff - Screenshot_01Snowflake Database - Tips, Techniques and Cool Stuff - Screenshot_02Snowflake Database - Tips, Techniques and Cool Stuff - Screenshot_03Snowflake Database - Tips, Techniques and Cool Stuff - Screenshot_04

Reviews

Katya
July 6, 2022
The course in excellent! Provides essential information and does not go into needless detail. Presentation is consize and on point!
Kristin
January 21, 2022
I thought this was a very good class but much of the information did not pertain to me since I'm not data admin role. It was still very interesting and felt it was all presented very clearly.
K
September 17, 2021
Pros: Instructor replied within 48 hrs on Qs raised, some unique content Cons: Some content directly copied from Snowflake articles ( Lecture 51) and Towards Data Science ( Lecture 41) without crediting original authors.

Charts

Price

Snowflake Database - Tips, Techniques and Cool Stuff - Price chart

Rating

Snowflake Database - Tips, Techniques and Cool Stuff - Ratings chart

Enrollment distribution

Snowflake Database - Tips, Techniques and Cool Stuff - Distribution chart

Related Topics

4051674
udemy ID
5/15/2021
course created date
5/31/2021
course indexed date
Bot
course submited by