Snowflake - Applications and Implementation

This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform.

Hamid Qureshi

Data Science | intermediate | 5 hours 35 minutes | Published: Nov 2020

Discussions

Overview

2.1KSTUDENTS^*

94%RECOMMEND^*

This course includes:

5+ hours of on-demand video
6 modules
Core level
Direct access/chat with the instructor
100% self-paced online
Many downloadable resources
Shareable certificate of completion

This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform. Snowflake is the leading solution for warehousing in the cloud. It is built for the cloud. Snowflake delivers the performance, concurrency and simplicity needed to store and analyze all of an organization’s data in one solution. Snowflake’s technology combines the power of data warehousing, the flexibility of big data platforms and the elasticity of the cloud at a fraction of the cost of traditional solutions

Skills You Will Gain

Big Data

Cloud

Data Warehouse

Learning Outcomes (At The End Of This Program, You Will Be Able To...)

Learning Objectives (At the end of this course, you will be able to…):

Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
Load and transform data
Evaluate Query Constructs and DDL & DML Operations
Review Snowflakes broad SQL support for data analysis
Describe how user and application access can be easily managed
Demonstrate best practices for working with semi-structured data
Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
Employ Snowflake’s method for continuous data protection
Utilize Data Sharing to send your data in real-time to Customers and Partners
Scale your Virtual Warehouse for performance and concurrency
Explain the different ways you can manage and monitor your Snowflake account

Prerequisites

A basic level of conceptual understanding of data warehouses is assumed, as well as an awareness of the core functions of SQL.

Who Should Attend

Data Analysts
Data Engineers
Data Scientists
Database Architects
Database Administrators

Curriculum

Instructors

^*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.

Snowflake - Applications and Implementation

This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform.

Hamid Qureshi

Data Science | intermediate | 5 hours 35 minutes | Published: Nov 2020

Discussions

Overview

2.1KSTUDENTS^*

94%RECOMMEND^*

This course includes:

5+ hours of on-demand video
6 modules
Core level
Direct access/chat with the instructor
100% self-paced online
Many downloadable resources
Shareable certificate of completion

Skills You Will Gain

Big Data

Cloud

Data Warehouse

Learning Outcomes (At The End Of This Program, You Will Be Able To...)

Learning Objectives (At the end of this course, you will be able to…):

Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
Load and transform data
Evaluate Query Constructs and DDL & DML Operations
Review Snowflakes broad SQL support for data analysis
Describe how user and application access can be easily managed
Demonstrate best practices for working with semi-structured data
Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
Employ Snowflake’s method for continuous data protection
Utilize Data Sharing to send your data in real-time to Customers and Partners
Scale your Virtual Warehouse for performance and concurrency
Explain the different ways you can manage and monitor your Snowflake account

Prerequisites

A basic level of conceptual understanding of data warehouses is assumed, as well as an awareness of the core functions of SQL.

Who Should Attend

Data Analysts
Data Engineers
Data Scientists
Database Architects
Database Administrators

Curriculum

1Welcome to the course!

2Program Announcements

3Labs - Data Loads and Processing

4Module 1 - Snowflake Introduction

5Module 2 - Snowflake Architecture

6Module 3 - Data Loading in Snowflake

7Module 4 - Performance Optimization

8Module 5 - Time Travel

9Module 6 - Secure Data Sharing

10Module 7 - Snowflake Access Management

Instructors

^*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.