Last chance: 50% off unlimited learning
Sale ends in
Course Description
Introduction to Snowflake
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.
Who is this course for?
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.
What you will gain
Proficiency in Snowflake SQL and Snowsight
Skills in data ingestion and management
Understanding of role-based security and optimization techniques
Conclusion
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!
Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Assess appropriate role, warehouse, and privilege configurations to support least-privilege access and workload requirements in Snowflake
- Define the procedures for bringing external data into Snowflake
- Distinguish between Query History and Copy History tools when monitoring queries and data loads
- Identify key components of Snowflake’s three-layer architecture
- Recognize Snowsight workflow steps for creating, executing, and saving SQL queries
Prerequisites
Curriculum
Course outline
1
Introduction to Snowflake UI
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?50 XP
- Navigating to a database and schema100 XP
- Navigate to a table100 XP
- Executing a query and viewing the results50 XP
- Analyzing the sales amount100 XP
- Investigating product categories100 XP
- Monitoring Query and Copy History50 XP
- Viewing query Details100 XP
- Finding a failed data load50 XP
2
Snowsight in Action: Managing Data & Access
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.
S
Introduction to Snowflake
Course
Complete
