Udemy – SQL Improvements in Snowflake (Masterclass Hands-On)

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.

DOWNLOAD LINK: SQL Improvements in Snowflake (Masterclass Hands-On)

SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part01.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part02.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part03.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part04.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part05.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part06.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part07.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part08.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part09.rar – 1000.0 MB
SQL_Improvements_in_Snowflake_Masterclass_Hands-On_.part10.rar – 304.9 MB

FILEAXA.COM – is our main file storage service. We host all files there. You can join the FILEAXA.COM premium service to access our all files without any limation and fast download speed.