Course Overview
This two-day, role-specific course presents additional topics and a deep dive into select subjects for the Data Engineer through the lens of the data engineering lifecycle. The course covers Snowflake concepts, features, considerations, and best practices intended for stakeholders accessing, developing, and querying datasets for analytical tasks and building data pipelines in Snowflake. This course comprises data engineering concepts delivered through lectures, demos, labs, and discussions.
Prerequisites
Successful completion of either the Snowflake Fundamentals or Snowflake Data Engineer course is recommended.
Audience Profile
- Data Analysts
- Data Engineers
- Data Scientists
- Database Architects
- Database Administrators
- Data Application Developers
Learning Objectives:
- Develop applications for Snowflake, including comprehensive ANSI standard SQL support.
- Identify and describe various data modeling techniques and architectures deployed on the Snowflake Platform.
- Effectively govern data stored and accessed in Snowflake.
- Use Snowflake capabilities to work effectively with structured, semi-structured, and unstructured data in Snowflake.
- Leverage Snowflake’s SQL extensibility features, such as user-defined functions and stored procedures.
- •Create applications that process data in Snowflake without transporting the data to the system hosting the application by using the Snowpark client libraries to query and convert data in a data pipeline.
- Automate data ingestion and expand data lake capabilities using Snowflake.
Content Outline
Overview and Architecture Recap
DE Lifecycle Recap
Data Governance (Tagging, Policies, Classification, External Tokenization)
- Data Modeling
- Data Vault
- Data Mesh
What are Iceberg Tables?
Schema Detection
- UDFs and UDTFs (Java, Python)
- Stored Procedures (Java, Scala, Python)
- Working With Snowpark
- Search Optimization Service
- Query Acceleration Service
Certification
- 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
FAQs
A: Snowflake Training students need...
- To Bring A Laptop
- A Snowflake-Compatible Browser
A: We would always 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 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.