Introduction to Cloud Data Warehousing
  • Cloud Data warehouses introduction
  • Advantages of Cloud data warehousing.
  • Describe about various popular cloud data warehouses
    • Redshift (AWS)
    • Snowflake
    • Azure synapse (Microsoft)
    • Big Query (Google)
Snowflake General
  • Introduction
  • Pricing
  • Supported Regions
  • Snowflake Editions
    • Standard Edition
    • Enterprise Edition
    • Business Critical Edition
    • Virtual Private Snowflake (VPS)
  • Supported Cloud Platforms
    • Amazon Web Services (AWS)
    • Google Cloud Platform (GCP)
    • Microsoft Azure (Azure)
  • Connected to Snowflake
    • How to create snowflake account
    • Different features in Snowflake.
    • Web interface overview and how to use
    • SnowSql tool introduction and Usage.
    Snowflake Architecture
    • Overview
    • Architecture layers – Storage, Query Processing and Cloud Services
    Loading / Unloading Data Into/From Snowflake
    • Overview of Data Loading
    • Summary of Data Loading Features
    • Data Loading Considerations
    • Preparing to Load Data
    • Bulk Loading Using COPY
    • Loading Continuously Using Snowpipe
    • Loading Using the Web Interface (Limited)
    • Querying Data in Staged Files
    • Querying Metadata for Staged Files
    • Transforming Data During a Load
    Queries — Key concepts and tasks for executing queries in Snowflake
    • Working with Subqueries
    • Querying Hierarchical Data
    • Working with CTEs (Common Table Expressions)
    • Querying Semi-structured Data
    • Using Window Functions
    • Using Sequences
    • Using Persisted Query Results
    • Estimating Number of Distinct Values
    • Estimating Similarity of Two or More Sets
    • Estimating Frequent Values
    • Estimating Percentile Values
    • Analyzing Queries Using Query Profile
    • Canceling Statements
    Semi-structured Data — Key concepts and tasks for working with JSON and other types
    • Introduction to Semi-structured Data
    • Semi-structured Data Considerations
    • Tutorial: JSON Basics
    Virtual warehouses
    • Overview of Warehouses
    • Multi-cluster Warehouses
    • Warehouse Considerations
    • Working with Warehouses
    • Monitoring Warehouse Load
    Databases, Tables & Views
    • Understanding Snowflake Table Structures
    • Working with Temporary and Transient Tables
    • Working with External Tables
    • Overview of Views
    • Working with Secure Views
    • Working with Materialized Views
    • Table Design Considerations
    • Cloning Considerations
    • Data Storage Considerations
    Timetravel and Fail Safe
    • Understanding & Using Time Travel
    • Understanding & Viewing Fail-safe
    • Storage Costs for Time Travel and Fail-safe
    Sharing Data In Snowflake
    • Introduction to Secure Data Sharing
    • Overview of the Product Offerings for Secure Data Sharing
    • Granting Data Exchange Administrator Privileges to Other Roles
    • Secure Direct Data Share
    • Data Providers
    • Working with Shares
    • Sharing Data from Multiple Databases
    • Sharing Data Securely Across Regions and Cloud Platforms
    • Using Secure Objects to Control Data Access
    • Managing Reader Accounts
    • Configuring a Reader Account
    • Enabling Sharing from a Business Critical Account to a non-Business Critical Account
    Managing Your Snowflake Account
    • System Defined roles
      • ACCONTADMIN
      • SECURITYADMIN
      • SYSADMIN
      • PUBLIC
    • Custom Roles
    Data security within Snowflake. Access Control within Snowflake. Use Cases
    • How to extract data from Snowflake to Power BI.
    • How to use ETL tools to pull data from sources to Snowflake.
Best Snowflake Training in Hyderabad

Preview this course

  • Duration 35 Hours
  • Students 21
  • Days 40 Days
  • Resume Preparation Yes
  • Interview Guidance Yes