<?php the_title_attribute(); ? data-src=
Admin bar avatar

Bodhi IT

 4.5 (5 Reviews)

Course Duration

40 hour

About SNOWFLAKE

SNOWFLAKE Analytics Cloud is a new tool in the Snowflake portfolio to meet the needs of data visualization in the cloud. It is delivered as an all-in-one, SaaS-based product. It covers the needs of data visualization, budget planning, and predictive analytics. Snowflake offers a complete solution when it comes to business intelligence. Accessible online in SaaS mode, Snowflake is becoming increasingly important in the Snowflake ecosystem. Eventually, it is destined to become the BI reference tool for the Snowflake Cloud suite. BODHI IT provides best Snowflake Online Training in Hyderabad and all over world.

Snowflake

Basics of Data
  • What is a Database?
  • What is a Data Warehouse?
  • Challenges with traditional Data Warehouses

Overview of Cloud
  • What is Cloud Computing?
  • Software as a Service (SAAS)
  • Platform as a Service (PAAS)
  • Infrastructure as a Service (IAAS)

Snowflake Overview
  •  Introduction to Snowflake
  • Advantages of Snowflake
  • Snowflake Architecture
    • Cloud Services Layer
      1. Metadata Manager
      2. Infrastructure Manager
      3. Optimizer Service
      4. Authentication and Security
    • Compute Layer
    • Storage Layer
  • Billing for Storage, Compute and Cloud Services Layers
  • Life cycle of a query
  • Ways to connect

Getting Started with Snowflake
  • Availability Zones
  •  Snowflake Regions
  • Snowflake Editions
  •  Register for free trial account in Snowflake
  •  Snowflake Web Interface (UI) Overview
  •  Loading SQL scripts to Snowflake
  • Introduction to Snowflake Sample Data
  • Practice Lab for creating Databases, Warehouses, etc.

SnowSQL
  • Introduction to SnowSQL
  •  Installation and setup of SnowSQL
  •  Practice Lab for running SQL Commands using SnowSQL
  • Running a SQL script using SnowSQL

Snowsight
  • Introduction to Snowsight.
  • Practice Lab for creating charts and dashboards in Snowsight.

Snowflake Caching
  • Metadata Cache.
  •  Query Result Cache.
  •  Data Cache.
  • Life cycle of a query in terms of caching.
  •  Practice Lab to work with all 3 types of caching.

Snowflake Structure
  • Snowflake Data Objects
  • Snowflake Data Types
  •  Practice Lab for working with all table and view types
  • Querying and Filtering Commands
  •  Collations
  • Subqueries
  •  Practice Lab for working with query fundamentals
  • Query Tags
  • Explain Plan
  • Query Profile
  • Types of Tables
    1. Permanent Table
    2. Temporary Table
    3. Transient Table
    4. External Table
  •  View Types
    1. Standard View
    2. Secure View
    3. Materialized View

Data Movement
  • Data Loading
    o What is a Stage?
    o Types of Stages
    o What is a File Format?
    o Data Loading commands
    o Data Loading recommendations
    o Bulk Loading Vs Continuous Loading
    o Snowpipe Introduction
    o Loading data through Load Data Wizard
    o Practice Lab for loading data from S3 to Snowflake
  •  Data Unloading
    o Data Unloading Tips
    o Data Unloading commands
    o Practice Lab for unloading data from Snowflake to Local File System

Tasks & Streams
  • Introduction to Streams
  •  Introduction to Tasks
  • Practice Lab for creating tasks

Snowflake Functions
  • Snowflake Defined Functions.
  • User-Defined Functions (UDF).
    o SQL UDF
    o JavaScript UDF
  • Practice Lab for working with various types of functions.
  • Stored Procedures .
  • User-Defined Functions Vs Stored Procedures.
  •  Practice Lab for creating Stored Procedures and UDFs.

