Get in Touch

Course Outline

Getting Started

Preparation Steps

System Prerequisites and Requirements

Accessing Snowflake

Brief Overview of the Web Interface

Working with SnowSQL

Connecting to SnowSQL

Creating Snowflake Objects

Staging Data Files

Inserting Data into Target Tables

Querying Imported Data

Review and Cleanup

Core Concepts and Architecture

Data Warehousing as a Cloud Service

Snowflake Architecture Overview

Database Storage Mechanisms

Query Processing Model

Cloud Service Components

Establishing Snowflake Connections

Supported Cloud Platforms

Key Feature Highlights

Security and Data Protection Measures

Available Tools and Interfaces

Connectivity Options

Data Import and Export Capabilities

Data Sharing Functionality

Data Lifecycle Overview

Lifecycle Visualisation

Data Organisation Strategies

Data Storage Practices

Data Querying Techniques

Data Manipulation

Data Removal Procedures

Continuous Data Protection

Ecosystem Overview

Data Integration Solutions

Business Intelligence (BI) Tools

Advanced Analytics Capabilities

Programmatic Interfaces

SQL Editing and Querying Utilities

SnowSQL (Command-Line Client)

Installing SnowSQL

Configuring SnowSQL

Connecting via SnowSQL

Utilising SnowSQL Commands

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

Practical Data Handling

Loading Data INTO Snowflake

Unloading Data FROM Snowflake

Requirements

While not mandatory, a foundational understanding of database systems and basic data warehousing principles is advised. Proficiency in SQL is strongly recommended for participants.

 21 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories