Data Warehousing using SnowFlake Training Course

Course Code

snowflake

Duration

21 hours (usually 3 days including breaks)

Requirements

Prior Understanding of Database systems and basic data warehousing concepts is recommended. A prior knowledge of SQL is highly recommended.

 

Overview

This training introduces the team to SnowFlake. Snowflake is a fully relational ANSI SQL data warehouse so you can leverage the skills and tools your organization already uses. Updates, deletes, analytical functions, transactions and complex joins give you the full capabilities you need to make the most of your data.

Course Outline

Getting Started

  • Before You Begin

  • System prerequisites and requirement

  • 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

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Jordan!

As a Business Development Manager you will:

  • expand business in Jordan
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!