Create Event
Search results for:
No result found! Try with different keywords!
Advertisement
4 Weeks Snowflake cloud data platform Training Course Newark

4 Weeks Snowflake cloud data platform Training Course Newark

Mon Feb 01, 2021

4 Weeks Snowflake cloud data platform Training Course Newark

Time Mon Feb 01 2021 at 08:30 pm to 10:30 pm

(add to calendar)

IT Training Center, Tech Training Solutions, Newark, United States

USD 700
Find Tickets on eventbrite.com
Advertisement

4 Weeks Snowflake cloud data platform Training Course Newark, 1 February | Event in Newark | AllEvents.in 4 Weeks Snowflake cloud data platform Training Course Newark
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



Also check out other Workshops in Newark.

Tickets

Tickets for 4 Weeks Snowflake cloud data platform Training Course Newark can be booked here.

Get Tickets

Ticket Information Ticket Price
Early Bird USD 700
Regular USD 800
Search by related topics in Newark
Event Photos
Hosted by
Nearby Hotels IT Training Center, Tech Training Solutions, Newark, United States
Event details from Report a problem ?

Event Information

Date & Time

Mon Feb 01 2021 at 08:30 pm to 10:30 pm
Add to Calendar

Location

IT Training Center, Tech Training Solutions, Newark, United States

Advertisement
Discover more events
Advertisement
Make Your Events Easy to Discover

Create an online presence of your events and make them easy to discover & share with the relevant audience.

Create Events