Snowflake Fundamentals 4-Day

Price
$3,000.00 USD

Duration
4 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information
Download Course Details
Course Details Only
Course Details & Schedule
Skip to Class Dates

Course Overview

This 4-day course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform. The course will consist of lecture, demos, and labs on a wide range of foundational topics.

Course Objectives

  • Outline the unique and dierentiated architecture of the Snowflake AI Data Cloud.
  • Load and transform data.
  • Summarize query constructs, DDL, and DML operations.
  • Use Snowflake’s extensive SQL capabilities for data analysis.
  • Describe how user and application access can be easily managed.
  • Apply Snowflake’s recommended best practices for working with semi-structured data.
  • Discuss Snowflake’s unique approach to caching.
  • Implement the options provided to connect and interact with the Snowflake AI Data Cloud.
  • Employ Snowflake’s continuous data protection features.
  • Utilize data sharing to send your data in real-time to Customers and Partners.
  • Scale your Virtual Warehouses to improve performance and address concurrency needs.
  • Explain the dierent ways you can manage and monitor your Snowflake account.
  • Summarize Snowflake’s AI and ML capabilities.

Who Should Attend?

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

Previous Data Warehouse knowledge is assumed.

Agenda

1 - Overview and Architecture

  • Overview
  • Snowflake Structure
  • Using Snowsight
  • Storage Layer
  • Compute Layer
  • Cloud Services Layer
  • Snowgrid

2 - Connecting to Snowflake

  • Connection Options
  • SnowSQL
  • Visualizations in Snowsight

3 - Data Protection Features

  • Cloning
  • Time Travel
  • Fail-safe
  • Introduction to Replication

4 - SQL Support in Snowflake

  • Tables, Views, and Data Types
  • Transactions
  • Standard SQL and Snowflake
  • Collation
  • Multi-table Inserts
  • Query Tags
  • Working with Parameters

5 - Metadata and Caching in Snowflake

  • Overview
  • Metadata
  • Query Result Cache
  • Data Cache

6 - Query Performance

  • Using Explain
  • Query Profile
  • SQL Performance Tips

7 - Data Loading and Unloading

  • Data Loading Objects
  • Data Loading Process
  • Transformations and Copy Options
  • Data Loading Recommendations
  • Continuous Data Loading
  • Unloading Data

8 - Functions, Procedures, and Snowflake Scripting

  • User-defined Functions
  • Stored Procedures
  • Snowflake Scripting

9 - Using Tasks, Streams, and Dynamic Tables

  • Tasks Overview
  • Creating Tasks
  • Managing Tasks
  • Streams Overview
  • Dynamic Tables Overview

10 - Managing Security

  • Security Overview
  • Access
  • Authentication
  • Authorization
  • Data Protection
  • Trust Center

11 - Access Control and User Management

  • Concepts
  • Types of Roles
  • Ownership
  • View Grants

12 - Semi-structured Data

  • Overview
  • Query Semi-structured Data

13 - Introduction to Data Sharing

  • Snowflake Data Sharing Overview
  • Shares

14 - Virtual Warehouse Scaling

  • Types of Virtual Warehouse Scaling
  • Auto-scaling Policies

15 - Cost Management

  • Overview
  • Visibility
  • Control
  • Optimization

16 - Introduction to Snowflake AI and ML

  • Generative AI
  • Overview of Cortex LLM Functions
  • Overview of Snowflake ML Functions
 

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3606094E
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
Contact Us about Starting Your Business Training Strategy with New Horizons