$744.24 – $850.33

4 Weeks Snowflake cloud data platform Training Course Singapore

Actions and Detail Panel

From $744.24

Event Information

Share this event

Date and Time

Location

Location

IT Training Center

Tech Training Solutions

Singapore

Singapore

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 is being delivered from February 1, 2021 - February 24, 2021 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 February 1, 2021 - February 24, 2021 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

Singapore

Singapore

View Map

Refund Policy

Refunds up to 1 day before event

Eventbrite's fee is nonrefundable.

Save This Event

Event Saved