Snowflake Cloud Data Platform

In this course you will have an expert coach teach you Snowflake, through live interaction after which its difficult to go back to the traditional way of doing data warehousing. All classes will have an additional moderator on standby to assist you with any difficulty.

Live Class: Friday, 21 Oct

Enrolled: 0

Duration: 25 Hours

Offered by: infyni

$429 30% off

$300

About Course

What is appealing about Snowflake is that it puts data warehousing in the cloud without locking customers into any cloud vendor. Though Google, Amazon, and Microsoft have their own offerings, Snowflake is seen as a neutral vendor. And it is popular because it's fast, scalable, accessible, secure, and cost-effective. 
In this live course you will be taught by our expert Snowflake coach on advanced Data Movement, Performance, Security, and best practices in the Snowflake Cloud Data Platform.
The Snowflake platform can support data analysis at almost any scale. Its patented, cloud-centric approach to data storage means that any amount of data can be stored and analyzed by an unlimited number of people or processes at the same time without resource contention. It enables you to build data-intensive applications without operational burden. Trusted by fast growing software companies, Snowflake handles all the infrastructure complexity.

Here are some of the current job opportunities requiring Snowflake skills :

1. Snowflake Consultant, Resources Valley, with 2-11 yrs experience
2. Snowflake Data Warehouse Application Developer, Accenture, with 4-6 yrs
3. Snowflake Module Lead, Mindtree Limited, with 5-8 yrs
4. Snowflake Technical Lead, Mindtree Limited, with 7-10 yrs
5. Snowflake Data Warehouse Application Developer, Accenture, with 4-6 yrs
6. Snowflake Data Warehouse Software Engineer, Aspire Recruitment Solutions, with 2-7 yrs


Skills You Will Gain

Snowflake Architecture Snow SQL DDL / DML SQL Command Snowflake SQL - Set Snowflake SQL - Functions & Transactions DATA Loading Micro-Partitioning and Clustering Virtual Warehouses Performance Tuning Snowflake Tables Time Travel Integrating Snowflake with Tableau Integrating Snowflake with PowerBI Snowflake Best Practices

Course Offerings

  • Instructor-led interactive classes
  • Clarify your doubts during class
  • Access recordings of the class
  • Attend on mobile or tablet
  • Live projects to practice
  • Case studies to learn from
  • Lifetime mentorship support
  • Industry specific curriculum
  • Certificate of Completion
  • Employability Opportunity
  • Topics
  • Instructor (1)
  • Story Behind Snowflake
  • Snowflake Core Architecture
  • Cloud Agnostic Layer
  • Storage Layer
  • Compute Layer
  • Cloud Services
  • Contineous Availability
  • Create Snowflake Trial account
  • Snowflake Editions
  • Classic console
  • Snowsight
  • Snowflake partner connect
  • Download resources
  • Create Virtual Warehouse
  • Multicluster Virtual Warehouse
  • Scaling policies
  • Load Monitoring
  • Billing
  • Timetravel and Fail-safe
  • Permanent table
  • Transient table
  • Temporary table
  • External Table
  • Snowflake Stage
  • Overview of Data Loading/Unloading
  • COPY Command
  • Preparing to Load/Unload Data
  • Bulk Loading/Unloading from a Local File System
  • Bulk Loading/Unloading from Amazon S3
  • Snowflake Streams
  • Snowpipe
  • Tasks
  • Transient database in snowflake
  • Snowflake Continuous Data Integrations
  • Network Security
  • Authentication and Authorization
  • Data Encryption
  • Data Masking
  • Micro partitions in Snowflake
  • Advantages of Micro-Partitioning
  • Structure of Micro-Partition
  • Clustering Introduction
  • How clustering works & It's advantages
  • how to Choose right keys for clustering
  • Caching in Snowflake
  • Query History
  • Execution Plan
  • Role Based Access Control
  • Resource Monitors
  • Virtual Warehouse Sizing
  • Zero Copy Cloning
  • Upcoming Features - Snowpark, SQL API etc.
  • Snowflake Certifications
  • Data Migration to Snowflake

Snowflake Cloud Data Platform students also learn