- Overview
- Prerequisites
- Audience
- Audience
- Curriculum
Description:
Discover how Snowflake, a cutting-edge data warehousing solution, leverages advanced cloud computing capabilities through Software as a Service (SaaS). Dive into a world of data storage, processing, and analytics that outpaces traditional alternatives in terms of speed and ease of use. Join the movement with one of the fastest-growing data warehouse services in the industry. Take the first step toward expertise with our comprehensive training."
Course Code/Duration:
BDT172 / 1 Day
Learning Objectives:
After this course, you will be able to:
- Cloud & Data Warehousing Basics
- Introduction to Snowflake
- Snowflake Architecture
- Snowflake Objects
- Data Ingestion
- Data Sharing
- Basic knowledge of relational databases and SQL.
- This course is designed for anyone interested to get started with using Snowflake – Developers, DBA, Architects.
- This course is designed for anyone interested to get started with using Snowflake – Developers, DBA, Architects.
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
- Lab: Creating Snowflake Account
- 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
- Lab: Create Warehouse, Database objects
- Structured Data Ingestion
- Structured Data Ingestion
- Data Staging
- Bulk load from Cloud Storage
- Query Data
- Lab: Data Ingestion
- Data Sharing
- Overview of Data Sharing
- Zero Clone Copying
- Cloning Database, Schema, Tables
- Lab: Clone Database
Training material provided:
Yes (Digital format)
Hands-on Lab: Instructions will be provided to set up a free tier snowflake account.
The curriculum is empty
[INSERT_ELEMENTOR id="19900"]