Course Overview
The one-day, high-intensity session will increase your working knowledge of the platform and broaden your Snowflake palette.. Here’s your chance to immerse yourself in features introduced to the Snowflake Cloud Data Platform in the past 12 months. This course consists of lectures, demos, hands-on labs, and discussions.
Prerequisites
- Familiarity with Snowflake architecture and concepts such as Warehouses, Stages, Users, and Roles
- Foundational knowledge and experience working with Snowflake
- Basic knowledge of SQL is assumed
Audience Profile
- Application Developers
- Business Intelligence Users
- Data Analysts
- Data Engineers
- Data Scientists
- Database Administrators
- Database Architects
- System Administrators
Learning Objectives
- Evaluate how the latest features augment, enhance, and accelerate existing Snowflake solutions
- Explain where these features can be leveraged in an end-to-end, governed solution
- Recognize and articulate Snowflake best practices for the new features
- Describe the critical values of the new features and how they can be applied in creating data applications, and building and managing a robust and efficient Data Cloud implementation
Content Outline
- Snowsight orientation and key features
- Query Acceleration Service
- Object Tagging
- Data Classification
- Conditional Masking
- Row Access Policies
- Object Dependencies
- Access History
- Directory tables
- Streams on Directory tables
- Scoped URLs
- Ingesting and querying geoJSON data
- GEOGRAPHY data type
- GEO functions
- Utilizing INFER_SCHEMA to automate table creation from a set of semi-structured source files
- Joining structured and unstructured data sets
- Leveraging JAVA UDFs to parse and extract PDF data
- Loading open-source JAR files to JAVA UDFs
- Serverless tasks
- Manual task execution
- Reviewing task graph execution and task errors
- Snowflake Scripting
- User-defined functions
- Loading open-source JAR files to JAVA UDFs
- Leveraging open-source Python libraries directly available in Snowflake via Anaconda in Python UDFs
- User-defined table functions
- Loading open-source JAR files to JAVA UDTFs
- Stored Procedures
- Snowpark libraries
- SQL API
- Streamlight
- Snowpark
- Data Science / ML with Snowflake overview
- Snowpark Python walkthrough
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.