Snowflake For Data Engineers

In this hands-on training course we will go from beginner to building and operating Snowflake, the leading Data Platform designed for the cloud.

Program:
13 Lessons
Level:
Beginner
Total Time:
5h 30m

Course Overview

Snowflake is a Cloud data warehouse which is a key element of the Modern Data Stack.

In this lesson we will learn how to work with Snowflake, including data ingestion tasks and streams and role based access control.

Sign Up To Access The Full Course Content

Timeflow Academy is a free online, hands-on platform for learning about Cloud Data Engineering using modern, open source tools and platforms. Please register with us for full access to our content.

Course programme:
01

Introduction To Snowflake

In this lesson we will introduce Snowflake and it's differentiating features.

0h 15m
02

Snowflake Data Cloud

In this lesson we will learn about the Snowflake Data Cloud concept.

0h 0m
03

Snowflake Architecture

In this lesson we will learn about Snowflakes architectural characteristics.

0h 15m
04

Snowflake Accounts

In this lesson we will learn about the different types of Snowflake account and the choices that you need to make when creating one.

0h 15m
05

Snowflake Permission Model

In this lesson we will learn about the Snowflake permission and Role Based Access Control model.

0h 15m
06

Snowflake Billing

In this lesson we will learn about the Snowflake billing and credit model.

0h 15m
07

Snowflake Tasks

In this lesson we will learn about Snowflake tasks, which allow us to run database jobs on a schedule.

0h 15m
08

Snowflake Streams

In this lesson we will learn how to use Snowflake streams to respond to database DML statements.

0h 15m
09

Referential Integrity In Snowflake

In this lesson we will learn about the referential integrity features in Snowflake and why Snowflake lacks features in this area.

0h 15m
10

Understanding Snowflake Load and Performance

In this lesson we will demonstrate how to investigate performance issues with Snowflakes load and performance.

0h 15m
11

Loading Data Into Snowflake

In this lesson we will learn about batch loading data into snowflake and how to use staging areas.

0h 15m
12

Connecting Snowflake to Kafka

In this lesson we will learn how to connect Snowflake to Kafka.

0h 15m
13

Resource Monitors

Using the Resource Monitor feature to monitor Snowflake budgets.

2h 45m
Benjamin Wootton
Your Course Curator

Benjamin Wootton

Timeflow Academy Founder

Join our mailing list for our latest insights on Data Engineering:

Timeflow Academy is the leading online, hands-on platform for learning about Data Engineering using the Modern Data Stack. Bought to you by Timeflow CI

© 2023 Timeflow Academy. All rights reserved