Course Overview
This three-day, the role-specific course provides an in-depth look at database administrator duties and responsibilities on the Snowflake Cloud Data Platform. This course covers data loading performance, role hierarchy design, agile development, and advanced performance tuning. The system consists of lectures, labs, demonstrations, and discussions.
Prerequisites
A background in database administration or management is required.
Audience Profile
- Database Administrators
- System Administrators
- Database Architects
- Data Engineers
Learning Objectives:
- Manage and administer Snowflake accounts
- Manage and administer Snowflake data security and governance
- Manage and maintain database objects
- Manage and maintain virtual warehouses
- Perform database monitoring and tuning
- Perform data sharing and use the Snowflake Data Exchange and Data Marketplace
- Administer disaster recovery, backup, and data replication
Content Outline
- Snowflake Cloud Data Platform
- Functional Architecture and Workloads
- Global Structure: Cloud Platforms and Regions
- Cloud Services Layer
- Compute Layer
- Data Storage Layer
- Scaling Across, Up, and Out
- Account Structure
- Set Account Parameters
- Data Storage Layer
- What is Micro-partitioning?
- Data Clustering
- Objects
- Tables
- Constraints
- Views
- Data Types
- Semi-structured Data
- Querying Semi-structured data
- Clients and Interfaces
- SnowSQL
- Query Profile Overview
- Explain Plan
- Metadata Cache
- Query Result Cache
- Data Cache
- Access
- Authentication
- What is an Integration?
- Security Integrations
- Authorization and Access Control
- Privileges and Roles
- Role Management
- User Management
- Data Governance and Snowflake
- Identify and Classify
- Protect
- Audit and Analyze
- Streaming and Batch Loading Overview
- Bulk Loading
- Storage Integration
- Continuous Loading with Snowpipe
- Notification Integrations
- Stored Procedures
- Task
- Snowflake Scripting Overview
- Snowflake Scripting Constructs
- Data Access Options
- Direct Data Sharing
- Direct Data Sharing Workflow
- Transaction Concurrency Goals
- System’s Point of View
- Monitoring and Management Functions
- Time Travel and Point-in-time Restore
- How Does Time Travel Work?
- Fail-safe
- Zero-copy Cloning
- Replication Workflow
- Failover Workflow
Writing Efficient Queries
- Micro-partitions and Clustering
- Automatic Clustering Service
- Materialized Views
- Search Optimization Service
- Snowflake Organizations
- Administrative Operations with Organizations
- ORGADMIN Role
- Creating Accounts
- Querying Organization Account Usage
- Account Management Commands
- Monitoring Compute
- Monitoring Serverless Compute
- Monitoring Storage
- Monitoring Data Transfer
- Resource Monitors
Certification
- Manage and administer Snowflake accounts
- Manage and administer Snowflake data security and governance
- Manage and maintain database objects
- Manage and maintain virtual warehouses
- Perform database monitoring and tuning
- Perform data sharing and use the Snowflake Data Exchange and Data Marketplace
- Administer disaster recovery, backup, and data replication
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.