In this accelerated course presents the key performance capabilities, Snowflake best practices, and tuning techniques that are designed to help participants to use Snowflake Cloud Data Platform to develop diverse high-performance workloads. The course illustrates performance design best practices and pitfalls so that participants are prepared to apply the methodology and features to their own diverse workloads.
The course is delivered on the latest version of Snowflake Cloud Data Platform with new performance features and some emerging features in public preview.
This course will consist of lectures with many practical examples in instructor-led demos, followed by hands-on exercises. The course is designed to provide participants with the following acquired skills.
Learning Objectives:
- Work effectively and efficiently with the key capabilities and best practices behind Snowflake Cloud Data Platform’s three-tiered architecture designed for performance and scale
- Apply the right set of Snowflake-provided tools for performance assessment and optimization
- Use Snowflake tuning methodology on established performance features including best practices and avoiding pitfalls to work efficiently with the platform
- Explore emerging performance features with suitable use cases and adoption of best practices
- Formulate diverse high performance and efficient workloads including data transformations, analytic applications, and data sharing.
- Achieve cost optimization by working effectively and monitoring Snowflake Cloud Data Platform
Course content
Performance Built from Ground-up in Snowflake Architecture
- Automatic micro-partitioning
- Natural data clustering
- Workload segmentation
- Vectors of compute scaling
- Understand what the execution engine can do for you
- Understand what the optimizer can do for you
- Lightning fast metadata service
- Caching features
Snowflake Performance Diagnostic and Tuning Toolset
Snowflake toolset spanning from detailed micro-partitioning level, all the way to system and account level
- Query profile and explain plan
- Query profile and query scenarios
- Explain plan and query scenarios
- Understanding micro-partitioning and statistics
- Assessing clustering quality
- Using INFORMATION_SCHEMA functions and account usage share database
- Common investigation scenarios
Best Practices across Snowflake Data Platform
- Writing effective queries
- Scaling up, right-sizing warehouse, and concurrency
- Metadata operations and optimizations
- Connectors and data science interfaces [Spark, Python, ARROW, ETL Tools]
Best Practices for Raw Data Zone
- Snowflake as a data lake
- Batch data ingestion and DML
- Streaming ingestion
Best Practices for Conformed Data Zone
- Incremental data processing and CDC
- Evaluating data formats and semi structured data
- Data engineering pipelines
- Data clustering and tuning
Best Practices for Modeled Data Zone
- Materialized views and use cases
- High performance query features
- Data unloading
- Best practices for BI tools and data applications
Emerging Performance Features
- Highlighted preview features and appropriate use cases
- Explore adoption best practices for new features
Monitoring and Optimizing Costs
- Virtual warehouse compute
- Serverless compute
- Cloud services metadata operations
- Storage
- Replication
- Data transfer
To see the full course content Download now
Course Prerequisites
- This course is designed for participants with extensive hands on experience with Snowflake or participants that have taken other relevant Snowflake courses such as Snowflake Fundamentals or Snowflake Advanced.
Who can attend
- Technical Team Leads
- Data Architects
- Snowflake Administrators
- Data Engineers
- Data Application Developers
Number of Hours: 30hrs
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