SNOWFLAKE Logo v2
8351  Reviews star_rate star_rate star_rate star_rate star_half

Snowflake SnowPro Advanced: Data Engineer

This course prepares attendees to take the SnowPro Advanced Data Engineer exam. The advanced-level certification validates the skills and knowledge required to design and implement complex Snowflake...

Read More
Duration 3 days
Course Code INNO-SP-DATA-ENG
Available Formats Classroom

Overview

This course prepares attendees to take the SnowPro Advanced Data Engineer exam. The advanced-level certification validates the skills and knowledge required to design and implement complex Snowflake data solutions. This class covers advanced data modeling, advanced SQL, data integration, advanced data transformation, data quality, data visualization and reporting, performance tuning and optimization, and Snowflake deployment and management.

Skills Gained

The focus is on leveraging Snowflake with common data engineering competencies. This includes:

  • Source data from Data Lakes, APIs, and on-premises
  • Transform, replicate, and share data across cloud platforms
  • Design end-to-end near real-time streams
  • Design scalable compute solutions for DE workloads
  • Evaluate performance metrics.

Who Can Benefit

The audience for this class is Data Engineers.

Prerequisites

Attendees should have:

  • Completed the SnowPro Core training or have equivalent experience.
  • Ideally, a working knowledge of restful APIs, SQL, and a solid programming background.

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

Data Ingestion

Load Data into Snowflake

  • Discuss considerations for data loading
  • Data loading features and potential impacts
  • Ingest data of various formats (CSVs, Parquet Files, etc.)
  • Outline stages
  • Troubleshooting data ingestion

Data Pipelines and Snowpark

Design, build, and troubleshoot continuous data pipelines

  • Design a data pipeline that forces uniqueness but is not unique
  • Discuss and implement Stages, Tasks, Streams, Snowpipe, Auto-Ingest vs. Rest API
  • Understand Snowpark architecture
  • Deploy a UDF and a stored procedure using Snowpark
  • Design and use the Snowflake SQL API

Managing Data in Snowflake

  • Using connectors to connect to Snowflake
  • Design and build data sharing solution - Implement a Data Share, create a secure View, implement row-level filtering
  • External Tables - When to use and how they work, partitioning
  • Materialized Views
  • Partitioned data unloading

Performance Optimization

Troubleshooting Underperforming Queries

  • How to identify underperforming queries
  • Understanding metrics around query operations
  • Increasing efficiency and cost considerations
  • Identifying the root cause of underperforming queries

Understanding performance improvement levers available in Snowflake

  • Scale-Out vs. Scale In
  • Clustering vs. increasing warehouse size
  • Search optimization in Snowflake
  • Performance of Materialized Views
  • Discuss query complexity
  • Micro-Partitions and the impact of clustering
  • Discuss caching in Snowflake
  • How to monitor continuous data pipelines - Snowpipe, Stages, Tasks, and Streams

Storage and Data Protection

  • Implement data recovery features in Snowflake (Time Travel + Fail Safe)
  • Impact of Streams on Time Travel
  • Using system functions to analyze micro-Partitions (Cluster Depth + Cluster Keys)
  • Using Time Travel in DevOps
  • Creating a backup database
  • Test changes before deployment
  • How to rollback using Time Travel

Security

  • Authentication Methods: Single-Sign-On, Key Authentication, Username/password, Multi-Factor Authentication
  • Dive into Role-Based Access Control in Snowflake with examples
  • Combining column-level security, and data masking with RBAC to secure sensitive data
  • Discuss System Defined Roles - usage and best practices (SYSADMIN, SECURITYADMIN, USERADMIN, ACCOUNTADMIN, ORGADMIN)
  • Data Governance
  • Column Level Security - Dynamic Data Masking and External Tokenization
  • Row Level Security - snowflake row access policies
  • DDL for Dynamic Data Masking + row access policies
  • Object Tagging (method and best practices)
  • Masking Policies (method and best practices)

User Defined Functions

  • Create a secure UDF
  • SQL and Javascript UDFs
  • Returning table vs. scalar values in UDFs
  • Define and create external functions (Secure External Functions)

Stored Procedures and Data Transformation

  • Stored Procedures - design, build, and leverage
  • Transaction management in Snowflake
  • Handle and transform semi-structured data
  • Convert semi-structured data to structured data
  • Convert structured data to semi-structured data

Snowpark for Data Transformation

  • Query and filter data using the Snowpark library
  • Perform data transformation using Snowpark (aggregations, etc.)
  • Joining Snowpark data frames

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.

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

The instructor was thorough and they also provided hands-on demonstrations with labs.

Easy to work with. Learning material pdfs were able to be printed out in color which was very nice to write on.

They were very good. They made sure everyone was able to get into the training and got all of the material needed for class.

Great training it covered the most importan topics if GitHub copilot with good explanation and good labs.

Course was great and informative. The instructor had a good flow and was very personable.

Prerequisites