Course Overview
This three-day accelerated course presents key performance capabilities, Snowflake best practices, and tuning techniques designed to help participants use Snowflake's Cloud Data Platform to develop diverse, high-performance workloads. The course illustrates performance design best practices and pitfalls, so participants are prepared to apply the methodology and features to their varied workloads. The system is delivered on the latest version of the Snowflake Cloud Data Platform with new performance features and some emerging features in public preview. This course consists of lectures with many practical examples in instructor-led demos, followed by hands-on exercises.
Prerequisites
This course is designed for participants with extensive hands-on experience with Snowflake or who have completed other relevant Snowflake courses, such as Snowflake Fundamentals (FUND) or Snowflake Advanced (ADV).
Audience Profile
- Data Application Developers
- Data Architects
- Data Engineers
- Snowflake Administrators
- Technical Team Leads
Learning Objectives
- Work effectively and efficiently with the key capabilities and best practices behind Snowflake's Cloud Data Platform three-tiered architecture designed for performance and scale.
- Apply the correct set of Snowflake-provided tools for performance assessment and optimization.
- Use Snowflake's 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 the Snowflake Cloud Data Platform.
Content Outline
- Overview
- Snowflake Architecture Review
- Cloud Services Layer
- Data Storage Layer
- Compute Layer
- Caching Review
- Query Profile
- Explain Plan
- Query Pruning
Data Zones
- Bulk Loading Data
- Transforming Data on Load
- Continuous Data Loading
- Loading Semi-structured Data
- Unloading Data
- Unloading Options
- External Tables
- Data Lake
- Snowflake Recommendations for External Tables and Data Lakes
- Optimization Principles and Techniques
- Query Processing and Optimizations
- Join Filters and Pruning
- Order By Tuning Scenarios
- Snowflake SQL Query Best Practices: Searching and Filtering
- Filter Tuning Scenarios
- Snowflake SQL Best Practices: Joining Data
- Tuning Joins
- Snowflake SQL Best Practices: Aggregate and Grouping
- Tuning Group By
- Subquery
- Subquery Tuning
- Common Table Expressions
- Performance Services Overview
- Clustering
- Search Optimization Service
- Materialized Views
- Streamline with Cloning and Time Travel
- Tap into the Power of SQL in ELT Processes
- System-defined Functions and Custom Functions
Streams
- Analytic Features and Performance
- Analytic Window Functions
- Ranking Queries and Comparison
- Top (N) Queries
- Performance and Tuning Considerations
- Sampling Queries
- Challenges with Statistical and Aggregation Functions
- Approximate Aggregates
- Approximate Statistics
- Additional Approximation
- Performance Bottlenecks
- Monitoring Query Queuing
- Compute Layer Resource Optimization
- Query Acceleration Service (QAS)
- Additional Cost Optimization
FAQs
A: Snowflake Training students need...
- To Bring A Laptop
- A Snowflake-Compatible Browser
A: We recommend you attend the live session to practice & clarify the doubts instantly and get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption and NOT for distribution or any commercial use.
A: The learners will be enthralled as we engage them in the natural world and Oriented industry projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you a lot in your future tasks and assignments.
A: It will be an added advantage if you have any technical knowledge. However, we will arrange additional sessions to train you on the basics.
A: You can request a refund if you do not wish to enroll in the course.
A: Yes, you can.
A: We adhere to the highest Internet security standards. Any data that is kept is not disclosed to any outside parties.
A: It is recommended but optional. Being acquainted with the primary course material will enable students and the trainer to move at the desired pace during classes. You can access courseware for most vendors.
A: You can buy online from the page by clicking on " Buy Now". You can view alternate payment methods on the payment options page.
A: Yes, students can pay from the course page.
A: The course completion certification will be awarded to all the professionals who have completed the training program & the project assignment given by your instructor. Using the certificate in your future job interviews will surely help you to l& your dream job.