Data Warehousing Workshop (Badge 1)

Course Overview

Start Here! Our Data Warehousing Workshop is designed for learners who are new to Snowflake, or new to databases in general. This workshop is highly interactive with reflection questions, hands on lab work and automated lab work checks! Fast-paced and informative, light in tone, scenario-driven and metaphor rich.

Topics Covered

• •Benefits of a Cloud-based Database
• •Account Editions, Regions & Clouds
• •Snowflake Identity, Access, Users, & Roles
• •Databases, Ownership and Context
• •Worksheets and Warehouses
• •Loading Tables Using SQL Insert Statements
• •File Formats, Stages, and Copy Into Loading
• •Semi-Structured Data including XML and JSON
• •Querying Nested Semi-Structured Data

Prior Knowledge & Experience

As our flagship course, there are no prerequisites. You should know how to use a web browser but beyond that, you don't need to even need to know what a database is! It does NOT require prior experience with Snowflake.

Scenario Based

We do our work alongside Tsai Yang, a data engineer who is reviewing Snowflake for her company's possible move to Snowflake. We also observe as Tsai introduces Snowflake and database concepts to her Uncle Yer, who has never used a database before but finds Snowflake clear and easy to learn.

Time to Complete

Plan for 3 hours of effort a day for 3 days in a row. If you choose to complete the workshop in a single sitting, that's fine with us.

Grading

To complete the workshop you will run scripts that are autograded by DORA, our grading robot.

Lab Environment

Don't sign up for a trial account until you are given step-by-step instructions within the course flow. Since this is the first course, we are more precise with the steps.

Course Enrollment Help

• •For assistance signing into Snowflake Community: Getting Access to Snowflake University.
• •Once enrolled, you can visit your Learner Dashboard in Snowflake University to access the course directly — https://learn.snowflake.com/dashboard

View Course Completions

To view your completion history for all On-Demand Training, Instructor-Led Training (ILT), and Certifications, kindly visit your Learning Transcript (sign-in required).
To access and share any earned badges - visit: Snowflake's Badging Portal