Snowflake for Data Science and Data Engineering

Snowflake SQL

What you'll learn
Learn Snowflake SQL commands, functions, and data types
Learn Snowflake architecture and core concepts
Learn advanced Snowflake features and performance optimization
Learn development skills for building Data Pipelines using Snowflake
Requirements
This course accommodates all levels of experience, and covers the Snowflake skills from the ground up. Data Warehousing and Programming background helps with faster learning, but is not required.
Description
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
.
Who this course is for:
For a wide range of professionals using Snowflake. Data Engineers, Data Scientists, Data Analysts, Software Developers are to name a few roles this course can help excel in their jobs.


More Info