Security Management
  • Security Protocols
  •  Access
  • Authentication
  •  Authorization
  •  Data Protection
  •  Infrastructure
  •  Demo on MFA setup, Network Policy creation, etc.

Access Control and User Management
  • Users and Roles Overview
  • System Roles
  •  Custom Roles
  •  Ownership Vs Grants
  •  Practice Lab for creating and configuring Roles

Semi-Structured Data
  • Introduction to Semi-Structured Data
  • Supported File Formats
  •  Flattening Data
  •  Querying Semi-Structured Data
  •  Practice Lab for working with Semi-Structured Data

Continuous Data Protection
  • Cloning
  •  Time Travel
  •  Failsafe
  •  Database Replication
  •  Practice Lab for Cloning and Time Travel

Data Sharing
  • Data Share Offerings
    o Secure Direct Data Share
    o Snowflake Data Exchange
    o Snowflake Data Marketplace
  • What is a Share?
  • Data Providers
  • Data Consumers
  •  Reader Accounts

Performance and Concurrency
  • SQL Performance Tips
  •  Resolving Pruning Issues
  •  Clustering Keys
  •  Virtual Warehouse Scaling
    o Scaling Up
    o Scaling Out
  • Practice Lab on Warehouses Scaling

Account and Resource Management
  • Controlling Costs
  • Resource Monitors
  •  INFORMATION_SCHEMA
  •  SNOWFLAKE Database
  •  ACCOUNT_USAGE
  •  Demo on setting up a Resource Monitor
  •  Practice Lab on monitoring warehouse usage, billing, querying INFORMATION_SCHEMA and
    ACCOUNT_USAGE

Preview Features
  • Preview Features overview
  •  Releases

Snowflake – Tableau Integration
  • Tableau Introduction
  •  Establishing connection between Snowflake and Tableau
  •  Practice Lab for creating reports in Tableau on data present in Snowflake

Snowflake – Python Integration
  • Python Introduction.
  •  Creating Google Colab account .
  • Establishing connection between Snowflake and Python.
  •  Practice Lab for executing Snowflake queries through Python.

SnowPro Core Certification
  • Certification Exam overview
  •  Resources and Reference links
  •  Links for practice quizzes
  • Exam tips

