Course Outline
Getting Started
Preparation Requirements
System prerequisites and specifications
Accessing Snowflake
Brief Introduction to the Web Interface
Utilizing SnowSQL
Logging in to SnowSQL
Creating Objects in Snowflake
Staging Data Files
Loading Data into Target Tables
Querying the Ingested Data
Summary and Cleanup Procedures
Core Concepts and Architecture
Data Warehousing as a Cloud Service
Snowflake Architecture Overview
Data Storage Mechanisms
Query Processing Logic
Cloud Services Integration
Establishing Connections to Snowflake
Supported Cloud Platforms
Overview of Essential Features
Security Protocols and Data Safeguarding
Available Tools and Interfaces
Connectivity Options
Data Import and Export Capabilities
Data Sharing Features
Introduction to the Data Lifecycle
Data Lifecycle Diagram
Data Organization Strategies
Data Storage Methods
Data Querying Techniques
Data Manipulation Processes
Data Deletion Procedures
Ongoing Data Protection
Ecosystem Overview
Data Integration Tools
Business Intelligence (BI) Solutions
Advanced Analytics Capabilities
Programmatic Interfaces
SQL Editing and Querying Utilities
SnowSQL (CLI Client)
Installation of SnowSQL
Configuration of SnowSQL
Connection via SnowSQL
Operational Use of SnowSQL
Connecting and Integrating with Snowflake via Connectors/Drivers for Your Project
Data Manipulation Exercises
Ingesting Data into Snowflake
Extracting Data from Snowflake
Requirements
A foundational understanding of database systems and basic data warehousing principles is suggested. 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.
