Get in Touch

Course Outline

Getting Started

Before You Begin

System prerequisites and requirements

Logging into Snowflake

Quick Tour of the Web Interface

Using SnowSQL

Log into SnowSQL

Create Snowflake Objects

Stage the Data Files

Copy Data into the Target Table

Query the Loaded Data

Summary and Clean Up

Key Concepts & Architecture

Data Warehouse as a Cloud Service

Snowflake Architecture

Database Storage

Query Processing

Cloud Services

Connecting to Snowflake

Cloud Platforms

Overview of Key Features

Security and Data Protection

Tools and Interfaces

Connectivity

Data Import and Export

Data Sharing

Overview of the Data Lifecycle

Lifecycle Diagram

Organizing Data

Storing Data

Querying Data

Working with Data

Removing Data

Continuous Data Protection

Overview of the Ecosystem

Data Integration

Business Intelligence (BI)

Advanced Analytics

Programmatic Interfaces

SQL Editing / Querying Tools

SnowSQL (CLI Client)

Installing SnowSQL

Configuring SnowSQL

Connecting Through SnowSQL

Using SnowSQL

Connecting and Integrating with Snowflake using a connector/driver in your project

Working with Data

Loading Data INTO Snowflake

Unloading Data FROM Snowflake

Requirements

A prior understanding of database systems and fundamental data warehousing concepts is recommended. Familiarity with SQL is highly advised.

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories