Coming Soon workshop
Snowflake Essentials for Data Analytics
Snowflake
SQL
Database Design
Data Analysis
Notify me when registration is open
You're comfortable with basic SQL queries, but getting started with a cloud tool like Snowflake feels less familiar. The interface, terminology, and setup are all new, and you've heard terms like "virtual warehouse" without a clear sense of what they mean or how they fit into running a query.
In this session, you'll get a crash course in Snowflake: the main parts of the UI, key terms like virtual warehouses, and how to set your context. You'll query data, explore the database explorer, and read your query results and profile, so you can work in Snowflake like any other SQL editor.
What you'll learn
Navigate the Snowflake UI and its main components
Find your way around the interface so the environment stops feeling unfamiliar.
Learn how to set the context for your queries
Choose the right role, warehouse, database, and schema before you run anything.
Understand how to create and manage a virtual warehouse
See what a virtual warehouse does and how it powers the queries you run.
Run your first queries and interpret the results
Execute SQL queries in Snowflake, then learn how to read the output and interpret the query profile.
Who should join this workshop?
Analysts who know basic SQL but are new to Snowflake
Beginners who want their first hands-on look at a cloud data warehouse
SQL users who want a fast, practical intro to Snowflake
Prerequisites
A free Snowflake trial account (setup steps provided before the session)
Basic SQL querying experience is helpful but not required
Alice Zhao
Lead Data Science Instructor
Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She's an adjunct lecturer for Northwestern University's Machine Learning and Data Science program, where she teaches Python, SQL, R, data warehousing and data visualization.
