Snowflake data warehouse & cloud analytics
₹49,999.00
Product Description
Snowflake data warehouse & cloud analytics Course Curriculum
- Introduction to Cloud
- What is Cloud
- Different Cloud Vendors
- Advantages of Cloud over On-Premise
- 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
- Introduction to Snowflake
- Key Concepts & Architecture
- Cloud Platforms
- Snowflake Editions
- Overview of Key Features
- Overview of the Data Lifecycle
- Continuous Data Protection
- Connecting to Snowflake
- Overview of the Ecosystem
- Snowflake Partner Connect
- SnowSQL (CLI Client) – Installation, Configuring and Usage
- Lab – Snowsql Lab & Exercises
- 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
- 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
- Snowflake Continuous Data Pipelines
- Streams, Tasks & Snowpipe
- Lab – Streams & Tasks Lab & Exercises
- 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
- Managing Your Snowflake Account
- System Usage & Billing
- Understanding Snowflake Credit and Storage Usage
- Understanding Snowflake Data Transfer Billing
- Monitoring Credit and Storage Usage
- Resource Monitors
- Parameter Management
- User Management
- Lab – Streams & Tasks Lab & Exercises
- 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
- Performance Tuning
- Query Tuning
- Clustering
- Materialized Views
- Performance Considerations
- Real Time Scenarios, Real Time Interview Questions & FAQs
