This course is designed for Software Developers, DBA, Software Architects, Quality Assurance Engineers, BI Professionals

Basic understanding of relational databases and using SQL, Python

Course Outline:

1. Snowflake Architecture

• Snowflake and Cloud Environments
• Three Tier architecture
• Understanding Data Storage, Query Processing and Cloud Services
• Snowflake UI – Query pane, Results Pane and Object Pane
• Lab: Examine Snowflake UI

2. Snowflake Features

• Standard and Extended SQL
• Tools and Interfaces
• Connectivity
• Understanding Roles Hierarchies
• Lab: Roles

3. Structured Data Ingestion

• Database objects for Structured Data Ingestion
• Stage and File Objects
• Bulk load from Cloud Storage
• Local Storage: Load and Unload data
• Querying ingested data
• Lab: Multiple Data Ingestion Labs

4. Unstructured Data Ingestion

• Database objects for Un-structured Data Ingestion
• Ingesting JSON data
• Querying Data
• Lab: JSON data ingestion

5. Data Sharing and Continuous Data Protection

• What is a Data Share?
• Data Providers and Consumers
• Share Data with Snowflake & Non-snowflake users
• Understanding Time Travel & Fail-safe
• Zero copy cloning
• Cloning Database, Schema, Tables
• Labs: Multiple Labs on these topics

6. Tasks & Procedures

• Understanding Tasks, Stored Procedures and Functions
• Tasks and Scheduling
• Using Stream Objects
• Streams and Tasks
• Labs: Using Tasks

7. Data Caching & Clustering

• Table Types
• Snowflake Caching Features
• Understanding Clustering
• Clustering keys
• Labs: Caching and Clustering labs

8. Snowpark API (Python)

• Read and write operations
• Understanding how Snowpark API works
• Read and load data from Amazon S3 into snowflake
• Should and should not do with Snowpark API
• Create Snowpark UDF (User Defined Function)
• Leverage third-party Python libraries
• Labs: on topics described above

Training material provided: Yes (Digital format)

Hands-on Lab: Instructions will be provided to set up a free tier snowflake account.