Get in Touch

Course Outline

Getting Started

Preparation Steps

System prerequisites and requirements

Accessing Snowflake

Brief Overview of the Web Interface

Utilizing SnowSQL

Logging into SnowSQL

Creating Snowflake Objects

Staging Data Files

Copying Data into the Target Table

Querying the 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 Features Overview

Security and Data Protection

Tools and Interfaces

Connectivity

Data Import and Export

Data Sharing

Data Lifecycle Overview

Lifecycle Diagram

Data Organization

Data Storage

Data Querying

Manipulating Data

Data Removal

Continuous Data Protection

Ecosystem Overview

Data Integration

Business Intelligence (BI)

Advanced Analytics

Programmatic Interfaces

SQL Editing and Querying Tools

SnowSQL (CLI Client)

Installing SnowSQL

Configuring SnowSQL

Connecting via SnowSQL

Operational Usage of SnowSQL

Integration and Connection with Snowflake using connectors/drivers in your project

Data Manipulation

Loading Data into Snowflake

Unloading Data from Snowflake

Requirements

Familiarity with database systems and foundational data warehousing concepts is advised. Prior experience with SQL is strongly recommended.

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories