Are you an aspiring data professional? This course discusses how data professionals like data engineers and analysts use Snowflake for analysis and engineering tasks. You'll get an introduction to why Snowflake is a popular data warehousing solution for companies and learn how to access Snowflake tables and track query activities with its UI tool, Snowsight.


What is Snowflake?

Navigating to a database and schema

Navigate to a table

Executing a query and viewing the results

Analyzing the sales amount

Investigating product categories

Monitoring Query and Copy History

Viewing query Details

Finding a failed data load

Introduction to Snowflake UI

We will explore some of the many features that Snowsight offers that will make you more versatile as a data professional. We will cover Snowflake Marketplace, loading data from popular cloud providers like AWS, GCP, and Azure, and managing role access.

Loading Data from Snowflake Marketplace

Exploring the Snowflake marketplace

Uploading CSV Data

Loading Data from a cloud provider

Creating a table from an external stage

Creating new roles, users, and warehouses

Creating your first notebook

Course Wrap-Up

Snowsight in Action: Managing Data & Access

In Introduction to Snowflake, you will learn to navigate Snowflake, execute SQL queries in Snowsight, and manage data ingestion and integration. The course covers role-based access control, query monitoring, and performance optimization. It is ideal for data engineers, analysts, and BI professionals looking to enhance their data warehousing skills. By the end, you will gain proficiency in Snowflake SQL, data ingestion, management, security, and optimization techniques.

The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos.
The course glossary can be found on the right in the resources section.
To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

<h2>Introduction to Snowflake</h2>

<p>In Introduction to Snowflake, you will learn how to navigate and use Snowflake, a leading cloud-based data warehousing platform. This course will guide you through Snowflake’s architecture, Snowsight for SQL-based queries, and methods for ingesting, integrating, and managing data from various sources. You will also explore role-based access control, query monitoring, and performance optimization.</p>

<h2>Who is this course for?</h2>

<p>This course is perfect for data engineers, analysts, and BI professionals looking to enhance their data warehousing skills, as well as anyone interested in modern cloud data management.</p>

<h2>What you will gain</h2>

<p>Proficiency in Snowflake SQL and Snowsight<br>  
Skills in data ingestion and management<br>  
Understanding of role-based security and optimization techniques</p>

<h2>Conclusion</h2>

<p>As Snowflake continues to transform data storage and analytics, mastering it will help you unlock new opportunities in data analytics and engineering. Start learning today!</p>


Intermediate SQL

Snowflake is a top data warehousing platform. Learn how they use Snowsight, a user-friendly SQL interface for accessing and exploring data.

Introduction to Snowflake

Associate Data Engineer in Snowflake

Snowflake AI Fundamentals

Snowflake Foundations

Finding a failed data load

Introduction to Snowflake

Hands-on interactive exercise