Snowflake Datawarehouse & Cloud Analytics - Introduction

Build a turbo-powered Cloud Data Warehouse using Snowflake

Created byNav p

Last updated 8/2019

English

What you'll learn

Will learn how to build Kick-ass data warehouse for your company using Snowflake

Course content

6 sections • 10 lectures • 1h 2m total length

Course Overview1:12
Explore Snowflake's unique features and architecture, tour the UI, and learn how cloud data warehousing differs from on-premises, big data, and Teradata.

Snowflake User Interface Walk through8:37
Navigate the Snowflake user interface, including the web user interface, worksheets, database explorer, and query history, to run queries, manage virtual warehouses, and explore roles and databases.
Understanding the cloud and the SAAS Model5:59
Setup the environment for the first time5:34
Set up the Snowflake training environment by creating a virtual warehouse, a database, and schemas. Verify context via UI or commands and note idle timeout behavior and automatic resume.

Snowflake Overview9:28
Explore a cloud-native data warehouse built for the cloud that uses ANSI SQL, requires no maintenance, encrypts by default, and supports zero-copy cloning and pay-per-use scaling.
Install and Configure SnowSQL CLI Client9:08
install and configure the SnowSQL CLI, connect to Snowflake, set the warehouse, database, and schema, run queries, load and unload data, and use a config file for login.

Requirements

Previous knowledge of SQL would be nice but not mandatory

Description

Cloud Data Warehouse is the next big thing. Learn What is Snowflake Cloud Data Warehouse and its architecture. Build highly scalable, high performance next-gen modern data warehouse for you company. The course is designed in beginner friendly, helping you to understand the basics of cloud, SAAS and it all works together in the background.

Requirements:

Good to have prior data warehouse experience, but not mandatory
Nice to have SQL Background, but not mandatory

Who this course is for:

Data science
Data Warehouse
Cloud Data Warehouse
Snowflake
Teradata

Snowflake Datawarehouse & Cloud Analytics - Introduction

What you'll learn

Explore related topics

Course content

Course Overview1 lecture • 1min

Master the basics3 lectures • 20min

Snowflake Overview2 lectures • 19min

Snowflake Architecture1 lecture • 5min

Loading / Unloading in Snowflake2 lectures • 17min

Next Steps1 lecture • 1min

Requirements

Description

Who this course is for: