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 is being delivered from October 24, 2020 - November 15, 2020 US Pacific time for 16 hours over  4 weekends, 8 sessions, 2 sessions per week, 2 hours per session.

• The medium of instruction is English
• All Published Ticket Prices are in US Dollars.

4 Weekends Snowflake cloud data platform Training Schedule

• October 24, 2020 - November 15, 2020 US Pacific time
• 4 Weekends | 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 location and find your local date and time for the 1st session to be held on October 24, 2020 at 8:30 AM US Pacific Time

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