Course Overview
This three-day course covers advanced Snowflake features related to data movement, performance, authentication, design considerations, and best practices in the Snowflake Platform. This advanced course consists of lectures, demos, and labs.
Prerequisites
Snowflake Fundamentals course
Audience Profile
- Data Analysts
- Data Engineers
- Data Scientists
- Database Architects
- Database Administrator
Learning Objectives:
- Evaluate Snowflake’s advanced architectural concepts.
- Design a bulk loading and load troubleshooting strategy.
- Employ strategies and Snowflake best practices for continuous data processing.
- Develop a methodology for performance tuning for your Snowflake Platform.
- Protect data access at the table, column, and row levels.
- Use data sharing and database replication.
Content Outline
- Three Architectural Layers
- Caching
- What is Integration?
- Security Integration
- Key Pair Authentication
- Data Ingestion Options
- Storage Integrations
- Copy Validation and Error Handling
- Fixing Load Failures
- Continuous Loading with Snowpipe
- Notification Integration
- Traditional Micro-batch Pipeline
- Alternative: Continuous Data Pipeline
- Stream Details
- How Streams Work
- Common Use Cases
- Structured vs. Semi-structured
- Loading and Transforming Semi-structured Data
- Workflow
- Unload Options
- Unloading Semi-structured Data
- Strategies and Capabilities for Unloading Semi-structured Data
- Geospatial Overview
- Geography
- Geometry
- Overview
- Concepts
- Workflow
- Data Lake Deployments
- Querying External Data Lakes
- Creating and Querying External Tables
- Partitioning External Tables
- Data Governance Overview
- Classification and Object Tagging
- Dynamic Data Masking
- External Tokenization
- Row Access Policies
- Audit Access History
- Data Access Options
- Direct Data Sharing
- Direct Data Sharing Workflow
- External Functions
- API Integrations
- SQL API
- Developer Framework
- What is Data Clustering?
- Micro-partition Pruning (Elimination)
- Evaluating Clustering
- Implement and Test Cluster Keys
- Search Optimization
- Materialized Views
- Materialized View Use Cases
- When to Use Materialized Views
- Query Acceleration Services (QAS)
Certification
- Prepare and load data
- Perform simple data transformations for data analysis
- Build and troubleshoot advanced SQL queries in Snowflake
- Use Snowflake built-in functions and create user-defined functions
- Perform descriptive and diagnostic data analyses
- Perform data forecasting
- Prepare and present data to meet business requirements
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 you have to skip the class due to some contingency, 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 real-world and industry-oriented 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: If you have any technical knowledge, it will be an added advantage for you. 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.