Course Outline
Getting Started
Preparation Steps
System Prerequisites and Requirements
Accessing Snowflake
Brief Overview of the Web Interface
Working with SnowSQL
Connecting to SnowSQL
Creating Snowflake Objects
Staging Data Files
Inserting Data into Target Tables
Querying Imported Data
Review and Cleanup
Core Concepts and Architecture
Data Warehousing as a Cloud Service
Snowflake Architecture Overview
Database Storage Mechanisms
Query Processing Model
Cloud Service Components
Establishing Snowflake Connections
Supported Cloud Platforms
Key Feature Highlights
Security and Data Protection Measures
Available Tools and Interfaces
Connectivity Options
Data Import and Export Capabilities
Data Sharing Functionality
Data Lifecycle Overview
Lifecycle Visualisation
Data Organisation Strategies
Data Storage Practices
Data Querying Techniques
Data Manipulation
Data Removal Procedures
Continuous Data Protection
Ecosystem Overview
Data Integration Solutions
Business Intelligence (BI) Tools
Advanced Analytics Capabilities
Programmatic Interfaces
SQL Editing and Querying Utilities
SnowSQL (Command-Line Client)
Installing SnowSQL
Configuring SnowSQL
Connecting via SnowSQL
Utilising SnowSQL Commands
Connecting and Integrating with Snowflake using connector/driver with your project
Practical Data Handling
Loading Data INTO Snowflake
Unloading Data FROM Snowflake
Requirements
While not mandatory, a foundational understanding of database systems and basic data warehousing principles is advised. Proficiency in SQL is strongly recommended for participants.
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.