Trending Courses
Vendors
Agile & Scrum
POPULAR COURSES
Read More In Blog
#BeCyberSmart with Microsoft: Cybersecurity Awareness Month 2024
AI & Machine Learning
Analytics & Data Management
Big Data
Business Application
Cloud Computing
Cyber Security
Database Admin & Dev
Data Engineering & Science
DevOps
Digital Transformation
IT Governance
IT Infrastructure
IT Service Management
Networking
Programming & Development
Project Management
Virtualization
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.
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.
Database Administrators System Administrators Database Architects Data Engineers
Coming Soon...
Module 1: Snowflake Administration Clients, Connectors, and Ecosystems Clients and Interfaces Managing Security Overview Access Authentication Programmatic Access Token (PAT) Key-Pair Authentication What is an Integration? Security Integrations Security Best Practices Trust Center Managing Roles Users and Roles Types of Roles Using and Showing Grants Ownership Managing Users User Management Overview Password Policies Managing Session Policies Snowflake Environment Account Structure Set Account Parameters Virtual Warehouse Scaling 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 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 Work with Semi-structured Data Loading Semi-structured Data Querying Semi-structured Data Module 2: Work with Unstructured Data Schema Inference and Evolution Schema Inference Schema Evolution Tasks Tasks Overview Creating Tasks Managing Tasks Module 3: Streams Managing Query Performance Get_Query_Operator_Stats Writing Efficient Queries Join Elimination Data Manipulation Language (DML) and Transaction Concurrency Transaction Concurrency Goals System’s Point of View Monitoring and Management Functions 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
Module 1: Snowflake Administration
Clients, Connectors, and Ecosystems
Managing Security
Managing Roles
Managing Users
Snowflake Environment
Database Objects and Commands
Managing Data Ingestion
Work with Semi-structured Data
Module 2: Work with Unstructured Data
Schema Inference and Evolution
Tasks
Module 3: Streams
Managing Query Performance
Data Manipulation Language (DML) and Transaction Concurrency
Managing Data Governance
Level-up by partnering with Trainocate. Get in touch today.
By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.
You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.
Your Cart Is Empty!