Programming in Snowflake Masterclass Hands-On

Deep dive into customer-oriented programming in the Snowflake AI Data Cloud, by world-class Snowflake expert

What you'll learn
Query anything in Snowflake through SQL and Snowflake Scripting
Use most if not all programming APIs offered by Snowflake
Access and use Snowflake as a software or data developer
Build real-life tools and apps with and for Snowflake
Process and access hierarchical data and metadata in Snowflake Data Cloud

Requirements
This is an INTERMEDIATE-level course, be aware. Not for absolute beginners!
Prior knowledge of Snowflake or other data warehouses
Experience with relational databases and related technologies
Basic SQL knowledge required
Basic knowledge of programming in Python required
Nice to have basic skills in other programming languages: SQL scripting, JavaScript, C#, Java, Scala…
Basic knowledge of working with a git repository such as GitHub

Description
IMPORTANT: This course requires an INTERMEDIATE level and it may NOT be for you if you just recently started with Snowflake, relational databases, with SQL and/or Python programming. It occasionally deals with advanced notions about security, software and data engineering, REST APIs etc, that are not explained here. Check the minimum Requirements for this course, and the "What is NOT Included in This Course" section below, before buying this course.Who I AmThe only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.Former SnowPro Certification SME (Subject Matter Expert): i.e. many exam questions have been created by me.Passed eight SnowPro certification exams to date, all from the first attempt.Specialized in Snowflake for the past few years, I worked for Snowflake Partner companies, and I served dozens of clients in this capacity or as an independent consultant.Today I continue to work with Snowflake, but I am no longer affiliated with their company in any capacity. I recently left most of their programs to keep my professional independence.What You Will LearnHow to access, expand and automate Snowflake through most if not ALL their existing APIs.How to build useful real-life tools and small apps with Snowflake APIs.How to ingest CSV and JSON data into Snowflake, through data pipelines and Snowpipe.How to write medium to complex data analytics queries for Snowflake.How to optimize queries, compute, storage and overall costs for Snowflake.How to process and render semi-structured and hierarchical data and metadata in Snowflake.I tried to cover almost everything from Snowflake to date, only from a programming perspective.What Snowflake APIs You Will Learn AboutSQL (DDL/DML/DCL) and Snowflake ScriptingStored Procedures, User-Defined Functions (UDFs), User-Defined Table Functions (UDTFs)Python Client, Snowpark for Python, Python WorksheetsStreamlit Web Apps, Streamlit for Snowflake, Snowflake Native Apps FrameworkSecure Data Sharing and Data Clean RoomsSharing with private Data Exchange or public MarketplaceSnowflake SQL REST API and Snowpipe REST APIQuerying metadata from Account Usage and Information SchemaI tried to cover most possible APIs that Snowflake offers today!What is NOT Included in This CourseData Science and Machine Learning APIs.Most external integrations, such as external functions, or Kafka and Spark connectors.Integrations with data transfer applications or other third-party partner apps.Client driver programming in Go, PHP, Java etc.Snowpark programming in Java or Scala.Main focus was on SQL and Python, with small extra snippets in JavaScript, C#, Java, Scala.Real-Life Applications You Will Learn To BuildCDC Data Pipelines with streams and tasks, or dynamic tablesGeneric hierarchical data viewerHierarchical metadata viewer (for data lineage and object dependencies, role hierarchy, etc.)Enhanced query profileScript automation accessing the SQL REST APIWe’ll build all apps from scratch. We’ll use then Streamlit – for many of them - to create simple web apps, local or remote. We may deploy them into Snowflake, as Streamlit Apps. Or even share them with local partner accounts, as Native Apps.I sold tools similar to these to real-life clients and Snowflake partners!No other course, book or documentation around - including those from Snowflake! – will offer as much insights, hands-on exercises and knowledge transfer as my course here, guaranteed!Enroll today, to keep this course forever. And help me continue to update it with new APIs Snowflake comes frequently up with.

Who this course is for:
Data Engineers new to Snowflake, looking to acquire deep knowledge of the APIs, Software Engineers and Developers looking to access Snowflake in different ways, Data Analysts looking for medium to complex queries they can write for Snowflake, Data Architects looking to design data pipelines for Snowflake, Software Architects looking to design apps and tools with and for Snowflake, Any other practitioner who enjoys data and coding, new or not to Snowflake