Advertisements

SQL Improvements in Snowflake (Masterclass Hands-On)

Advertisements
Learn modern and unusual SQL extension in the Snowflake AI Data Cloud, from world-class expert
1
1/5
(75) Ratings
107 students
Created by Cristian Scutaru
Advertisements

What you'll learn

  • Important SQL extensions in Snowflake
  • Next evolution of the SQL language
  • Exciting use cases for AI/ML Snowflake Cortex additions
  • Object-oriented SQL, with built-in classes and instances
  • Inline lambda functions in SQL statements
  • Time travel and zero-copy cloning though Snowflake SQL
  • Brief introduction to Snowflake Scripting
  • Processing JSON data in Snowflake
  • ASOF, direct and fuzzy joins
  • Synthetic data generation in Snowflake
  • Processing tabular hierarchical data in Snowflake
  • CDC in data pipelines
This course includes:
18.5 total hours on-demand video
2 articles
1 downloadable resources
138 lessons
Full lifetime access
Access on mobile and TV
Certificate of completion
Advertisements

Course content

Requirements

  • Knowledge of Basic SQL (This course is NOT for absolute beginners!)
  • Basic knowledge of relational databases
  • Optional basic experience with Snowflake (but not required)

Description

This is a Bible of the unusual Snowflake SQL improvements and extensions!

Snowflake continues to enhance SQL and make it easier to use. Are YOU aware of the new SQL additions? As you may need them in your job interviews, for your clients, to write better queries…

This is NOT a course for absolute beginners!

You must have some basic knowledge about SQL and relational databases. However, I tried to make everything easy to understand. Most lectures present hands-on exercises, with SQL code shared with you. The slideshow presentations will also be shared with you.

What you will learn about

  • Unusual SQL extensions in Snowflake, such as COUNT_IF, ANY_VALUE, MIN_BY, etc.

  • Bootcamp on Snowflake Scripting.

  • Processing of semi-structured data, in particular JSON.

  • Processing of tabular hierarchical data, with recursive queries.

  • Table functions, reused SQL expressions, filter with QUALIFY.

  • Lateral, ASOF, directed, “exploding” and fuzzy joins.

  • Emulation of many typical SQL clauses.

  • Advanced regex, pattern matching, and text search extensions.

  • Pipe operator (->>), spread operator (**), CTEs and subqueries.

  • Difference between transient, temporary, hybrid, and dynamic tables.

  • Advanced synthetic data generation.

  • Time travel and zero-copy cloning in Snowflake.

  • Similarity between sets.

  • Machine Learning classes, with several specific use cases.

  • Snowflake Cortex LLM and AISQL functions.

  • Vectorized Python UDFs, UDTFs, and UDAFs.

  • SQL and Python worksheets.

Who I am

  • Former Snowflake “Data Superhero”.

  • Former SnowPro Certification SME (Subject Matter Expert) – many SnowPro exam questions have been created by me.

  • Passed most SnowPro certification exams, all from the first attempt.

  • Specialized in Snowflake for the past few years: I worked for Snowflake Partner companies. I served dozens of clients in this capacity or as an independent consultant. Today I share my knowledge with highly specialize courses on Snowflake.

This course truly offers a very in-depth immersion into all sorts of extensions to SQL Snowflake continues to come up with. Enroll today, and keep this course forever!

[Disclaimer: We are not affiliated with or endorsed by Snowflake, Inc.]

Who this course is for:

  • Data Analysts who want to learn specifics of the SQL in Snowflake
  • Data Engineers
  • SQL programmers and enthusiasts
  • Anyone interested in the next evolution of the SQL language
Advertisements
SQL-FREE
Advertisements
Advertisements
Free Online Courses with Certificates
Logo
Register New Account