4 Weeks Snowflake cloud data platform Training Course Elk Grove

Mon Feb 01 2021 at 05:30 pm to 07:30 pm

IT Training Center | Elk Grove

Tech Training Solutions
Publisher/HostTech Training Solutions
4 Weeks Snowflake cloud data platform Training Course Elk Grove
Advertisement
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
  • February 1, 2021 - February 24, 2021 US Pacific time
  • 4 Weeks | 2 Hours on Mondays, 2 Hours on Wednesdays every week US Pacific time
  • 5:30 PM - 7:30 PM 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 February 1, 2021 at 5:30 PM 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
Advertisement

Event Venue & Nearby Stays

IT Training Center, Tech Training Solutions, Elk Grove, United States

Tickets

USD 700.00 to USD 800.00

Sharing is Caring: