SNOWFLAKE Logo v2
8154  Reviews star_rate star_rate star_rate star_rate star_half

Snowflake SnowPro Advanced Administrator

This course prepares Snowflake administrators to take the SnowPro Advanced Administrator exam. They are equipped with the skills and knowledge required to manage and administer Snowflake accounts,...

Read More
Course Code INNO-SP-ADMIN
Duration 3 days
Available Formats Classroom

This course prepares Snowflake administrators to take the SnowPro Advanced Administrator exam. They are equipped with the skills and knowledge required to manage and administer Snowflake accounts, maintain security, optimize performance, and ensure high availability.

Skills Gained

Attendees will focus on hands-on management and coding of various domains, including security, governance, monitoring, and more.

They also learn to:

  • 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 Data Exchange and Snowflake
  • Marketplace Administer disaster recovery, backup, and data replication.

Who Can Benefit

The audience for this class is Snowflake Administrators/Snowflake, Data Cloud Administrators, Database Administrators, Cloud Infrastructure Administrators, Cloud Data Administrators.

Prerequisites

Attendees should have:

  • Completed the Snowflake Fundamentals training or have equivalent experience.
  • Ideally, achieved the SnowPro Core Certification.
  • Ideally, advanced Snowflake SQL knowledge.

Course Details

Outline

Snowflake Security, Role-Based Access Control (RBAC), and User Administration

  • Authentication
  • Network and Private Connectivity
  • Security Administration and Authorization
  • Access Control (RABC)
  • Security and Access Scenarios
  • Custom and user defined roles

Account Management and Data Governance

  • Organizations and accounts
  • Organization level security and access
  • Data Governance
  • Database, tables, views, and queries
  • Staging data
  • Database streams and tasks

Performance Monitoring and Tuning

  • Design, manage and maintenance
  • Monitoring performance (query performance, explain)
  • DML locking and concurrency
  • Data clustering and partitioning
  • Cost management

Data Sharing, Data Exchange, and Snowflake Marketplace

  • Data sharing
  • Data exchange
  • Snowflake Marketplace

Disaster Recovery, Backup, and Data Replication

  • Disaster recovery
  • Data replication
  • Backups
  • Retention period