Snowflake cloud data warehouse in an hour - Beginners

Name: Snowflake cloud data warehouse in an hour - Beginners
Rating: 4.3 (102 reviews)

The quick and easy introduction to snowflake cloud data warehouse aimed at beginners

Created byPatrick Videos

Last updated 3/2024

English

English [Auto],

What you'll learn

Snowflake cloud data warehouse
Preparing and loading data into Snowflake
Queries, cache and cloning
Time travel, access control and marketplace

Course content

1 section • 16 lectures • 1h 14m total length

Introduction to data warehouse4:18
Learn how OLTP databases differ from data warehouses, master normalization concepts, and see how data is extracted, transformed, and loaded into a cloud-based Snowflake data warehouse for rapid reporting.
Signup for free snowflake trial account1:46
Sign up for the 30-day Snowflake trial at sign up dot snowflake dot com, choose enterprise on Azure in Virginia, verify email, activate, and sign in.
New UI Overview3:00
Explore the new Snowflake UI overview, from worksheets and dashboards to databases, tables, and data sharing, plus marketplace access, history, and admin controls for usage and users.
Create Database and Warehouse6:22
Create a database named company and a warehouse to provide processing power, load unstructured json data with a sql client, and later convert that data into a view.
Stage files using SnowSQL9:05
Learn to load unstructured json data into Snowflake using SnowSQL, install the tool, log in, set warehouse, database, and schema, and upload files to a stage.
Load JSON Data and Create a View3:59
Load json objects from stage json files into the salary table with a variant data type, then create a view exposing employee id, grade, and salary as a table.
Load CSV Files12:48
Load two CSV files into Snowflake by creating a table, staging the files, and copying data with a CSV format. Troubleshoot errors and optimize loads with a larger warehouse.
Join Employee table and Salary view2:27
Join the salary data view with the employee table on employee ID to retrieve employee ID, last name, and salary. Analyze gender with counts, averages, and max/min salaries.
Time Travel restore data5:50
Demonstrate Snowflake time travel to restore dropped tables and recover data after updates, using query history and a query id within 90 days.
Create Roles and Grant Privileges8:56
Create roles and assign users in Snowflake, grant privileges across databases, schemas, and warehouses, and manage access with account admin and intern roles.
Sharing Data2:27
Learn how to share data in Snowflake using private sharing, view data shared with you and account usage, create direct shares to other accounts, or publish to marketplace.
Dashboard4:01
Marketplace data COVID1:22
Explore the snowflake marketplace to access third party data, including covid related datasets. Learn to search, retrieve, and query free data such as cases by country using a star schema.
Marketplace data Stocks1:56
Explore marketplace data and stock tables in Snowflake, select a warehouse, and write and run SQL queries to view Bank of America company profiles.
Flatten Nested JSON6:27
Flatten nested JSON in Snowflake by using lateral flatten to extract in-person and online orders, then flatten receipts and add-ons with outer true to preserve nulls.
Resources

Requirements

Beginners. No prior experience needed.

Description

In this simple, easy to follow, fast paced video tutorial, learn to work with the cloud based Snowflake data warehouse tool.

Learn to create database, tables, load structured and unstructured data. Create warehouses, query data and much more.

A full day lecture has been edited so tight, what resulted was just an hour of video.

Just an hour long

The video has been edited so tight that what resulted was just an hour. You will not see any pauses or time wasted. These have been designed like Tik-Tok videos to keep you engaged.

Reviews for my courses:

Excellent video!! Especially for a beginner like me. Wow! 'am so happy that i found your video. Keep up your good work Patrick. Ur way of narration-bringing in a steady flow throughout the tutorial. Easy to understand-line by line explanation. Excellent visual clarity - Prema, USA

You are like an angel to all your students. In a simple way you've explained us such difficult and most confusing things. I always believe that teaching is a precious gift and only some lucky people have it - Hari, Australia

Wow, amazing, awesome videos. The best for newbies like me.Thank you very much! - Dev, Nicaragua

I was searching for a nice tutorial the whole day and frankly i was losing any hope to find it but then i found your videos... U've got a real gift to explain kind of difficult things in a simple way, i mean i can't imagine a better way to explain that :) thank you very very much! God bless you! - Vaness, Russia

Who this course is for:

Beginners who want to understand snowflake cloud data warehouse