This event has been UPDATED since it was first published. View the UPDATED & Detailed Snowflake cloud data platform Training course for beginners Information here.

4 Weekends Snowflake cloud data platform training course is Instructor-led and guided and is being delivered: June 19, 2021 - July 10, 2021 for 16 Hours over 4 weekends, 8 sessions, 2 sessions per weekend, 2 hours per session.

Instructor-led and guided training
Practical Hands-On, Highly Interactive training
This course will be taught in English language
All Published Ticket Prices are in US Dollars

4 Weekends Snowflake cloud data platform Training Course Weekly Schedule

June 19, 2021 - July 10, 2021 US Pacific time
16 Hours | 2 Hours on Saturdays, 2 Hours on Sundays every weekend US Pacific time
8:30 AM - 10:30 AM US Pacific time each of those days
Please click here to add your city name and check your local date and time for the first session to be held on June 19, 2021 at 8.30 AM US Pacific Time.

Features and Benefits

16 Hours, 8 sessions, 4 weekends of total Instructor-led and guided training
Training material, instructor handouts and access to useful resources on the cloud provided
Practical Hands-on Lab exercises provided
Actual code and scripts provided
Real-life Scenarios

Course Objectives

Initial configuration
security and data management
creating snowflake objects
stage the data files
query the loaded data
Data sharing and validations in different formats
implementing standard and extended SQL support,
hands-on in SnowSql (Python-based web-client).

Prerequisites

If you do not have any of these prerequisite skills we will be happy to teach you these skills for additional cost before you take this training course.

Database
Beginner level Python

Who can take Snowflake cloud data platform Training Course?

Data Engineers
Database management professionals

Course Outline

1. Cloud Data Warehouse

Data warehousing: past to present
Understanding the benefits of a cloud data warehouse
Recognizing where cloud data warehousing fits in today's economy

2. Why the modern data warehouse emerged?

Adapting to increasing demands for data access and analytics
Adjusting to how data is created and used today
Tackling the challenges with new and improved technologies

3. Selecting a Modern Data Warehouse

Choosing the right data warehouse solution
Getting a high performance-to-price ratio
Making data security and protection a priority

4. Comparing Cloud Data Warehouse Solutions

Evaluating differences between cloud data warehouse options
Considering factors that affect performance
Choosing a solution that ensures data protection and security
Gauging your savings in administrative costs
Listing your data warehouse needs and success criteria
Considering all factors in the total cost of ownership
Taking your data warehouse for a test drive before you buy

5. Introduction and Connecting to Snowflake

Key Concepts & Architecture
Cloud Platforms
Snowflake Editions
Overview of Key Features
Overview of the Data Lifecycle
Continuous Data Protection
Overview of the Ecosystem
SnowSQL (CLI Client)
Installing SnowSQL
Configuring SnowSQL
Connecting Through SnowSQL
Using SnowSQL
JDBC Driver
Downloading / Integrating the JDBC Driver
Configuring and Using the JDBC Driver
JDBC Driver Diagnostic Service
ODBC Driver
Downloading the ODBC Driver
Installing and Configuring the ODBC Driver for Windows
ODBC Configuration and Connection Parameters
ODBC Driver API Support
ODBC Driver Diagnostic Service
Client Considerations
Diagnosing Common Connectivity Issues

6. Loading/Unloading Data Into/from Snowflake

Overview of Data Loading/Unloading
Data Loading/Unloading Considerations
Preparing to Load/Unload Data
Bulk Loading/Unloading from a Local File System
Bulk Loading/Unloading from Amazon S3
Bulk Loading /Unloading from Microsoft Azure
Loading Continuously Using Snowpipe
Loading Using the Web Interface (Limited)
Querying Data in Staged Files
Querying Metadata for Staged Files
Transforming Data During a Load

7. Using and Sharing Data in Snowflake

Using the Web Interface
Virtual Warehouses
Databases, Tables & Views
Queries
Date & Time Data
Semi-structured Data
Binary Data
Snowflake Time Travel & Fail-safe
Introduction to Data Sharing
Data Providers
Getting Started with Data Sharing
Working with Shares
Using Secure Objects to Control Data Access
Managing Reader Accounts
Configuring a Reader Account
Data Consumers

8. Managing your Snowflake Account

System Usage & Billing
Understanding Snowflake Credit and Storage Usage
Understanding Snowflake Data Transfer Billing
Monitoring Account-level Credit and Storage Usage
Working with Resource Monitors
Parameter Management
User Management

4 Weekends Snowflake cloud data platform Training Course Geneva