Get in Touch

Course Outline

Getting Started

Initial Setup and Preparation

System Prerequisites and Requirements

Accessing Snowflake

Familiarizing Yourself with the Web Interface

Utilizing SnowSQL

Establishing a SnowSQL Session

Creating Objects in Snowflake

Staging Data Files

Inserting Data into Target Tables

Executing Queries on Loaded Data

Review and Cleanup Procedures

Core Concepts & Architecture

Data Warehousing as a Cloud Service

The Snowflake Architectural Model

Database Storage Mechanisms

Query Processing Workflows

Cloud-Based Services

Establishing Connections to Snowflake

Supported Cloud Platforms

Overview of Essential Features

Security Frameworks and Data Safeguards

Available Tools and User Interfaces

Connectivity Options

Data Ingestion and Export Capabilities

Secure Data Sharing

Understanding the Data Lifecycle

Lifecycle Visualization

Structuring Data

Data Storage Strategies

Data Querying Techniques

Manipulating Data

Data Deletion Processes

Continuous Protection Mechanisms

Exploring the Ecosystem

Data Integration Solutions

Business Intelligence (BI)

Advanced Analytical Tools

Programmatic Access Points

SQL Editing and Querying Utilities

SnowSQL (Command-Line Interface)

Installation of SnowSQL

Configuration Setup

Connecting via SnowSQL

Practical Use of SnowSQL

Integrating Snowflake into Projects using Connectors and Drivers

Data Manipulation Exercises

Ingesting Data into Snowflake

Extracting Data from Snowflake

Requirements

A foundational understanding of database systems and core data warehousing principles is advised. Additionally, prior proficiency in SQL is strongly recommended to fully benefit from the training.

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories