SNOWFLAKE OVERVIEW AND ARCHITECTURE – HALF DAY EDUCATION

COURSE DESCRIPTION:

This course covers Snowflake Overview and Architecture.

You will understand the concepts and how the various parts of Snowflake work together.

AUDIENCE:

  • Anyone who currently works with or manages data storage.

APPROACH:

Tell Me, I’ll Forget; Show Me, I’ll Remember

BUSINESS NEEDS:

  • You may have to upgrade your computing facilities but you are concerned about the costs of hardware, software, management and maintenance!
  • Do you have a huge volume of data?
  • Do you need to store data securely?
  • Is your data encrypted both when stored and while being transmitted?
  • Do you want to securely share data?
  • Do you have fluctuating compute through-put requirements?
  • Can you find adequate IT staff?
  • Is data availability an issue?
  • Do you have your data in many different sources and wish to integrate it all into one place and to be able to access it using one language?
  • Are you paying too much and would only like to pay for what you use?
  • Do you have the need to stream your data continuously into storage?
  • Do you ever need to take a snapshot of your data easily?

COURSE CONTENT:

Snowflake Overview

  • Data Warehousing as a Service
  • Snowflake Overview
  • Multi Clustered Shared Architecture
  • Local Region
  • Availability Zones
  • ACID transaction properties
  • Caching
  • Snowflake Editions:
    • Standard
    • Premier
    • Enterprise
    • Enterprise for Sensitive Data
    • Virtual Private Snowflake
  • When not to use Snowflake
  • Security and Data Protection
  • SQL Support
  • Connectivity
  • Data Import and Export
  • Data Sharing
  • Data Lifecycle
  • Continuous Data Protection
  • Data Encryption
  • Parameters
  • Data Types
  • SQL Format Models
  • Object Identifiers
  • User-defined Functions
  • Information Schema

Snowflake Architecture

  • Data Storage
  • Compute Layer
  • Services Layer

Virtual Warehouses in Snowflake

  • Concept
  • How to determine appropriate size?
  • Resizing or multi-clustered VW to fix!
  • Snowflake Credits

Databases and Querying

  • Databases
  • Accessing Databases
  • Accessing Objects via Roles
  • Custom Roles
  • Querying

Data Loading

  • Data Loading
  • Staging
  • Load using SQL
  • Load using Web Interface

Demonstration

The Snowflake demonstration will:

  • Create Warehouse
  • Create Database
  • Create Schema
  • Create Table
  • Load Table – Warehouse
  • Load Table – Source Files
  • Load Table – File Format
  • Load Table – Load Options
  • Load Table – Load Results
  • Query Data – Preview
  • Query Data – SQL Query
  • Query Data – Export Results
  • Query Data – SQLScript
  • Query Data – Information Schema
  • Suspend Warehouse
  • Drop Warehouse
  • Drop Table
  • Drop Schema
  • Drop Database
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Book Event

SNOWFLAKE OVERVIEW AND ARCHITECTURE - HALF DAY EDUCATION
Available Tickets: 10
The SNOWFLAKE OVERVIEW AND ARCHITECTURE - HALF DAY EDUCATION ticket is sold out. You can try another ticket or another date.

Date

07 Feb 2019

Time

09:00 AM - 12:30 PM

Cost

$1,100.00

Labels

Snowflake,
Sydney

Location

MIP Sydney
Level 20, 31 Market St Sydney, NSW, Australia
REGISTER