Saad Qureshi
Introduction to Snowflake:
Snowflake is a data warehouse that runs entirely on cloud infrastructure.
It is faster, easier to use, and far more flexible than traditional data warehouse.
Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud.
It is available on AWS and Azure cloud only.
Snowflake has hybrid architecture and has the capabilities of both shared as well as shared nothing architecture.It has three different layers.
Storage Layer
Compute Layer/Query Processing Layer
Cloud Services Layer
Storage Layer:
Snowflake organizes the data into multiple micro partitions that are internally optimized and compressed.
Snowflake is provisioned on the Cloud, storage is elastic and is charged as per the usage per TB every month.
Compute Layer:
Snowflake uses Virtual Warehouse for running queries.
Virtual Warehouses are MPP compute clusters consisting of multiple nodes with CPU and memory provisioned on the cloud.
Multiple Virtual Warehouses are created to mange the workload.
Cloud Services Layer:
All the activities such as authentication, security, load management and query optimization are done by cloud service layer.
After this course:
Once your are done with the course,you will have maximum knowledge of Snowflake Cloud Data Warehouse and can apply these concepts writing SQL queries.
Instructor Details
Courses : 4
Specification: Snowflake Fundamentals-Comprehensive SQL course on Snowflake
|
9 reviews for Snowflake Fundamentals-Comprehensive SQL course on Snowflake
Add a review
| Price | $12.99 |
|---|---|
| Provider | |
| Duration | 8 hours |
| Year | 2020 |
| Level | Beginner |
| Language | English |
| Certificate | Yes |
| Quizzes | No |
$12.99
Shivaranjani Shamarao –
good
Himanshu Shekhar –
Sql training dominates after first few sessions. It could have few more sessions related to Snowflake ie… (data migration from a table hosted in local environment, ETL tool connections and so on).
Roves Rove –
Well done Saad! A very good compilation of concepts and examples. You are practically narrating as it will be useful to a developer. An absolute must for anyone who wants to hit the road running, instead of having just theoritical knowledge. I would suggest you to consider all Typical and Peculiar scenarios which a developer can face, and make videos on them too.
Prachi Patel –
It is good for students but not for professionals. best hands on practice.
Sivakumar Ayyapusetty –
As much info is not available in google this is the best as of now
Kalyanram –
good
Murali Mohan –
Yes . The course covers the fundamentals with examples
Abhijeet Bais –
this is very slow speed and superficial level so far
Pragadeesh J –
NA