Course Outline
Getting Started
Before You Begin
System prerequisites and requirements
Logging into Snowflake
Quick Tour of the Web Interface
Using SnowSQL
Log into SnowSQL
Create Snowflake Objects
Stage the Data Files
Copy Data into the Target Table
Query the Loaded Data
Summary and Clean Up
Key Concepts & Architecture
Data Warehouse as a Cloud Service
Snowflake Architecture
Database Storage
Query Processing
Cloud Services
Connecting to Snowflake
Cloud Platforms
Overview of Key Features
Security and Data Protection
Tools and Interfaces
Connectivity
Data Import and Export
Data Sharing
Overview of the Data Lifecycle
Lifecycle Diagram
Organizing Data
Storing Data
Querying Data
Working with Data
Removing Data
Continuous Data Protection
Overview of the Ecosystem
Data Integration
Business Intelligence (BI)
Advanced Analytics
Programmatic Interfaces
SQL Editing / Querying Tools
SnowSQL (CLI Client)
Installing SnowSQL
Configuring SnowSQL
Connecting Through SnowSQL
Using SnowSQL
Connecting and Integrating with Snowflake using connector/driver with your project
Playing with Data
Loading the Data INTO Snowflake
Unloading the data FROM Snowflake
Requirements
Previous understanding of database systems and basic data warehousing concepts is recommended. Prior knowledge of SQL is highly recommended.
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.