Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

Snowflake Persona Database Administrator

( Duration: 3 Days )

This Snowflake Persona Database Administrator training course provides an in-depth look at database administrator duties and responsibilities on the Snowflake platform. This course covers data loading performance, designing a role hierarchy, agile development, and advanced performance tuning.

  • Experience in database administration or management

The Snowflake Persona Database Administrator workshop is ideal for:

  • System Administrators
  • Data Engineers
  • Database Architects
  • Database Administrators

COURSE AGENDA

Day 1

  • Identify the various aspects of computing and storage management
  • Illustrate administrative tasks within the detailed architecture of Snowflake
  • Review Snowflake best practices & 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

Day 2

  • Manage multiple accounts across the Organization
  • Describe the DDL operations that work with fundamental database objects
  • Discuss transaction and concurrency models and DML considerations
  • Employ recovery methods and agile development with Time Travel & Cloning
  • Implement advanced techniques for Snowflake performance-tuning methodologies

Day 3

  • Design and develop secure access to objects in Snowflake with Role-Based Access Control (RBAC)
  • Recommend the Snowflake best practices for management, monitoring, and optimization
  • Use data replication for data sharing across accounts and for failover scenarios
  • Share data securely both within and without your organization

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top