When does class start/end?
Class hours may vary, please reach out to contact@ascendientlearning.com if you have any questions.
Snowflake SnowPro Advanced Architect
Skills Gained Attendees will leave understanding advanced Snowflake architecture and features such as partitioning, clustering, materialized views, time travel, and data sharing. Learn techniques for...
Read MoreOverview
Skills Gained
Attendees will leave understanding advanced Snowflake architecture and features such as partitioning, clustering, materialized views, time travel, and data sharing. Learn techniques for optimizing query performance, such as query profiling, query optimization, and caching. Data modeling and integration techniques, including schema design, data ingestion, data transformation, and data quality. Snowflake's security and compliance features, including access control, authentication, encryption, and auditing. They will also learn best practices and design patterns for designing and implementing Snowflake solutions, including data warehousing, data lakes, and real-time data pipelines.
Who Can Benefit
The audience for this class is data developers, data engineers, data architects, and database administrators and Data Warehouse knowledge.
Prerequisites
- Have taken the SnowPro Core training or have equivalent experience.
Course Details
Exam Overview
- Quick Introductions
- Discuss exam prerequisites, format, scoring, and passing requirements
- Review exam objectives and identify key areas to focus on
- Ensure participants have the necessary course materials
Snowflake Accounts and Security
In this module, attendees will learn about several layers of snowflake protection to ensure your data's confidentiality, integrity, and availability. Learn about best practices to implement security measures such as:
- Snowflake account and database strategy
- Snowflake's security features
- Managing user accounts and roles and implementing governance policies and procedures
- Data security best practices
- Encrypting data in Snowflake
- Network Security
- User, role, grants provisioning
Snowflake Virtual Warehouses
In this module, attendees will learn the knowledge and skills necessary to use Snowflake Virtual Warehouse features effectively. Topics will include:
- Understanding Snowflake's virtual warehouse concept i.e., Data Isolation, Concurrent workloads
- Creating and managing virtual warehouses
- Scaling virtual warehouses for performance optimization
- Troubleshooting virtual warehouse issues
Snowflake Architecture
In this module, attendees will understand Snowflake cloud architecture, how Snowflake uses virtual warehouses to provide scalable and elastic compute resources, and how Snowflake’s various levels of caching (Result, Local Disk, Remote) work.
- Snowflake architecture
- Benefits and limitations of various data models in the Snowflake environment
- Data Sharing solutions
- Snowflake object architecture and its impacts on architecture
- Data recovery
- Understanding Snowflake's deployment models (public cloud, private cloud, hybrid)
- Understanding Snowflake's data storage and virtual warehouse concepts
- Introduction to Snowflake's administration and monitoring tools
- Caching Features
- Performance Improvements
- Cost Optimization
Data Engineering
In this module, attendees will learn how to ingest and egress data from a data warehouse. Understanding best practices for moving data will help you build resilient data pipelines that are performant and secure.
- Understanding Snowflake's data loading methods (bulk loading, streaming, etc.)
- Integrating Snowflake with other data sources using connectors and APIs
- Data transformation and preparation in Snowflake
- Best practices for data ingestion and integration with Snowflake
Snowflake Data Storage
In this module, attendees will learn effective ways to manage and optimize data storage.
- Understanding Snowflake's data storage concepts
- Managing Snowflake data storage
- Using Snowflake tables and schemas
- Managing metadata in Snowflake
Snowflake Querying and Materialized Views
In this section, attendees will learn query acceleration, parallel query execution i.e., fast and efficient querying of large data sets.
- Querying data in Snowflake
- Advanced querying techniques in Snowflake
- Performance tuning and optimization strategies in Snowflake
- Understanding materialized views in Snowflake
- Creating and managing materialized views
- Using materialized views for query optimization
- Troubleshooting materialized view issues
Snowflake Advanced Features
Learn advanced state-of-the-art features in Snowflake.
- Introduction to advanced features of Snowflake
- Using external functions in Snowflake
- Automating data workflows with Snowflake tasks
- Managing data streams in Snowflake
- Time Travel
Snowflake Data Sharing
In this section, attendees will learn to share live data securely and efficiently with other organizations or internal groups within the organization.
- Overview of Snowflake's data-sharing features
- Sharing data across accounts and organizations
- Managing data-sharing activities in Snowflake
Performance Optimization
Learn how to construct scalable queries for reading data from a data warehouse and creating new objects.
- Query profiling
- Clustering
- Search optimization service
- Resource Monitors
- Information Schema and Account Usage
Exam Preparation
- Mock questions from the Exam
- Group Discussion on Questions
Schedule
FAQ
Does the course schedule include a Lunchbreak?
Classes typically include a 1-hour lunch break around midday. However, the exact break times and duration can vary depending on the specific class. Your instructor will provide detailed information at the start of the course.
What languages are used to deliver training?
Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.
What does GTR stand for?
GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.
How do I find an Ascendient Learning training location?
We have training locations across the United States and Canada - View a complete list of classroom training locations.
Which delivery formats are available?
At Ascendient Learning, we offer training that is Instructor-Led, Online, Virtual, and Self-Paced.
Does Ascendient Learning deliver group training?
Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.
What does vendor-authorized training mean?
As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.
Is the training too basic, or will you go deep into technology?
It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.
How up-to-date are your courses and support materials?
We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.
Are your instructors seasoned trainers who have deep knowledge of the training topic?
Ascendient Learning instructors have an average of 27 years of practical IT experience and have also served as consultants for an average of 15 years. To stay current, instructors spend at least 25 percent of their time learning new, emerging technologies and courses.
Do you provide hands-on training and exercises in an actual lab environment?
Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.
Will you customize the training for our company’s specific needs and goals?
We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.
How do I get started with certification?
Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact info@ascendientlearning.com.
Will I get access to content after I complete a course?
You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.
How do I request a W9 for Ascendient Learning?
View our filing status and how to request a W9.
Reviews
They were very good. They made sure everyone was able to get into the training and got all of the material needed for class.
ExitCertified provided a very organized way to learn and provided materials to follow along.
very good and spcecific course and above all a very good instructor. In few days I have learned a lot.
I was very pleased with the course setup by ExitCertified and the instructor.
Concise and good to follow along. Although it is a lot to take in under a short period of time.
