Snowflake Data Engineer Training
This three-day, role-specific course covers key concepts, features, considerations, and Snowflake best practices through the lens of the data engineering workflow. It is intendedfor participants who will be accessing, developing, and querying datasets for analytic tasks and building data pipelines in Snowflake. This course consists of core data engineering concepts delivered through lectures, demos, labs, and discussions.
In this course, you will:
- Describe the data engineering workflow and how the Snowflake Data Cloud features support the various components of the workflow.
- Access Snowflake through the Snowsight UI and by using application methods.
- Load and unload data sets.
- Configure Snowflake features to cover a range of data ingestion and processing latencies.
- Develop applications for Snowflake, including comprehensive ANSI standard SQL support.
- Employ performance and cost optimization techniques.
- Use Snowflake’s capabilities to work eectively with structured, semi-structured, and unstructured data in Snowflake.
- Tune queries and improve performance using advanced techniques such as data clustering and materialized views.
- Employ Snowflake SQL extensibility features such as user-defined functions and stored procedures.
This course is intended for:
- Data Analysts
- Data Engineers
- Data Scientists
- Database Architects
- Database Administrators
- Data Application Developers
We recommend that attendees of this course have:
- A background in data engineering is required.
- Completion of “Snowflake Foundations” one-day course or equivalent Snowflake knowledge.
Introduction to the Data Engineering Workflow
Module 1: Supporting Platform Features
- Authentication Methods
- Drivers, Clients, and Connectors Overview
- Integrations
- Snowflake Connector for Python
- SnowSQL
- Role-based Access Control (RBAC) Overview
- Introduction to Data Governance
Module 2: Data Storage
- Semi-structured Data
- Query Semi-structured Data
- Data Lake
Module 3: Ingestion
- Bulk vs. Continuous Data Loading Approaches
- Snowpipe
- Snowpipe Streaming
- Snowflake Connector for Kafka
- Snowflake Connector for Kafka With Snowpipe Streaming
- Snowflake Data Loading Best Practices
- Loading Semi-structured Data
- Schema Detection
- Working With Unstructured Data
- Creating and Managing Streams
- Streams on Views
Module 4: Orchestration
- Creating and Managing Tasks
- Using Streams and Tasks Together
Module 5: Transformation
- Dynamic Tables
- Extensibility Overview
- Snowflake Scripting
- JavaScript Stored Procedures
- SQL and JavaScript UDFs and UDTFs
- External Functions
- External Network Access
- Introduction to Snowpark
- Java and Python Functions and Stored Procedures Introduction
- Transformations With Unstructured Data
Module 6: Performance Optimization
- Natural Clustering
- Explicit Clustering
- Automatic Clustering Service
- Search Optimization Service Introduction
- SQL Performance Tips
- Performance Bottleneck Scenarios
Module 7: Delivery
- Materialized Views
- Unloading Semi-structured Data
- Data Sharing
- Data Exchange
- Snowflake Marketplace
- Secure Views
- Secure UDFs
- Streams on Shared Tables
- Common Table Expressions (CTEs)
Module 8: Management and Observability
- Observability on Snowflake
- Outbound Notifications
- Snowflake Alerts
- Observability Within Snowsight
- Query Tags
- Cost Controls
- Resource Monitors
- Parameters
Class Deliverables
- E-Content kit by AWS
- Hands-on labs
- Class completion certificates
- Exam Prep sessions
Class Schedule
Stay ahead with our comprehensive course schedule. Browse upcoming training sessions & reserve your spot to gain hands-on expertise & certification-ready skills.
| Virtual | 3 days | All Day | June 4, 2024 | ₹0 | |
| Virtual | 3 days | All Day | June 18, 2024 | ₹0 | |
| Virtual | 3 days | All Day | July 8, 2024 | ₹0 | |
| Virtual | 3 days | All Day | July 22, 2024 | ₹0 |
FAQs
Find answers to commonly asked questions about our courses, certifications, schedules, and more.
Your cloud learning journey made simple and transparent.
To enroll in this course, choose the starting date and make an online payment. Once your payment is confirmed, our team will reach out to you.
Wire Transfer, Credit Card, Debit Card, UPI & Purchase Order.
There is no minimum number of candidates required, we are happy to train 1 to 1 . With regards to the maximum number, we can accomodate 30 learners in one batch.
- Training Delivered by an Amazon Authorized Instructor.
- AWS Content E-Kit
- Hands-on-labs for 30 days
- Class attendance certificate
You will get the access to course content & lab on first day of your training session.
The course Completion Certificate will be issued to your email id within 2 weeks of completing your course.
A one-day course could be delivered over two half day sessions (4 hours a day), or a three-day course could be delivered over five days (4 hours a day)
