Snowflake for Non-Programmers
- Created By raju2006
- Last Updated November 24th, 2023
- Overview
- Prerequisite
- Audience
- Audience
- Curriculum
Description:
The course outline for Snowflake Data Warehouse for non-programmers covers the basic concepts of Snowflake, including its architecture, key features, and benefits. The course will also cover how to load and query data in Snowflake, data modeling best practices, security and administration, data sharing and collaboration, and Snowflake integrations and ecosystem. The course concludes with a summary of key concepts and final thoughts on Snowflake data warehousing.
Duration: 4 Hours
Course Code: BDT270
Learning Objectives:
After this course, you will be able to:
- Understand basic concepts of Snowflake, including its architecture, key features, and benefits
- Develop a foundational knowledge of snowflake specific data types and understand how to bring share data within/across organizations
- Understand snowflake ecosystems and integration with other tools and services
- Basic understanding of computers
- This course is designed for anyone interested in understanding one of most popular data warehousing software: Snowflake.
- This course is designed for anyone interested in understanding one of most popular data warehousing software: Snowflake.
Course Outline:
Introduction to Cloud and Data Warehouse
- Cloud computing development & service models
- What is Data Warehouse & Why is it used?
Introduction to Snowflake
- What is Snowflake?
- Snowflake history
- Data Warehouse as a Service
- Cloud Platforms and Regions
- Snowflake Editions
Snowflake Architecture
- Understanding Snowflake 3-Tier Architecture
- Data Storage
- Query Processing
- Cloud Services
- Lab: Examine Snowflake Web UI
Understanding Snowflake Objects
- Connecting to Snowflake
- Understanding Snowflake Roles
- Virtual Warehouses
- Database Objects
Structured Data Ingestion
- Structured Data Ingestion
- Data Staging
- Bulk load from Cloud Storage
- Query Data
- Demo: Data Ingestion
Training material provided: Yes (Digital format)
Demo: Instructor will do demonstrate the use of snowflake
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]
