Administering Snowflake Training
This three-day, role-specific course provides an in-depth exploration of database administrator duties and responsibilities in the Snowflake Data Cloud. This course covers data loading performance, security, role hierarchy design, and performance tuning. The course consists of lectures, labs, demonstrations, and discussions.
In this course, you will:
- Identify the various aspects of Snowflake compute and storage management.
- Define the administrative tasks performed in support of the Snowflake Data Cloud.
- Apply Snowflake’s recommended best practices and considerations for managing load operations and performance.
- Describe data governance in Snowflake, including column-level data security using secure views and dynamic data masking features.
- Explain the data definition language (DDL) operations that work with fundamental database objects.
- Apply strategies for Snowflake performance-tuning.
- Design and develop secure access to objects in Snowflake with Role-based Access Control (RBAC).
- Utilize Snowflake’s recommended best practices for management, monitoring, and optimization.
This course is intended for:
- Database Administrators
- System Administrator
- Database Architects
- Data Engineers
We recommend that attendees of this course have:
- A background in database administration or management is required.
- Completion of “Snowflake Foundations” one-day course or equivalent Snowflake knowledge.
Module 1: Clients, Connectors, and Ecosystems
- Clients and Interfaces
- SnowSQL
Module 2: Managing Security
- Access
- Authentication
- Key-Pair Authentication
- What is an Integration?
- Security Integrations
- Authorization and Access Control
Module 3: Managing Roles
- Users and Roles
- Types of Roles
- Using and Showing Grants
- Ownership
Module 4: Managing Users
- User Management Overview
- Password Policies
- Managing Session Policies
Module 5: Snowflake Environment
- Account Structure
- Set Account Parameters
- Virtual Warehouse Scaling
Module 6: Database Objects and Commands
- Objects
- Tables
- Constraints
- Views
- Semi-structured Data
- Using the Result_Scan Function
- System Functions
- External Tables
Module 7: Managing Data Ingestion
- Data Loading Overview
- Bulk Loading
- Error Handling
- Fixing Load Failures
- Loading Data Using the Web Interface
- Continuous Loading with Snowpipe
- Storage Integrations
- Notification Integrations
Module 8: Working with Semi-structured Data
- Loading Semi-structured Data
- Querying Semi-structured Data
Module 9: Schema Inference and Evolution
- Schema Inference
- Schema Evolution
Module 10: Tasks
- Task Overview
- Creating Tasks
- Managing Tasks
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 11, 2024 | ₹0 | |
| Virtual | 3 days | All Day | June 25, 2024 | ₹0 | |
| Virtual | 3 days | All Day | July 9, 2024 | ₹0 | |
| Virtual | 3 days | All Day | July 23, 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)
