Snowflake Training
- Home
- Courses
- Snowflake Training
Snowflake Training Course Curriculum
- Snowflake Overview
- Architecture
- How to use the Snowflake UI & Ecosystem
- What is Cloud
- Different Cloud Vendors
- Advantages of Cloud over On-Premise
- What is a Data Warehouse and Why do we need Data Warehouse?
- Database Vs Data Warehouse
- Data Warehouse Architecture
- OLTP Vs OLAP
- What is ETL
- How different from traditional DB
- Quick start to the snowflake and accessing the trial account
- Creating warehouse, DB, Schema, and tables
- Accessing different roles and using it
- Working with worksheets
- Understanding different types of accounts
- AWS and understanding S3 storage
- Snowflake architecture and caching
- AZURE and understanding blob storage
- GCP and understanding Bucket storage
- File formats
- Internal and external storage
- Internal and external stage
- Copy into usage
- Snowflake internal storage
- Accessing Cloud storage data into Snowflake (GCP, AZURE and AWS)
- Data unloading
- Accessing Snowpipe
- PUT and GET commands
- Bulk loading from cloud storage
- Continuous loading
- Snowflake Connector and use cases Python
- BI connectors use cases
- Other connectors hands-on
- Variant Datatype
- File format options
- Creating stages
- Loading JSON semi-structured data into SF tables
- Accessing JSON with select statement
- Creating Tasks
- Streams
- Accessing procedures with tasks
- Scheduling as per time with Different time zones
- Automate the loading process Daily and Weekly
- 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
- Challenges with cross-region sharing and understanding replication
- Connecting shared objects with BI tools
- Limitations with Data Sharing
- Access Control Privileges for Cloned Objects
- Cloning and Snowflake Objects
- Impact of DDL on Cloning
- Impact of DML and Data Retention on Cloning
- Introduction to Time Travel
- Querying Historical Data
- Enabling and Disabling Time Travel
- Data Retention Period
- Cloning Using Time Travel (Databases, Schemas, and Tables Only)
- Creating multi-users on large tables
- Performance techniques
- Result set cache
- Metadata cache
- Query data cache
- Error Handling and Validations
- Snowflake Pricing model and selecting best Edition and Calculation of Credits usage
- Resource Monitoring
- Data Masking
- Partitioning and Clustering in snowflake
- Materialized View and Normal View
- Integration with Python
- Integration with AWS, Azure, and Google Cloud
- Best Practices to follow
- SCD implementation using streams (CDC)
Have Any Question?
Explore our range of industry-leading courses today and take the first step towards success!
- +91 89517 81299
- vsrinfotech46@gmail.com
