Intro to Snowflake for Devs, Data Scientists, Data Engineers

Snowflake via Coursera

Coursera based on 80 ratings

Likes

Overview

"Intro to Snowflake for Devs, Data Scientists, Data Engineers" is a practical course designed to introduce professionals to Snowflake, a leading cloud data platform renowned for its scalability, flexibility, and ease of use. This course is ideal for developers, data scientists, and data engineers who want to leverage Snowflake’s capabilities for efficient data storage, processing, and analytics. Learners will explore Snowflake’s architecture, including its multi-cluster shared data approach, and understand how it separates storage and compute for optimized performance. The course...

Syllabus

Snowflakes Core Objects and Architecture

After a very brief intro to the course, learners will create a free trial, open a worksheet, and query sample data. Theyll learn about scaling virtual warehouses and create a virtual warehouse to ingest Tasty Bytes data. Theyll learn about stages, databases, schemas, and tables. Theyll manipulate semi-structured data. Theyll also learn about the different Snowflake architectural layers.

Snowflake Feature Overview

Learners will identify a recently introduced error in the data and use time travel to correct it. Theyll learn about permanent, transient, and temporary tables, and cloning. Theyll create resource monitors. Theyll create UDFs, a UDTF, and a SQL stored procedure. Theyll learn about role-based access, the VS Code extension, Snowpark DataFrames, and the Snowflake CLI.

Overview of Builder Workloads: Data Engineering, AI / ML, Apps

Learners will explore four Snowflake workloads: Data Engineering, Generative AI, Machine Learning, and Applications. After reviewing each workload, theyll see one aspect of that workload in practice: for DE, ingesting streaming data with Snowpipe; for GenAI, using the Snowflake Cortex LLM function Complete; for ML, using Snowpark ML to create an XGBoost model and make predictions about a food trucks location; and for apps, running a Streamlit app that shows us Tasty Bytes daily revenue. They will then learn about the Snowflake Data Cloud.