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 connector/driver with your project

Playing with Data

Loading the Data INTO Snowflake

Unloading the data FROM Snowflake

Requirements

Previous understanding of database systems and basic data warehousing concepts is recommended. Prior knowledge of SQL is highly recommended.

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories