Course Overview
This three-day, role-specific course provides an in-depth exploration of database administrator duties and responsibilities in the Snowflake AI Data Cloud. This course covers data loading performance, security, role hierarchy design, and performance tuning. The course consists of lectures, labs, demonstrations, and discussions.
What are the skills covered
- Identify the various aspects of Snowflake compute and storage management.
- Define the administrative tasks performed in support of the Snowflake AI Data Cloud.
- Apply Snowflake’s recommended best practices and considerations for managing load operations and performance.
- Described at a 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-
- Design and develop secure access to objects in Snowflake with Role-based Access Control (RBAC).
- Utilize Snowflake’s recommended management, monitoring, and optimization best practices.
Who should attend this course
- Database Administrators
- System Administrators
- Database Architects
- Data Engineers
Course Curriculum
Course Modules
Exam & Certification
SnowPro® Advanced: Administrator Certification ADA-C02
SNOWPRO ADVANCED: ADMINISTRATOR OVERVIEW
This certification will test the ability to:
- Manage and administer Snowflake accounts, data security, and governance
- Manage and maintain database objects and virtual warehouses
- Perform database monitoring, tuning, and optimization
- Perform data sharing and use the Snowflake Marketplace
- Implement disaster recovery, perform backups, and replicate data
