Snowflake Hands-on Essentials Series Part 1 - Data Warehousing

Why should you take Snowflake Hands-on Essentials Series Part 1 - Data Warehousing course?

At the end of this course, the learner will be able use Snowflake to:

• Create, edit and drop databases, schemas and stages.
• Create and edit tables and views.
• Load records into tables using INSERT statements, the load wizard, and COPY INTO statements.
• Load records into tables with the help of file formats and staged files.
• Create worksheets and use them to write, edit, and run simple SQL statements.
• Create and edit SEQUENCES to provide unique identifier values to table records.
• Query and load data that is stored using the JSON data format.
• Create notebooks and use them to run code.
• Create a Streamlit in Snowflake application that captures user input and stores it to a Snowflake database.

Who should take Snowflake Hands-on Essentials Series Part 1 - Data Warehousing course?

• Designed for people new to Snowflake or new to database work in general. The course can be used by managers who simply want to understand what Snowflake is generally capable of, or it can be used by those considering a career or as a data professional. Likewise, seasoned data professionals find the courses in this series a quick and easy introduction to tasks they are already familiar with, in a tool they are not.

Curriculum for the Snowflake Hands-on Essentials Series Part 1 - Data Warehousing Course

• Snowflake Fundamentals:
  • Understanding the benefits of a cloud-based data warehouse.
  • Exploring Snowflake's architecture and key components.
  • Navigating the Snowflake interface.
• Database Object Management:
  • Creating and managing databases, schemas, and tables.
  • Working with views.
  • Understanding object hierarchy.
• Compute Resources:
  • Creating and managing virtual warehouses.
  • Understanding warehouse sizing and scaling.
• Data Loading:
  • Loading data using SQL INSERT statements.
  • Working with file formats (CSV, JSON).
  • COPY INTO statements.
  • Use of the Snowflake Load Data Wizard.
• Data Transformation:
  • Basic SQL queries for data retrieval and manipulation.
  • Parsing and querying semi-structured data (JSON, XML).
  • Use of Path notation and Cast statements.
• Core SQL Skills:
  • Reinforcement of basic SQL concepts.
• Hands-on Labs:
  • Emphasis on practical exercises to reinforce learning.
  • Automated lab grading using DORA.
• Beginner-Friendly:
  • Designed for individuals new to Snowflake or data warehousing concepts.
  • Scenario-driven learning.
• Badge-Based Recognition:
  • Provides an opportunity to earn a Snowflake Hands-On Essentials badge.

Tools you will learn in Snowflake Hands-on Essentials Series Part 1 - Data Warehousing course

• Navigate between Worksheet layout and Home page.
• Use resources inside and outside the LMS to get help.
• Create a database.
• Transfer database ownership.
• Change roles.
• View ownership of objects.
• Create a database.
• Create and drop schemas.
• Create a worksheet.
• Use the worksheet to run SQL statements.
• Run Show Commands.
• Create a table.
• Run a SQL Insert statement from a worksheet.
• Craft a SQL statement with SELECT * and LIMIT.
• Set Up a Resource Monitor.
• Run provided code to create a data integration.
• Run provided code to create an external function.
• Run provided code to test Snowflake objects and data loads.
• Use the Load Data button to load a file, setting properties as prescribed.
• Use the Load Data button to load, while deducing the settings needed.
• Create File Format by copying from the Load wizard.
• Create File Format via code.
• View Table Data.
• Create a notebook.
• Add cells to the notebook.
• Set and call variables in the notebook.
• Rearrange cells in a notebook.
• Run code in a notebook.
• Create a Streamlit in Snowflake Application.
• Create user input objects for the application.