
SQL Improvements in Snowflake (Masterclass Hands-On)
Udemy ยท English
About this course
- Language
- English
- Category
- Provider
- Udemy
- Data updated
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 aboutUnusual 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 amFormer Snowflake "Data Superhero". Former SnowPro Certification SME (Subject Matter Expert) - many SnowPro exam questions have been created by me. Passed most SnowPrโฆ











