Join our intensive 3-day workshop, ‚I Data Analysis in Snowflake – SQL & AI‘, designed to provide Data Analysts with a comprehensive understanding of Snowflake’s data platform. This hands-on training will immerse you in the essential aspects of Snowflake, with a strong focus on SQL and using AI to accelerate your workflow. Engage in practical exercises and real-world scenarios to ensure you gain the skills necessary to effectively use Snowflake in your organization. Join us and transform your data operations with the power of Snowflake, SQL, and AI!
Format
Mostly workshops
Duration
3 days
Prerequisites
Basic understanding of SQL and/or Excel
Familiarity with general database concepts
Experience with data analysis concepts is a plus but not mandatory
Target Audience
Data Analysts
Data Engineers
IT Professionals involved in data analysis
Anyone interested in enhancing their data analysis skills using Snowflake
Training Program
Snowflake Overview
Introduction to Snowflake
Key features and architecture
Client Interfaces
Various client tools
Using the Snowflake web interface
Retrieving Data Using SELECT
Basic SELECT statements
Querying data from tables
Using an AI Co-pilot to Write SQL Queries
Overview of AI tools in Snowflake
Enhancing productivity with AI assistance
Creating Prompts
Using Built-in Functions for Processing and Formatting Retrieved Data
String functions
Date and time functions
Functions for Type Conversion
Converting between data types
Practical use cases
Sorting Query Results
ORDER BY clause
Sorting techniques
Filtering Rows
WHERE clause
Logical operators and conditions
Aggregate Functions
COUNT, SUM, AVG, MIN, MAX
Grouping data with aggregates
Data Grouping, Filtering Groups
GROUP BY clause
HAVING clause for group filtering
Retrieving Data from Multiple Tables – Joining Tables
DML – Inserting, Deleting, and Updating Records in the Database
INSERT statements
UPDATE and DELETE operations
Working with Semi-Structured Data
JSON, Avro, and other formats
Querying semi-structured data
DDL – Creating Tables, Data Types
CREATE TABLE statement
Data types and constraints
Comments useful for co-pilot
Time Travel & Cloning
Data recovery and historical data access
Cloning for data replication
Views – Creating and Retrieving Data
Creating and managing views
Use cases for views
Acquired skills
By the end of this workshop, participants will be well-equipped with the knowledge and hands-on experience needed to leverage Snowflake for data analysis.