What you'll learn

Working with Snowflake UDFs, account security, virtual warehouse, storage, data protection, and data sharing to leverage Snowflake's capabilities.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

3 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There is 1 module in this course

Step into the world of Snowflake Cloud Data Platform: Getting Started course, where you will explore Snowflake and learn the fundamentals that will give you the foundation to navigate and leverage this powerful cloud data platform.

During this course, you will explore the applications of Snowflake and delve into its fundamentals. By the end of this course, you will be able to: - Discuss the core concepts, benefits, and architecture of Snowflake. - Apply UDFs, procedures, and streams for efficient data management. - Organize account access and security protocols effectively. - Illustrate Snowflake's performance and query execution. - Demonstrate proficiency in storage management and data protection. - Apply data-sharing techniques within the Snowflake platform. This introductory short course is designed for Freshers, Database Engineers, Database Administrators, and SQL Developers seeking to explore the Snowflake Cloud Data Platform. Prior working experience with RDBMS and SQL is recommended but not mandatory for this course. Begin an educational journey to learn about the Snowflake Cloud Data Platform and its concepts for handling and analyzing large volumes of data.

Welcome to this module focused on Snowflake's architecture and core concepts, including UDFs, Procedures, and Streams. Learn best practices for account security and performance optimization, along with insights into data storage, protection, and sharing strategies. Gain the skills to efficiently manage and leverage Snowflake's capabilities

What's included

27 videos9 readings3 assignments2 discussion prompts

27 videosTotal 105 minutes

Course Introduction3 minutesPreview module
What is Snowflake?3 minutes
Creating a Snowflake Account2 minutes
Snowflake Editions and Object Model5 minutes
Organizations, Accounts, Databases and Schemas3 minutes
Table and View Types4 minutes
Databases and Schemas (Hands-on)3 minutes
Tables and Views (Hands-on)5 minutes
User Defined Functions3 minutes
Stored Procedures2 minutes
UDFs and Stored Procedures (Hands-on)4 minutes
Sequences, Tasks and Streams5 minutes
Overview of Access Control3 minutes
Roles and Privileges4 minutes
Access Control (Hands-on)3 minutes
Column Level Security and Row Level Security3 minutes
Column and Row Level Security (Hands-on)7 minutes
Overview of the Virtual Warehouse2 minutes
Virtual Warehouse Overview (Hands-on)4 minutes
Query performance analysis tools (Hands-on)4 minutes
Caching and Materialized Views4 minutes
Snowflake Clustering2 minutes
Overview of Storage Layer2 minutes
Micro-partitions3 minutes
Time Travel and Fail-Safe5 minutes
Cloning4 minutes
Secure Data Sharing2 minutes

9 readingsTotal 65 minutes

Snowflake Cloud Data Platform: Getting Started5 minutes
How to Use Discussion Forums4 minutes
Snowflake Security Terminology7 minutes
Account Usage and Information Schema5 minutes
Multi-cluster Warehouses5 minutes
Data Marketplace4 minutes
Practice Project: SnowCart Data Centralization with Snowflake Cloud Data Platform30 minutes
Course Summary3 minutes
Course Wrap Up2 minutes

3 assignmentsTotal 30 minutes

Knowledge Check: Snowflake Fundamentals and Essentials5 minutes
Knowledge Check: Account Access, Security, and Performance5 minutes
End Course Knowledge Check: Module Wrap Up and Assessment20 minutes

2 discussion promptsTotal 10 minutes

How does Snowflake's architecture contribute to its scalability and performance compared to traditional data warehousing solutions?5 minutes
Discuss the role and significance of User Defined Functions (UDFs) and Stored Procedures in database management systems5 minutes