Snowflake -The Complete Masterclass ( Edition)
- Offered byUDEMY
Snowflake -The Complete Masterclass ( Edition) at UDEMY Overview
Duration | 14 hours |
Total fee | ₹455 |
Mode of learning | Online |
Credential | Certificate |
Snowflake -The Complete Masterclass ( Edition) at UDEMY Highlights
- Earn a Certificate of completion from Udemy
- Learn from 92 downloadable resources & 2 articles
- Comes with 30 days money back guarantee and full lifetime access
Snowflake -The Complete Masterclass ( Edition) at UDEMY Course details
- For Data Architects & Data Engineers who want to expand their knowledge to new technologies
- For Database Administrators who want to invest in their skills of working within new cloud technologies
- For Everyone that wants to learn Snowflake from beginner to advanced
- For Everyone that wants work with data and wants learn learn about the latest cloud technologies
- Understanding of Snowflake
- Understand the entire Snowflake workflow from end-to end
- Understand everything from scratch -step by step, very structured and practice-oriented
- Learn all the important features -know when and how to use them properly
Snowflake -The Complete Masterclass ( Edition) at UDEMY Curriculum
Getting Started
Sign up for free trial
Getting to know the interface
Snowflake architecture
Setting up virtual warehouses
Scaling policy
Exploring tables & databases
Loading data in snowflake
Snowflake Architecture
What is a data warehouse?
Cloud computing
Snowflake editions
Snowflake pricing
Consumption of credits
Roles in snowflake
Loading data
Creating stage
Copy command
Transforming data
More transformations
File format object
Copy options
Validation mode
Working with rejected records
Size limit
Return failed only
Truncatecolumns
Force
Load history
Loading unstructured history
High-level steps
Our data
Parsing JSON
Handling nested data
Dealing with hierarchy
Insert final data
Performance optimization
Create dedicated virtual warehouse
Implement dedicated virtual warehouse
Scaling up
Scaling out
Maximize Caching
Clustering - Theory
Clustering - Pracitice
Loading from AWS
Sign up for free trial
Creating S3 bucket
Upload files in S3
Creating policy
Creating integration object
Loading from S3
Handle JSON
Loading from Azure
Create a storage account
Create a container
Create integration object
Create stage object
Load CSV file
Load JSON file
Loading from GCP
Create a bucket
Create integration object
Create stage
Unload data