Course Overview
This three-day, role-specific course covers fundamental concepts, features, considerations, and Snowflake best practices through the lens of the data engineering lifecycle. It is intended for participants who will be accessing, developing, and querying datasets for analytical tasks and building data pipelines in Snowflake. This course consists of core data engineering concepts delivered through lectures, demos, labs, and discussions.
Prerequisites
Basic knowledge of SQL is helpful.
Audience Profile
- Data Analysts
- Data Engineers
- Data Scientists
- Database Architects
- Database Administrators
- Data Application Developers
Learning Objectives:
- Describe the data engineering lifecycle and how the Snowflake platform features support the various components of this lifecycle.
- Access Snowflake through the Snowsight UI and using application methods.
- Load and unload data sets.
- Develop applications for Snowflake, including comprehensive ANSI standard SQL support.
- Employ performance and cost optimization techniques using caching and high-performing functions.
- Use Snowflake’s capabilities to work effectively with structured, semi-structured, and unstructured data in Snowflake.
- Tune queries and improve performance using advanced techniques such as data clustering and materialized views.
- Leverage Snowflake SQL extensibility features such as Time Travel, user-defined functions, and stored procedures.
Content Outline
- Overview
- Snowflake Architecture
- Cloud Services Layer
- Data Storage Layer
- Compute Layer
- Caching (Metadata, Query Result, Data)
- Sample Data
- Web User Interface
- SnowSQL
Data Engineering Lifecycle Introduction
- Authentication Recap
- Role-based Access Control (RBAC) Recap
- Connectors Overview
- Cost Governance Framework
- Introduction to Data Governance
- Snowflake Database Objects
- Time Travel and Cloning
- Data Lake (External Tables, Materialized Views)
- Data Loading Concepts
- Bulk Data Loading
- Bulk vs. Continuous Data Loading Approaches
- Snowpipe
- Snowflake Data Loading Best Practices
- Data Loading, Transformations, and Validations
- Schema-on-Read with Semi-structured Data (Querying VARIANT Data)
- Schema-on-Write with Semi-structured Data (INFER_SCHEMA)
- Working With Unstructured Data (Directory Tables, Scoped URLs)
- Creating and Managing Streams
- Snowflake Connector for Kafka
- Creating and Managing Tasks
- Using Streams and Tasks Together
- DML and System Functions for Transformation (Sampling, Estimation, Grouping Sets, CTEs)
- Stored Procedures (JavaScript, Snowflake Scripting)
- UDFs and UDTFs (SQL, JavaScript)
- External Functions
- Introducing UDFs and UDTFs (Java, Python)
- Introducing Stored Procedures (Java, Python)
- Introduction to Snowpark
- Query Profile
- Explain Plan
- Natural Clustering
- Automatic Clustering Service (Explicit Clustering)
- Search Optimization Introduction
- SQL Performance Tips
- Performance Bottleneck Scenarios
- Snowflake Connector Ecosystem
- Materialized Views
- Unloading Data
- Snowflake Connector for Python
- Data Sharing (Secure Views and UDFs)
- Data Exchange
- Snowflake Marketplace
- Information Schema
- Snowflake Database
- Query Tags
- Cost Controls
- Resource Monitors
- Parameters
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 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.