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

16 Hours Snowflake cloud data platform training course is Instructor-led and guided and is being delivered from October 29, 2020 - November 24, 2020 for 16 Hours over 4 weeks, 8 sessions, 2 sessions per week, 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

16 Hours Snowflake cloud data platform Training Course Schedule

• October 29, 2020 - November 24, 2020 US Pacific time
• 16 Hours | 2 Hours on Tuesdays, 2 Hours on Thursdays every week US Pacific time
• 7:30 AM - 9: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 October 29, 2020 at 7:30 AM US Pacific Time.

Features and Benefits

• 16 Hours, 8 sessions, 4 weeks 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