HOW TO USE SNOWFLAKE – HALF DAY EDUCATION

COURSE DESCRIPTION:

This course covers the Snowflake UI and how to create and manage your Snowflake objects.

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:

  • How do you create Users and Roles?
  • What do Snowflake Virtual Warehouses do, how do you create them and how do you use them?
  • What is the concept around Snowflake databases, how do you create them and what objects do they contain?
  • How do you create and load tables?
  • What are the different types of stage tables, how do you create and use them?
  • What are the different types of file formats you can load into Snowflake?
  • How do you ensure that users have the correct permissions for each object in Snowflake?
  • How do you query existing Snowflake data?
  • How do you create SQL scripts and run them?
  • How do you suspend a Virtual Warehouse when it is not in use?
  • How do you remove Snowflake objects?

COURSE CONTENT:

Snowflake Overview and Architecture

  • Industries
  • Traditional Data Warehouses
  • Data Warehousing as a Service
  • Multi Clustered Shared Architecture
  • Local Region and Availability Zones
  • Cloning
  • Time Travel
  • ACID transaction properties
  • Caching
  • Snowflake Editions
  • When not to use Snowflake
  • Security and Data Protection
  • Virtual Warehouses in Snowflake
  • Snowflake Credits

Using Snowflake

  • Snowflake UI

Users and Roles

  • Accessing Objects via Roles
  • Custom Roles
  • Follow Me

Virtual Warehouse and Database Creation

  • Virtual Warehouses
  • Databases
    • Tables
    • Columns
    • Views
    • Schemas
    • Stages
    • File Formats
    • Sequences
  • Follow Me

Data Loading

  • Overview
  • Worksheet Stage and Load
  • Snowpipe Stage and Load
  • Snowflake UI Load
  • Transform Data During Load
  • Follow Me

Querying

  • Querying Data  – Preview
  • Follow Me

Cloning

  • Follow Me

Suspending and Dropping

  • Suspend:
    • Warehouse
  • Dropping:
    • Warehouse
    • Databases
    • Schemas
    • Tables
    • Views
    • Stages
    • File Formats
    • Sequences
  • Follow Me
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Book Event

HOW TO USE SNOWFLAKE - HALF DAY EDUCATION
Available Tickets: 9
The HOW TO USE SNOWFLAKE - HALF DAY EDUCATION ticket is sold out. You can try another ticket or another date.

Date

07 Feb 2019

Time

01:30 PM - 05:00 PM

Cost

$1,100.00

Labels

Snowflake,
Sydney

Location

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