Snowflake Essentials - A Comprehensive Masterclass

About Snowflake Essentials - A Comprehensive Masterclass

This course is for:

Software developers (Data Engineers, ETL developers, backend developers, etc.) who need to build modern data applications using Snowflake.

Data Scientists (and other analytical roles of Data Analysts, Business Intelligence developers, etc.) who need to build data models and AI applications using Snowflake.

None-IT Analysts who want to query Snowflake and derive insight from residing data.

Managers and business directors who need to understand the technical and maintenance aspects of switching to an Snowflake platform.

Hard-working students who want to learn SQL in a principled manner and want to write clean code.

My co-instructor and I have put our Data Engineering, Data Modeling, and Software Development backgrounds into creating this course that beyond teaching Snowflake features, it covers fundamental SQL topics from the ground up.

We cover topics including but not limited to this list:

Snowflake:

Snowsight tour

Snowflake SQL

Snowflake Scripting

Stored Procedures using SQL and Python

Error handling

Data recovery

Time travel

Zero-copy cloning

Snowflake architecture

Streams

Tasks

DAG of tasks

Access control

Manage custom roles and users

Secure Data Sharing

Storage integrations

Creating IAM roles and users to connect to AWS

Stage types (internal stages of named, user, and table types, and external stages)

Load during transformations

Table functions

Context functions

SQL:

DDL statements in Snowflake

Data types in Snowflake

Referential integrity enforcement

Scalar functions with common functions to work with

String data types

Temporal data types

Numeric data types

Context functions

Window functions

Common Table Expressions

Aggregations

Joins

Set operators

Pivot and Unpivot

And we constantly add new topics to the course to keep it the most comprehensive Snowflake video tutorial on Udemy.