Skip to Scheduled Dates
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.
Who Should Attend
- Database Administrators
- System Administrators
- Database Architects
- Data Engineers
Course Objectives
- 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.
- 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 management, monitoring, and optimization best practices.
Course Outline
1 - Snowflake Administration
2 - Clients, Connectors, and Ecosystems
- Clients and Interfaces
- SnowSQL
3 - Managing Security
- Overview
- Access
- Authentication
- Key-Pair Authentication
- What is an Integration?
- Security Integrations
- Security Best Practices
- Trust Center
4 - Managing Roles
- Users and Roles
- Types of Roles
- Using and Showing Grants
- Ownership
5 - Managing Users
- User Management Overview
- Password Policies
- Managing Session Policies
6 - Snowflake Environment
- Account Structure
- Set Account Parameters
- Virtual Warehouse Scaling
7 - Database Objects and Commands
- Objects
- Tables
- Constraints
- Views
- Using the Result_Scan Function
- System Functions
- External Tables
- Dynamic Tables
- Dynamic Table Advantages
- Monitoring Dynamic Tables
8 - Managing Data Ingestion
- Data Loading Overview
- Bulk Loading
- Error Handling
- Fixing Load Failures
- Loading Data Using the Web Interface
- Continuous Loading with Snowpipe
- Unloading Data
- Storage Integrations
- Notification Integrations
9 - Work with Semi-structured Data
- Loading Semi-structured Data
- Querying Semi-structured Data
10 - Working with Unstructured Data
11 - Schema Inference and Evolution
- Schema Inference
- Schema Evolution
12 - Tasks
- Tasks Overview
- Creating Tasks
- Managing Tasks
13 – Streams
14 - Managing Query Performance
- Get_Query_Operator_Status
- Writing E icient Queries
- Join Elimination
15 - Data Manipulation Language (DML) and Transaction Concurrency
- Transaction Concurrency Goals
- System’s Point of View
- Monitoring and Management Functions
16 - Managing Data Governance
- Data Governance and Snowflake
- Classification and Tagging
- Row Access Policies
- Masking Policies
- Context Functions
- Auditing Access History
- Access History and Column Lineage
- Snowsight Data Governance Dashboard