Snowflake Data Analyst Training

Price
$2,000.00 USD

Duration
2 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 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.

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.

Who Should Attend?

  • Data Analysts
  • Business Intelligence users
  • 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

  • Basic knowledge of SQL is required

Agenda

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
 

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: 3606100E
 



Do You Have Additional Questions? Please Contact Us Below.

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