$425.98 – $532.07

4 Weeks Only Snowflake cloud data platform Training Course Monterrey

Event Information

Share this event

Date and Time

Location

Location

IT Training Center

Tech Training Solutions

Monterrey

Mexico

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Event description
4 Weeks Snowflake cloud data platform Training Course is being delivered from November 23, 2020 - December 16, 2020 US Pacific time.

About this Event

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 Weeks Snowflake cloud data platform training course is Instructor-led and guided and is being delivered from November 23, 2020 - December 16, 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

4 Weeks Only Snowflake cloud data platform Training Course Schedule

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
Share with friends

Date and Time

Location

IT Training Center

Tech Training Solutions

Monterrey

Mexico

View Map

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved