Snowflake Core & Advanced

DASVM’s Snowflake certification training course will prepare you to master data warehousing on the cloud. You will be able to load & transform data in Snowflake, scale virtual warehouses for performance and concurrency, share data and work with semi-structured data. You will also gain a thorough knowledge of query constructs, DDL & DML operations, managing and monitoring Snowflake accounts and Snowflake’s continuous data protection methods.

img
request

Can’t find a batch you were looking for?

 

In this course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Platform. The course will consist of lecture, demos, and labs on a wide range of foundational topics. In this course covers advanced Data Movement, Performance, Security, Agile Development and Data Sharing design considerations and best practices in the Snowflake Cloud Data Platform. This advanced course will consist of lecture, demos, and labs.

Course content

 

Introduction to Snowflake
  • How different from traditional DB like (Oracle …)
  • Quick start to Snowflake and accessing trial account
  • Creating warehouse, DB, Schema, and tables
  • Accessing different roles and using it
  • Working with worksheets
  • Understanding different type of accounts
Understand Cloud Platforms
  • AWS and understanding S3 storage
  • Snowflake architecture and caching.
  • AZURE and understanding blob storage
  • GCP and understanding Bucket storage
Snowflake Architecture and Overview
  • Snowflake Technical Overview
  • Cloud Services Layer
  • Compute Layer
  • Storage Layer
Data Movement
  • Data Loading
  • Unloading
  • File formats
  • Internal and external storage
  • Copy into usage
  • Snowflake internal storage
  • Accessing Cloud storage data into Snowflake(GCP, AZURE and AWS)
Snowpipe
  • Accessing Snowpipe
  • PUT and GET commands
  • Bulk loading from cloud storage
  • Continuous loading
Snowflake Objects & Commands
  • Query Constructs
  • Data Description Language (DDL)
  • Data Manipulation Language (DML)
Snowflake SQL Support for Data Analysis
  • SQL Support and Query Best Practices
  • SQL Analytic Functions
  • High Performing Estimation Functions
  • UDF and Stored Procedure
  • Demo Query Profile
Managing Security
  • Data Encryption
  • Authentication
  • Role-Based Access Control
Semi-structured Data
  • Capabilities and Best Practices for working with semi-structured data in Snowflake
Caching
  • Caching Features in Snowflake
  • Best Practices of using caching for performance and cost optimization
Snowflake Clients and Ecosystem
  • Snowflake Clients and Connectors Overview
  • SnowSQL – Snowflake CLI
Continuous Data Protection
  • Time Travel in Snowflake
  • Cloning in Snowflake
Cloning
  • Access Control Privileges for Cloned Objects
  • Cloning and Snowflake Objects
  • Impact of DDL on Cloning
  • Impact of DML and Data Retention on Cloning
Data Sharing
  • Snowflake Data Sharing Overview
Performance & Concurrency
  • Query Profile
  • Micro-Partitions & Data Clustering
  • Scaling a Virtual Warehouse
Account and Resource Management and Monitoring
  • System Resource Usage and Billing
  • Managing Virtual Warehouses
  • Workload independence and segmentation
  • Monitoring Tool: Resource Monitors
  • Monitoring Tools: Information Schema and Account Usage
Advanced Architecture
  • Technical deep dive of three-tiered architecture
  • Connector and APIs for applications (Python)
Managing Security
  • Data Encryption & Network Security
  • User and Application Authentication
  • Designing a Role Hierarchy
  • Advanced Snowflake Account Security Features
Agile Development & Continuous Data Protection
  • Continuous Data Protection
  • Agile Development use cases & best practices
Data Sharing 
  • Data Providers and Consumers
  • Sharing outside your organization
  • Sharing within your organization
Advanced Performance Tuning
  • Designing Tables for High Performance
  • Designing High-Performance Queries
  • Advanced Performance Tuning
  • Query Profile Optimization
  • Data Clustering
  • Materialized Views
  • Monitoring

 

To see the full course content Download now

Course Prerequisites

 
  • Previous Data Warehouse knowledge is assumed.

Who can attend

 
  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

Number of Hours: 40hrs

Certification

SnowPro Core Certification & SnowPro Advanced Certification

Key features

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Materials
  • Preparing for Certification

Call now: +91-99003 49889 and know the exciting offers available for you!

We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.

Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.

All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.

No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

DASVM Technologies provides many suitable modes of training to the students like:

  • Classroom training
  • One to One training
  • Fast track training
  • Live Instructor LED Online training
  • Customized training

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.

Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.

Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.

We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.

DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com

like our courses