Snowflake Essentials - A Comprehensive Masterclass 2024

A compact course on Snowflake Data Platform and Snowflake SQL

Ratings: 4.48 / 5.00




Description

This course is for:


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

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

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

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

  5. 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.

What You Will 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

Who Should Attend!

  • 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.