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