Get in Touch

Course Outline

Getting Started

Preparation for the Session

System requirements and prerequisites

Accessing Snowflake

Overview of the Web Interface

Using SnowSQL

Logging into SnowSQL

Creating Snowflake Objects

Staging Data Files

Loading Data into Target Tables

Querying 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 Feature Overview

Security and Data Protection

Tools and Interfaces

Connectivity Options

Data Import and Export

Data Sharing

Data Lifecycle Overview

Lifecycle Diagram

Data Organization

Data Storage

Data Querying

Data Manipulation

Data Deletion

Continuous Data Protection

Ecosystem Overview

Data Integration

Business Intelligence (BI)

Advanced Analytics

Programmatic Interfaces

SQL Editing & Querying Tools

SnowSQL (CLI Client)

Installing SnowSQL

Configuring SnowSQL

Establishing Connections via SnowSQL

Utilizing SnowSQL

Integration with Snowflake using connectors/drivers for your project

Exploring Data

Loading Data into Snowflake

Unloading Data from Snowflake

Requirements

Familiarity with database systems and fundamental data warehousing principles is advisable. Prior proficiency in SQL is strongly encouraged.

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories