0 (0 Ratings)
Snowflake and Cloud Platforms

What I will learn?
- Understand the architecture and key features of Snowflake.
- Learn how to load and transform data within Snowflake.
- Develop skills to perform data analysis and querying in Snowflake.
- Explore methods to optimize performance for large datasets.
- Implement security best practices to protect data.
- Manage data sharing and collaboration in a cloud environment.
- Understand the fundamentals of cloud computing and key services in AWS, Azure, and Google Cloud.
- Learn to deploy and manage virtual machines, storage, and databases in the cloud.
- Develop skills in configuring and managing cloud networking components.
- Utilize multi-cloud strategies and tools for cross-platform integration.
- Implement security best practices to protect data.
- Manage data sharing and collaboration in a cloud environment.
- 12 hours video|fe fe-play-circle text-primary The miracle feature of zero-copy cloning.
- Certificate|fe fe-award text-success
- 12 Article|fe fe-calendar text-info
- Watch Offline|fe fe-video text-secondary
- Lifetime access|fe fe-clock text-warning
Course Curriculum
Snowflake Architecture and Overview
-
Snowflake Overview
00:00 -
Architecture 101
00:00 -
How to use the Snowflake UI & ecosystem
00:00
Data Movement
-
Ingesting new data into Snowflake Tables
00:00 -
Working with various SQL Data Types
00:00 -
Discussing streaming data
00:00 -
Ingestion best practices & anti-patterns
00:00
Querying Data with SQL
-
View the Schema
00:00 -
Filtering data examples & best practices
00:00 -
Sorting data & performance considerations
00:00 -
Commonly used functions
00:00 -
Save & export data output
00:00 -
Time Travel queries
00:00
Query Caching Performance Features
-
Result set cache
00:00 -
Metadata cache
00:00 -
Query data cache
00:00 -
Best practices of using caching for performance and cost optimization
00:00
Performing Data Analytic Tasks
-
Using Snowflakes high-performing approximation and estimation features
00:00 -
Join and Union queries & tuning techniques
00:00 -
Perform advanced analytic tasks using additional SQL querying capabilities including subqueries, common table expressions, and analytic functions
00:00
Using Snowflakes SQL Extensibility Features
-
User-defined functions
00:00 -
Stored Procedures
00:00 -
Regular Views & Secured Views
00:00
Working with Semi-Structured Data
-
Data source formats
00:00 -
Support of native data types
00:00 -
SQL Operations (Grouping, Sorting & more)
00:00 -
Built-in functions for traversing, flattening, and nesting of semi-structured data
00:00
Visualizing Data
-
Connecting a BI Tool to Snowflake
00:00 -
Exploring & Visualizing data outside of Snowflake
00:00
Snow Pipe
-
AWS Data loads into Snowflake
00:00 -
DBT (Additional- ETL Tool)
00:00
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews
No Review Yet
₹19,999.00
₹30,000.00
-
LevelIntermediate
-
Duration90 hours
-
Last UpdatedOctober 27, 2024
-
CertificateCertificate of completion
Hi, Welcome back!