Course Outline
Getting Started
Preparation Steps
System prerequisites and requirements
Accessing Snowflake
Brief Overview of the Web Interface
Utilizing SnowSQL
Logging into SnowSQL
Creating Snowflake Objects
Staging Data Files
Copying Data into the Target Table
Querying the 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 Features Overview
Security and Data Protection
Tools and Interfaces
Connectivity
Data Import and Export
Data Sharing
Data Lifecycle Overview
Lifecycle Diagram
Data Organization
Data Storage
Data Querying
Manipulating Data
Data Removal
Continuous Data Protection
Ecosystem Overview
Data Integration
Business Intelligence (BI)
Advanced Analytics
Programmatic Interfaces
SQL Editing and Querying Tools
SnowSQL (CLI Client)
Installing SnowSQL
Configuring SnowSQL
Connecting via SnowSQL
Operational Usage of SnowSQL
Integration and Connection with Snowflake using connectors/drivers in your project
Data Manipulation
Loading Data into Snowflake
Unloading Data from Snowflake
Requirements
Familiarity with database systems and foundational data warehousing concepts is advised. Prior experience with SQL is strongly 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.