Get in Touch

Course Outline

Getting Started

Preparation for Beginnings

System prerequisites and requirements

Logging into Snowflake

Quick Tour of the Web Interface

Utilizing SnowSQL

Accessing SnowSQL

Creating Snowflake Objects

Staging Data Files

Copying Data into the Target Table

Querying 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

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

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories