Snowflake - Introduction Course
✓ Master Snowflake fundamentals ✓ Navigate the Snowflake platform ✓ Perform Data Loading with Snowflake ✓ Professionally work with Snowflake Welcome to our beginner's course on Snowflake, the revolutionary data warehousing platform that's changing the game for businesses around the world. In this course, we'll learn everything you need to know about Snowflake to get started. Not provided by, affiliated with, or sponsored by Snowflake Inc. We'll start by introducing you to the Snowflake platform, its architecture, and its unique cloud-native features.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 4 hours
- Course by Coursera Instructor Network
-
Offered by
About
✓ Master Snowflake fundamentals ✓ Navigate the Snowflake platform ✓ Perform Data Loading with Snowflake ✓ Professionally work with Snowflake Welcome to our beginner's course on Snowflake, the revolutionary data warehousing platform that's changing the game for businesses around the world. In this course, we'll learn everything you need to know about Snowflake to get started. Not provided by, affiliated with, or sponsored by Snowflake Inc. We'll start by introducing you to the Snowflake platform, its architecture, and its unique cloud-native features. You'll learn how to create and manage your own Snowflake account, how to load data into Snowflake, and how to use SQL to query your data. Throughout the course, we'll provide hands-on exercises and real-world examples to help you master Snowflake and apply your knowledge in practical ways. Whether you're a data analyst, data scientist, or business intelligence professional, this course is perfect for anyone looking to leverage Snowflake's powerful data warehousing capabilities. By the end of this course, you'll have a comprehensive understanding of Snowflake and be equipped with the skills you need to harness its full potential. So enroll today and take your data warehousing skills to the next level with Snowflake!Modules
Getting started with Snowflake
-
4
Videos
-
1
Readings
4
Videos
- Welcome to this Snowflake course!
- Free Snowflake trial sign up
- Access your Snowflake account
- Snowflake interface
1
Readings
- Welcome to this Snowflake course
Snowflake concepts & architecture
-
7
Videos
-
2
Readings
-
3
Assignment
3
Assignment
- Snowflake concepts
- Hands-on: Data Loading
- Hands-on: Set up a warehouse
7
Videos
- The three layers in Snowflake
- Understand warehouses
- Set up a warehouse
- Set up a warehouse using SQL
- Multi-cluster warehouses
- Create database objects
- Loading data
2
Readings
- Hands-on: Data Loading
- Hands-on: Set up a warehouse
COPY INTO in Snowflake
-
7
Videos
-
2
Readings
-
3
Assignment
3
Assignment
- Data loading practice question
- COPY command
- Hands-on: Creating file format object
7
Videos
- Bulk vs. Continuous Loading
- Stages in Snowflake
- Set up stage
- Load from stage
- Applying transformations during COPY
- Additional transformations during COPY
- File format objects
2
Readings
- Practice: Data Loading
- Hands-on: Creating file format object
Copy Options
-
6
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Hands-on: Copy Options
6
Videos
- What are copy options
- ON_ERROR
- VALIDATION_MODE
- Error processing after load
- SIZE_LIMIT
- FORCE
1
Readings
- Hands-on: Copy Options
Loading from Azure containers
-
5
Videos
5
Videos
- Create free Azure account
- Create stage for Azure container
- Set up integration object for Azure container
- Load data from Azure container
- Load semi-structured data from Azure container
Auto Summary
Unlock the power of Snowflake with our comprehensive beginner's course designed specifically for data professionals eager to master this cutting-edge data warehousing platform. This foundational course, offered by Coursera, will guide you through the essentials of Snowflake, from its unique cloud-native architecture to practical data loading and querying techniques. With a focus on hands-on exercises and real-world examples, you'll learn to navigate the Snowflake platform, manage your account, and perform data operations using SQL. This course is ideal for data analysts, data scientists, and business intelligence professionals who want to leverage Snowflake's robust capabilities to drive business insights. In just 240 minutes, you'll gain a thorough understanding of Snowflake, equipping you with the skills needed to excel in your data warehousing tasks. Enroll with our Starter subscription and elevate your data expertise with this dynamic and practical Snowflake course. Don't miss out on the opportunity to advance your career and make a significant impact in the IT & Computer Science domain!
Nikolai Schuler