WA3063

Snowflake Training: Snowflake Cloud Data Platform from the Ground Up Training

This Snowflake Cloud Data Platform training teaches attendees the basics of Snowflake, the world's leading cloud data platform. In this course, students learn how to design, build, and manage highly efficient data warehouses in the cloud through engaging demonstrations and real-world hands-on labs.

Course Details

Duration

2 days

Prerequisites

Basic knowledge of programming and SQL

Target Audience

  • Business Analysts
  • Architects
  • System Integrators
  • Software Engineers
  • Technical Support Staff

Skills Gained

  • Understand Snowflake's architecture, security, and core services
  • Master the web UI, roles, databases, and tools for optimal efficiency
  • Craft the perfect data warehouse for your specific needs, utilizing Snowflake's unique features
  • Leverage SQL, Snowsight, and advanced querying techniques to extract meaning from your data
  • Develop user-defined functions and stored procedures to personalize your data workflow
  • Apply seamless data import and export techniques with Snowpipe and other tools
  • Explore Snowflake Stream and Tasks for effortless data management
Course Outline
  • Introduction to the Snowflake Cloud Data Platform
    • What is Snowflake?
    • Security and Compliance
    • Snowflake Conceptual Architecture
    • Core Underlying Design Considerations
    • Core Services and Tools
    • Snowflake Editions
    • The Standard Edition
    • The Enterprise Edition
    • The Business Critical Edition
    • Virtual Private Snowflake
    • Billing: The Cost Components
    • Data Storage Segments
    • Parts of Snowflake that Incur Compute-related Costs
    • Snowflake Quickstart
  • Snowflake's Web UI
    • Web UI (Web Portal)
    • Worksheets
    • Worksheets UI
    • Default Warehouse
    • Snowflake Roles
    • The Roles UI
    • Snowflake Databases
    • Marketplace
    • Activity
    • Activity UI
    • Admin
    • Account Usage UI
    • Create Network Policy Dialog (under Admin > Security)
    • Native Apps
  • Designing Data Warehouses in Snowflake
    • What is a Virtual Data Warehouse?
    • The Warehouse-Database Relationship
    • Matching Your Needs
    • The Auto Suspend/Resume Features
    • Multi-cluster Data Warehouses
    • The Concept of the Snowflake Compute Credit
    • Compute Sizing
    • Operations
    • Creating a New Warehouse
    • Warehouse UI
    • Database Objects
    • Tables
    • Table Storage Types
    • Table Constraints
    • Search Optimization Service
    • Table Data Types
    • Data Loading
    • Views
    • Zero-Copy Cloning Feature
    • The Programming Capability
    • Continuous Data Protection Lifecycle
  • Querying for Insights in Snowflake
    • Supported SQL Standards
    • Ways to Query Data in Snowflake
    • Snowsight Experience
    • Statistics and Visualizations
    • Charts
    • The TOP/LIMIT Syntax
    • Comments
    • Hierarchical Select example
    • Subqueries
    • Support for Window Functions
    • CTEs (Common Table Expressions)
    • Approximation Functions
  • Designing Data Warehouses in Snowflake
    • The Programming Capability
    • Returning a Value
    • User-defined Functions (UDFs)
    • UDF-Related DDL Commands
    • The CREATE FUNCTION DDL
    • A UDF Example
    • Stored Procedures
    • DDL Commands Related to Stored Procedures
    • JavaScript-based Stored Procedure
    • Accessing the Return Value of Stored Procedures
    • External Functions
  • Data Import and Export in Snowflake
    • Bringing Data Into Snowflake: the Import Tools
    • Data Stages
    • Import Process using a Stage
    • Example of Using the Put Command
    • Example of Using the Copy Into Command for Data Import
    • Snowpipe
    • Using Snowpipe
    • Taking Data out of Snowflake: the Export Tools
    • The Export Process
  • Snowflake Stream and Tasks
    • Snowflake Stream
    • Snowflake Tasks
  • Lab Exercises
    • Lab 1. Signing Up for the Free Trial of Snowflake
    • Lab 2. The Snowflake Web UI
    • Lab 3. Creating and Working with Databases in Snowflake
    • Lab 4. Querying Data in Snowflake
    • Lab 5. Common Table Expressions (CTEs)
    • Lab 6. Window Functions in Snowflake
    • Lab 7. The Time Travel Feature of Snowflake
    • Lab 8. Understanding Stored Procedures and UDFs in Snowflake
    • Lab 9. SnowSQL Command-Line Interface
    • Lab 10. Data Import Using SnowSQL Command-Line Interface
    • Lab 11. Creating and Working with Snowflake Stream
    • Lab 12. Understanding Snowflake Users and Roles
Upcoming Course Dates
USD $1,460
Online Virtual Class
Scheduled
Date: May 6 - 7, 2024
Time: 10 AM - 6 PM ET