Snowflake Database Administration

In this role-specific 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. This course consists of lectures, labs, and discussions.

img
request

Can’t find a batch you were looking for?

 

In this role-specific 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. This course consists of lectures, labs, and discussions.

 
Learning Objectives:

 

  • Identify the various aspects of compute 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
  • 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
  • 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
 

Course content

 

Snowflake Architecture and Overview
  • Snowflake Technical Overview
  • Overview of Three-Tiered Architecture
Compute Management
  • Scaling Virtual Warehouses Up & Out
  • Creating and Managing Virtual Warehouses 
Snowflake Objects & Commands
  • Built-in Design and Comparison to Traditional SQL Commands
  • DDL Commands to Work with Different Database Objects
  • Different Functions and Operators Available in Snowflake
  • Account, Session, & Object Parameters
Organizations
  • Managing and Monitoring Multiple Accounts across Lines of Business
  • Replication between Regions and Cloud Providers and Failover
Load Operations & Performance Management
  • Load Operation Performance
  • Data Unloading
DML & Transaction Model
  • Snowflake DML Commands
  • SQL Statements for Transactions in Snowflake
  • DML and Clustering Impact on Table Versioning
Back-up, Restore & Snapshot
  • Time Travel
  • Zero-copy cloning
  • Fail-Safe
  • Agile Development Use Cases
Storage Management 
  • Table Design Considerations
  • DML and Cloning Considerations
  • Storage Optimization
Performance Methodology & Management 
  • Query Profile Analysis
  • Query Best Practices
  • Caching
  • Troubleshooting Tools & Tuning Performance Metrics
  • Data Clustering
  • Search Optimization Service
  • Materialized Views
Role-based Access & Design
  • Overview of Data Governance
  • System Roles & Custom Roles
  • Role Hierarchy
  • Best Practices
  • Column-Level Data Security to Protect Sensitive Data
Account & Resource Monitoring
  • Creating Resource Monitors
  • Monitoring Compute, Storage and Credits
  • Database Object Types and Storage Considerations
  • Utility Stored Procedures and Tasks
Data Sharing
  • Data Sharing Overview
  • Secured View
  • Secured UDF

 

To see the full course content Download now

Course Prerequisites

 
  • A background in database administration or management is required

Who can attend

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

Number of Hours: 30hrs

Certification

SnowPro Advanced: Administrator 

Key features

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Materials
  • Preparing for Certification

Call now: +91-99003 49889 and know the exciting offers available for you!

We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.

Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.

All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.

No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

DASVM Technologies provides many suitable modes of training to the students like:

  • Classroom training
  • One to One training
  • Fast track training
  • Live Instructor LED Online training
  • Customized training

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.

Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.

Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.

We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.

DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com

like our courses