Snowflake Training In Hyderabad | Snowflake Online Training Hyderabad

Jacinta InfoTech

Snowflake Course Content & DEMO VIDEO

Snowflake Course Content

Table of Contents:

1.Introduction to Cloud

  1. Data Warehousing Concepts
  2. Introduction to Snowflake
  3. Connecting to Snowflake
  4. Loading / Unloading Data into/from Snowflake
  5. Using Snowflake
  6. Snowflake Continuous Data Pipelines
  7. Sharing Data in Snowflake
  8. Managing Your Snowflake Account
  9. Understanding Snowflake Data Transfer Billing
  10. Managing Security in Snowflake
  11. Performance Tuning
  12. Real Time Scenarios, Real Time Interview Questions & FAQs
  1. Introduction to Cloud
  • What is Cloud
  • Different Cloud Vendors
  • Advantages of Cloud over On-Premise
  1. Data Warehousing Concepts
  • What is a Data Warehouse
  • Data Base Vs Data Warehouse
  • Data Ware House Architecture
  • Why do we need Data Warehouse
  • OLTP Vs OLAP
  • What is ETL
  1. Introduction to Snowflake
  • Key Concepts & Architecture
  • Cloud Platforms
  • Snowflake Editions
  • Overview of Key Features
  • Overview of the Data Lifecycle
  • Continuous Data Protection
  1. Connecting to Snowflake
  • Overview of the Ecosystem
  • Snowflake Partner Connect
  • SnowSQL (CLI Client) – Installation, Configuring and Usage
  • Lab – Snowsql Lab & Exercises

 5.Loading / Unloading Data into/from Snowflake

  • Overview of Data Loading/Unloading
  • Data Loading/Unloading Considerations
  • Preparing to Load/Unload Data
  • Bulk Loading/Unloading from a Local File System
  • Bulk Loading/Unloading from Amazon S3
  • Bulk Loading /Unloading from Microsoft Azure
  • 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
  • Troubleshooting Bulk Data Loads
  • Lab – Data Loading / Unloading Lab & Exercises
  1. Using Snowflake
  • Web Interface
  • Virtual Warehouses
  • Databases, Tables & Views
  • Queries
  • Date & Time Data
  • Semi-structured Data
  • Binary Data
  • Snowflake Time Travel & Fail-safe
  • Lab & Exercises
  1. Snowflake Continuous Data Pipelines
  • Streams, Tasks & Snowpipe
  • Lab – Streams & Tasks Lab & Exercises
  1. Sharing Data in Snowflake
  • Introduction to Data Sharing
  • Data Providers
  • Data Consumers
  • Working with Shares
  • Using Secure Objects to Control Data Access
  • Configuring a Reader Account
  • Managing Reader Accounts
  • Lab – Streams & Tasks Lab & Exercises
  1. Managing Your Snowflake Account
  • System Usage & Billing
  • Understanding Snowflake Credit and Storage Usage
  1. Understanding Snowflake Data Transfer Billing
  • Monitoring Credit and Storage Usage
  • Resource Monitors
  • Parameter Management
  • User Management
  • Lab – Streams & Tasks Lab & Exercises

 11.Managing Security in Snowflake

  • Summary of Security Features
  • Network Policies
  • AWS Private Link & Snowflake
  • Multi-Factor Authentication (MFA)
  • Federated Authentication & SSO
  • Access Control in Snowflake (DAC & RBAC)
  • Data Encryption
  • Lab – Streams & Tasks Lab & Exercises

12.Performance Tuning

  • Query Tuning

  • Clustering
  • Materialized Views
  • Performance Considerations
  1. Real Time Scenarios, Real Time Interview Questions & FAQs