Snowflake Platform

Introduction

Snowflake is an entirely managed SaaS (Software as a Service) that furnishes a unified platform for data warehousing, data lakes, data engineering, data science, development of data applications, and secure distribution and utilization of real-time or shared data. Rapidly growing technology adopted by many MNCs, huge job market potential
Salary for beginners ranges medium to high. (In demand skill)

Introduction to Snowflake

Introduction to Databases
Introduction to Cloud Platforms
Platform As A Service (PaaS)
Software As A Service (SaaS)
Snowflake SaaS Cloud Platform
Traditional RDBMS vs. Snowflake Platform
Snowflake Versions, Architecture, and Pricing
Working with Snowflake Components
- Warehouses (Create/Alter/Drop)
- Schema
- Roles
- Worksheets
- Accounts
- UI and Navigation
- Quick Start: Setting Up and Accessing a Trial Account

Snowflake SQL

Snowflake Databases and Data Storage
Need for Snowflake Warehouse, Compute
Database Objects and Hierarchy
Snowflake Worksheet Parameters
Database Creation with Snowflake UI
Retention Time, DB List & Connections
Permanent and Transient Databases
Snowflake Tables and Their Usage
- Permanent, Transient & Temp Tables
- Creating Tables with SnowSight
- Describe Options, Data Inserts
- CREATE TABLE AS SELECT
- Cloning Tables, Case Sensitivity Options
- Collation, ALTER, DROP & UNDROP
Snowflake Constraints and Data Validations
- NULL and NOT NULL Properties
- Unique, Primary and Foreign Keys
- Working with Named Constraints
- Single Column, Multi Column Constraints
- Inline and Out Of Line Constraints
- Table Constraints Types, Real-time Use
- Constraint Properties: ENFORCED
- DEFERRED, IMMEDIATE Options
Data Types in Snowflake
- Numeric, String, and Binary Data Types
- Boolean Data Types and Usage
- Date and Time Data Types
- Semi-Structured Data Types
- Geospatial & Variant Data Types
Time Travel Feature in Snowflake
- DML Operations and Silent Audits
- Continuous Data Protection Life Cycle
- Invoking Time Travel Feature in Snowflake
- Timestamp, Offset & Query ID Options
- Time Travel using Offset Feature
- Time Travel using Query ID Feature
- Data Recovery using TIMESTAMP
- Using OFFSET Options in Real-world
- Fail Safe and UNDROP Operations
Transient and Permanent Tables in Real-time Usage
- Restrictions with Permanent Tables
- Identical Names and Naming Conflicts
Snowflake Schemas
- Creation and Real-time Usage
- Permanent and Transient Schemas
- Managed Schemas in Real-time Usage
- Verifying and Cloning Snowflake Schemas
- Invoking Schemas & Cloning Operations
- ALTER SCHEMA.. IF EXISTS Options
- Creating and Working with Managed Schema
Snowflake Sessions (Workspaces)
- Session Context: Role and Warehouse
- Session Context: Database & Schema
- Working with Fully Qualified Names
CTAS: Create Table As Select
Data Loading with GUI and SQL Scripts
Using Query and History Tab in GUI