infyni

Snowflake Cloud Data Platform

Unleash the potential of Snowflake Cloud Data Platform with Infyni's dynamic live online course. Expert-led sessions, hands-on projects, and real-time collaboration empower you to revolutionize data handling and analytics.

Live Course

Live Class: Saturday, 09 Mar

Duration: 25 Hours

Enrolled: 1

Offered by: infyni

(19)

Live Course
$390 30% off

$273

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)
  • Reviews
  • 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

(19)

Snowflake Cloud Data Platform students also learn