Snowflake Course Content
- What is Cloud
- Different Cloud Vendors
- Advantages of Cloud over On-Premise
- Database Vs Data Warehouse
- Snowflake Overview
- Architecture
- Quick start to the snowflake and accessing trial account
- How to use the Snowflake UI & ecosystem
- Features of snowflake
- Creating warehouse and Privilege
- Creating Resource Monitor
- Creating Database and Privilege
- Creating Schema and Privilege
- Creating different tables and Privilege
- Accessing different roles and using it
- Working with worksheets
- Understanding different types of accounts
- Snowflake Help, Marketplace
- File formats
- Internal and external storage
- Copy into usage
- Snowflake internal storage
- Web UI-Based Data loading
- Installation of Snow Cli
- Bulk loading from cloud storage
- PUT and COPY commands
- Creating AWS Account
- Creating AWS S3 buckets and storing the data
- Loading Data AWS in Snowflake using Batch
- Accessing Snow pipe
- PUT and COPY commands
- Continuous loading
- Variant Datatype
- File format options
- Creating stages
- Loading JSON and XML semi-structured data into SF tables
- Accessing JSON with select statement
- Accessing XML with select statement
- Creating Tasks
- Creating Streams
- SCD Type 1 And SCD Type 2
- Snowflake Secure Views and Materliazed Views
- Usage of sharing data
- Sharing data with different accounts
- Sharing data with non-SF accounts using reader accounts
- Importance of reader accounts
- Privileges in data sharing
- Connecting shared objects with BI tools
- Limitations with Data sharing
- Access Control Privileges for Cloned Objects
- Cloning and Snowflake Objects
- Introduction to Time Travel
- Querying Historical Data
- Enabling and Disabling Time Travel
- Data Retention Period
- Fail Safe
- Cloning Using Time
- Travel (Databases, Schemas, and Tables Only)
- Creating multi-users on large tables
- Performance techniques
- Result set cache
- Cluster Key Concept
- Column Masking Policy
- Row Access Policy
- Snowflake Connector and use cases Python
- Connection with Power BI
- BI connectors use cases
- Snowsight
- Snowflake SQL (DDL)
- String & Date Time Functions
- Operators in and between
- Aggregate Functions
- Joins
- Subquery
- Analytical Functions
- Advanced Concepts
- Finally project
- FAQ’s
- Interview Q & A
- Resume Preparation.