Course Outline
Getting Started
Preparation for the Session
System requirements and prerequisites
Accessing Snowflake
Overview of the Web Interface
Using SnowSQL
Logging into SnowSQL
Creating Snowflake Objects
Staging Data Files
Loading Data into Target Tables
Querying Loaded Data
Summary and Cleanup
Core Concepts & Architecture
Data Warehousing as a Cloud Service
Snowflake Architecture
Database Storage
Query Processing
Cloud Services
Connecting to Snowflake
Cloud Platforms
Key Feature Overview
Security and Data Protection
Tools and Interfaces
Connectivity Options
Data Import and Export
Data Sharing
Data Lifecycle Overview
Lifecycle Diagram
Data Organization
Data Storage
Data Querying
Data Manipulation
Data Deletion
Continuous Data Protection
Ecosystem Overview
Data Integration
Business Intelligence (BI)
Advanced Analytics
Programmatic Interfaces
SQL Editing & Querying Tools
SnowSQL (CLI Client)
Installing SnowSQL
Configuring SnowSQL
Establishing Connections via SnowSQL
Utilizing SnowSQL
Integration with Snowflake using connectors/drivers for your project
Exploring Data
Loading Data into Snowflake
Unloading Data from Snowflake
Requirements
Familiarity with database systems and fundamental data warehousing principles is advisable. Prior proficiency in SQL is strongly encouraged.
Testimonials (2)
The variety of the information shared and the clarity to explain terms in plain English.
Arisbe Mendoza - Fairtrade International
Course - GDPR Workshop
It's a hands-on session.