Snowflake Interview Questions
  • 40 Theory-based Questions
  •  20 Scenario-based Questions

    Snowflake

    • What is a Database?
    • What is a Data Warehouse?
    • Challenges with traditional Data Warehouses

    • What is Cloud Computing?
    • Software as a Service (SAAS)
    • Platform as a Service (PAAS)
    • Infrastructure as a Service (IAAS)

    •  Introduction to Snowflake
    • Advantages of Snowflake
    • Snowflake Architecture
      • Cloud Services Layer
        1. Metadata Manager
        2. Infrastructure Manager
        3. Optimizer Service
        4. Authentication and Security
      • Compute Layer
      • Storage Layer
    • Billing for Storage, Compute and Cloud Services Layers
    • Life cycle of a query
    • Ways to connect

    • Availability Zones
    •  Snowflake Regions
    • Snowflake Editions
    •  Register for free trial account in Snowflake
    •  Snowflake Web Interface (UI) Overview
    •  Loading SQL scripts to Snowflake
    • Introduction to Snowflake Sample Data
    • Practice Lab for creating Databases, Warehouses, etc.

    • Introduction to SnowSQL
    •  Installation and setup of SnowSQL
    •  Practice Lab for running SQL Commands using SnowSQL
    • Running a SQL script using SnowSQL

    • Introduction to Snowsight.
    • Practice Lab for creating charts and dashboards in Snowsight.

    • Metadata Cache.
    •  Query Result Cache.
    •  Data Cache.
    • Life cycle of a query in terms of caching.
    •  Practice Lab to work with all 3 types of caching.

    • Snowflake Data Objects
    • Snowflake Data Types
    •  Practice Lab for working with all table and view types
    • Querying and Filtering Commands
    •  Collations
    • Subqueries
    •  Practice Lab for working with query fundamentals
    • Query Tags
    • Explain Plan
    • Query Profile
    • Types of Tables
      1. Permanent Table
      2. Temporary Table
      3. Transient Table
      4. External Table
    •  View Types
      1. Standard View
      2. Secure View
      3. Materialized View

    • Data Loading
      o What is a Stage?
      o Types of Stages
      o What is a File Format?
      o Data Loading commands
      o Data Loading recommendations
      o Bulk Loading Vs Continuous Loading
      o Snowpipe Introduction
      o Loading data through Load Data Wizard
      o Practice Lab for loading data from S3 to Snowflake
    •  Data Unloading
      o Data Unloading Tips
      o Data Unloading commands
      o Practice Lab for unloading data from Snowflake to Local File System

    • Introduction to Streams
    •  Introduction to Tasks
    • Practice Lab for creating tasks

    • Snowflake Defined Functions.
    • User-Defined Functions (UDF).
      o SQL UDF
      o JavaScript UDF
    • Practice Lab for working with various types of functions.
    • Stored Procedures .
    • User-Defined Functions Vs Stored Procedures.
    •  Practice Lab for creating Stored Procedures and UDFs.

    • Security Protocols
    •  Access
    • Authentication
    •  Authorization
    •  Data Protection
    •  Infrastructure
    •  Demo on MFA setup, Network Policy creation, etc.

    • Users and Roles Overview
    • System Roles
    •  Custom Roles
    •  Ownership Vs Grants
    •  Practice Lab for creating and configuring Roles

    • Introduction to Semi-Structured Data
    • Supported File Formats
    •  Flattening Data
    •  Querying Semi-Structured Data
    •  Practice Lab for working with Semi-Structured Data

    • Cloning
    •  Time Travel
    •  Failsafe
    •  Database Replication
    •  Practice Lab for Cloning and Time Travel

    • Data Share Offerings
      o Secure Direct Data Share
      o Snowflake Data Exchange
      o Snowflake Data Marketplace
    • What is a Share?
    • Data Providers
    • Data Consumers
    •  Reader Accounts

    • SQL Performance Tips
    •  Resolving Pruning Issues
    •  Clustering Keys
    •  Virtual Warehouse Scaling
      o Scaling Up
      o Scaling Out
    • Practice Lab on Warehouses Scaling

    • Controlling Costs
    • Resource Monitors
    •  INFORMATION_SCHEMA
    •  SNOWFLAKE Database
    •  ACCOUNT_USAGE
    •  Demo on setting up a Resource Monitor
    •  Practice Lab on monitoring warehouse usage, billing, querying INFORMATION_SCHEMA and
      ACCOUNT_USAGE

    • Preview Features overview
    •  Releases

    • Tableau Introduction
    •  Establishing connection between Snowflake and Tableau
    •  Practice Lab for creating reports in Tableau on data present in Snowflake

    • Python Introduction.
    •  Creating Google Colab account .
    • Establishing connection between Snowflake and Python.
    •  Practice Lab for executing Snowflake queries through Python.

    • Certification Exam overview
    •  Resources and Reference links
    •  Links for practice quizzes
    • Exam tips

    • 40 Theory-based Questions
    •  20 Scenario-based Questions

0.0
0 total
5
0
4
0
3
0
2
0
1
0

Course Features

  • Students Limited
  • Certificate Yes
  • Skill Advance
  • Category Instrumentation

Request for Free Demo

    Training Features

    Live Online Training

    Live online training session will be given by our trainers and are available to answer your queries.

    Time flexibility

    We conduct classes in most of the day. We are flexible to train you according to your schedule.

    Real time scenario

    All of our trainers are come from different industry they are experts in explaining scenarios that are happening in real time.

    Best IT Leading Software Training Institute

    Talk with Bodh IT