The Snowflake Administrator course equips professionals with essential skills to manage and optimize the Snowflake Data Cloud. Covering architecture, administration, and advanced features, it’s ideal for beginners and experienced users aiming to master Snowflake for efficient data management and scalability.

Module-1: JOB ROLES 

• Introduction to Databases, Warehouse
• Snowflake: Advantages, Use
• Versions and Editions of Snowflake
• Snowflake admin role and responsibilities.
• Accessing Snowflake UI
• Accessing Snowflake through SNOWSQL
• Authentication Modes and Logins
• Human user & Non Human user

Module-2: Introduction to Snowflake UI

• Connecting to Snowflake UI
• Shared databases in Snowflake

Module-3: Snowflake Architecture

• Key Concepts & Architecture
• Data Platform as a Self-Managed Service
• Snowflake architecture
  • Cloud Services
  • Query Processing
  • Database Storage

Module-4: Connecting to Snowflake

• A web-based user interface
• Command line clients (e.g. SnowSQL)
• ODBC and JDBC drivers
• Native connectors (e.g. Python, Spark)
• Third-party connectors

Module-5: Role based access model (RBAC)

• Overview of Access Control
• Access Control Framework
• What is role based access model in Snowflake
• Securable Objects
• Roles
• Types of Roles
• Active Roles
• System-Defined Roles
• Custom Roles
• Privileges
• Role Hierarchy and Privilege Inheritance
• Database Roles and Role Hierarchies
• Enforcement Model: The Primary Role and Secondary Roles

Module-6: Snowflake database and schema, stage, integration

• How to create database
• How to create schema
• What is managed schema
• How to create table
• How to create views
• How to create stage
• How to create Integration.

Module-7: Queries Snowflake

• DQL
• DDL
• DML
• DCL
• TCL

Module-8: View, Procedures, UDF Basics

• Views: Types, Usage in Real-time
• System Predefined Views available in Snowflake
• Stored procedure
• User define function

Module-9: Tasks and streams in Snowflake

• Introduction to Tasks
• Compute Resources
• Serverless Tasks
• User-managed Tasks
• Task Scheduling
• DAG of Tasks
• Manually Executing Tasks
• Viewing the Task History for Your Account
• Task DDL
• Task Functions
• Resuming or Suspending Tasks
• Streams
• Types of Streams
• Streams on Views

Module-10: Cloning in snowflake

• Cloning Considerations
• Access Control Privileges for Cloned Objects
• Cloning and Snowflake Objects
• Cloning and Object Parameters
• Cloning and Default Sequences
• Cloning and Foreign Key Constraints
• Cloning and Clustering Keys
• Cloning and Stages
• Cloning and Pipes
• Cloning and Streams
• Cloning and Tasks
• Cloning and Governance Objects
• Impact of DDL on Cloning
• Impact of DML and Data Retention on Cloning
• Database cloning
• Schema cloning
• Table cloning

Module-11: Time Travel in Snowflake

• Understanding & Using Time Travel
• Introduction to Time Travel
• Time Travel SQL Extensions
• Data Retention Period
• Enabling and Disabling Time Travel
• Specifying the Data Retention Period for an Object
• Changing the Data Retention Period for an Object
• Querying Historical Data
• Cloning Historical Objects
• Dropping and Restoring Objects
• Listing Dropped Objects
• Restoring Objects

Module-12: Network policy

• Overview
• CIDR Notation
• Examples of Allowed / Blocked Address Lists
• Bypassing a Network Policy
• Creating Network Policies
• Viewing Network Policies
• Activating a Network Policy for Your Account
• Activating Network Policies for Individual Users
• Modifying Network Policies
• Identifying a Network Policy Activated at the Account or User Level

Module-14: BYOK

• Overview
• Data Encryption with Customer-Managed Keys
• BENEFITS
• IMPLEMENTATION

Module-15: Database replication

• Introduction to Database Replication Across Multiple Accounts
• What is a Primary Database?
• Overview of Database Replication
• Database Replication to Accounts on Lower Editions
• Current Limitations of Replication

Module-16: Data related

• Sequences
• File format/data type
• Integration objects
• Data sharing
• Fail safe
• Batch loading of data

Module-17: Failover group

• Introduction to Replication and Failover
• Region Support for Replication and Failover/Failback
• Replication Groups and Failover Groups
• Replication Feature / Edition Matrix
• Replicated Objects
• Database Replication
• Replicated Database Objects
• Database Replication and Encryption
• Integration Replication
• Network Policy Replication
• Parameter Replication
• Resource Monitor Replication
• Role Replication
• Share Replication
• User Replication
• Warehouse Replication
• Replication of Roles and Grants
• Replication Schedule
• Suspend and Resume Scheduled Replication
• Replication to Accounts on Lower EditionS
• Current Limitations of Replication