Snowflake Data Analyst Training

Skip to Scheduled Dates

Course Overview

This two-day, role-specific course introduces data analysts to how the Snowflake AI Data Cloud enables them to deliver actionable insights and reports to their organization to drive business value. The course is structured around a data analysis lifecycle placing each capability Snowflake provides in the data analyst’s context. The course begins with how to connect to the Snowflake Data Cloud. It then covers how to analyze, ingest, enrich, report, and diagnose data insights with Snowflake. The course consists of lectures, labs, demonstrations, and discussions.

Who Should Attend

  • Data Analysts
  • Business Intelligence users

Course Objectives

    • Outline the unique and dierentiated architecture of the Snowflake AI Data Cloud.
    • Exploit the options provided to connect and interact with the Snowflake AI Data Cloud.
    • Describe how to use BI tools for data analysis in Snowflake.
    • Summarize query constructs, Data Definition Language (DDL), Data Manipulation Language (DML), and Data Query Language (DQL) operations.
    • Use Snowflake’s extensive SQL capabilities and the built-in table, scalar, window, and estimation functions to support data analysis.
    • Apply Snowflake best practices when working with semi-structured data.
    • Load and transform data.
    • Visualize data outside of Snowflake.
    • Employ Snowflake features in the reporting process and activities performed by the data analyst to create analytic visualizations.
    • Explain Snowflake’s unique approach to caching and the benefits to query performance.
    • Perform query evaluation, pre- and post-execution, using Snowflake’s Explain, Query History, and Query Profile.

Course Outline

1 - Data Analysis with Snowflake

2 - Snowflake Overview

  • Why Snowflake?
  • Snowflake Functional Architecture?
  • Platform Features?
  • Getting Started with Snowflake?

3 - Snowflake Architecture

  • Snowflake Architecture Layers?
  • Snowflake Structure?

4 - Account Usage and More

  • Information Schema and Account Usage?
  • Using Parameters to Control Snowflake?
  • Query Tags?
  • Sample Data Sets?

5 - Client Interfaces

  • Client Interface Overview?
  • Authentication?
  • Snowsight?
  • SnowSQL?
  • Connecting Tools to Snowflake?

6 - SQL Support in Snowflake

  • Data Definition Language (DDL) ?
  • Data Manipulation Language (DML) ?
  • Data Query Language (DQL) ?
  • Set Operations and Joins?
  • Subqueries and Common Table Expressions?
  • Dynamic Pivot Queries?
  • Constructing Efficient Queries?
  • Copilot?

7 - Functions in Snowflake

  • Function Overview?
  • Estimation Functions?
  • User-defined Functions?
  • Stored Procedures?
  • Snowflake Scripting

8 - Other Snowflake Features

  • Collation
  • Sampling
  • Snowflake Tasks
  • Alerts

9 - Creating More Complex Queries

  • Window Functions, Syntax, and Usage
  • Group By and Grouping Sets
  • Recursive With and Connect By

10 - Semi-structured Data

  • Semi-structured Data Overview
  • Query Semi-structured Data

11 - Continuous Data Protection

  • Time Travel
  • Cloning

12 - Collaboration

13 - Data Loading

  • Data Loading Concepts
  • Examples of Data Loading

14 - Snowflake Data Lake Support

15 - Reporting Using Snowflake

  • Explore Data
  • Prepare Data
  • Analyze Data
  • Visualize Data
  • Integrate BI Tools

16 - Caching and Query Pruning

  • Metadata and Caching Overview
  • Metadata
  • Query Result Cache
  • Data Cache
  • Query Pruning

17 - Visualizing Query Execution with Query Profile

  • Using Explain
  • Using Query Profile

18 - Performance Tips and Troubleshooting

  • SQL Performance Tips
  • Performance Bottlenecks

Class Dates & Times

Class times are listed Eastern time

This is a 2-day class

Price : $2,000.00

D&H Price : $2,000.00

Class dates not listed.
Please contact us for available dates and times.