Course Outline
Getting Started
Initial Setup and Preparation
System Prerequisites and Requirements
Accessing Snowflake
Familiarizing Yourself with the Web Interface
Utilizing SnowSQL
Establishing a SnowSQL Session
Creating Objects in Snowflake
Staging Data Files
Inserting Data into Target Tables
Executing Queries on Loaded Data
Review and Cleanup Procedures
Core Concepts & Architecture
Data Warehousing as a Cloud Service
The Snowflake Architectural Model
Database Storage Mechanisms
Query Processing Workflows
Cloud-Based Services
Establishing Connections to Snowflake
Supported Cloud Platforms
Overview of Essential Features
Security Frameworks and Data Safeguards
Available Tools and User Interfaces
Connectivity Options
Data Ingestion and Export Capabilities
Secure Data Sharing
Understanding the Data Lifecycle
Lifecycle Visualization
Structuring Data
Data Storage Strategies
Data Querying Techniques
Manipulating Data
Data Deletion Processes
Continuous Protection Mechanisms
Exploring the Ecosystem
Data Integration Solutions
Business Intelligence (BI)
Advanced Analytical Tools
Programmatic Access Points
SQL Editing and Querying Utilities
SnowSQL (Command-Line Interface)
Installation of SnowSQL
Configuration Setup
Connecting via SnowSQL
Practical Use of SnowSQL
Integrating Snowflake into Projects using Connectors and Drivers
Data Manipulation Exercises
Ingesting Data into Snowflake
Extracting Data from Snowflake
Requirements
A foundational understanding of database systems and core data warehousing principles is advised. Additionally, prior proficiency in SQL is strongly recommended to fully benefit from the training.
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.