starweaver-logo
LOG INGET STARTED
LOG INGET STARTED
  • Browse
  • Doing

  • On Air
  • Channels
  • Career Paths
  • LEARNING

  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • CONNECTING

  • How It Works
  • Community
  • Techbytes
  • Podcasts
  • Leaderboards
  • SUPPORT

  • Support & FAQs
  • Starweaver for Business
  • Starweaver for Campus
  • Teach with Starweaver
footer-brand-logo
  • COMPANY
  • About Us
  • Support and Knowledge Base
  • Policies & Terms
  • Contact
  • CONTENT
  • Courses
  • Certifications
  • Journeys
  • Test Prep
  • Meet the Gurus
  • Techbytes
  • FOR ORGANIZATIONS
  • Starweaver for Business
  • Starweaver for Campus
  • Catalogue
  • Pricing
  • Private Classes
  • PARTNER WITH US
  • Instructors & Teachers
  • Books, Writing & Publishing
  • FOLLOW US
    • facebook
    • twitter
    • linkedin
    • pinterest
    • instagram
    • youtube
Our trademarks include Starweaver®, Make genius happen™, Education you can bank on®, People are your most important assets!®, Body of Knowledge™, StarLabs™, LiveLabs™, Journeys™
© Starweaver Group, Inc. All Rights Reserved.
  1. Courses
  2. >
  3. Snowflake - Applications and Implementation

Snowflake - Applications and Implementation

This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform.

Hamid Qureshi
Hamid Qureshi
Data Science | intermediate | 5 hours 35 minutes |   Published: Nov 2020
In partnership with:  Coursera

    Discussions

Overview

2.1KSTUDENTS*
94%RECOMMEND*

This course includes:

  • 5+ hours of on-demand video
  • 6 modules
  • Core level
  • Direct access/chat with the instructor
  • 100% self-paced online
  • Many downloadable resources
  • Shareable certificate of completion
This course covers the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform. Snowflake is the leading solution for warehousing in the cloud. It is built for the cloud. Snowflake delivers the performance, concurrency and simplicity needed to store and analyze all of an organization’s data in one solution. Snowflake’s technology combines the power of data warehousing, the flexibility of big data platforms and the elasticity of the cloud at a fraction of the cost of traditional solutions

Skills You Will Gain

Big Data
Cloud
Data Warehouse

Learning Outcomes (At the end of this program you will be able to)

Learning Objectives (At the end of this course, you will be able to…):

  • Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
  • Load and transform data
  • Evaluate Query Constructs and DDL & DML Operations
  • Review Snowflakes broad SQL support for data analysis
  • Describe how user and application access can be easily managed
  • Demonstrate best practices for working with semi-structured data
  • Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
  • Employ Snowflake’s method for continuous data protection
  • Utilize Data Sharing to send your data in real-time to Customers and Partners
  • Scale your Virtual Warehouse for performance and concurrency
  • Explain the different ways you can manage and monitor your Snowflake account

Prerequisites

  • A basic level of conceptual understanding of data warehouses is assumed, as well as an awareness of the core functions of SQL.

Who Should Attend

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

Curriculum

Instructors

Frequently Asked Questions

How much do the courses at Starweaver cost?

We offer flexible payment options to make learning accessible for everyone. With our Pay-As-You-Go plan, you can pay for each course individually. Alternatively, our Subscription-Based plan provides you with unlimited access to all courses for a monthly or yearly fee.

Do you offer any certifications upon completion of a course at Starweaver?

Yes, we do offer a certification upon completion of our course to showcase your newly acquired skills and expertise.

Does Starweaver offer any free courses or trials?

No, we don't offer any free courses, but we do offer 5-day trial only on our subscriptions-based plans.

Are Starweaver's courses designed for beginners or advanced students?

Our course is designed with three levels to cater to your learning needs - Core, Intermediate, and Advanced. You can choose the level that best suits your knowledge and skillset to enhance your learning experience.

What payment options are available for Starweaver courses?

We accept various payment methods such as major credit cards, PayPal, wire transfer, and company purchase orders. For more information related to payments contact customer support.

Do you offer refunds?

Yes, we do offer a 100% refund guarantee for our courses within a specified time frame. If you are not satisfied with the course, contact our customer support team to request a refund with your order details. Some restrictions may apply.

*Where courses have been offered multiple times, the “# Students” includes all students who have enrolled. The “%Recommended” shown is also based on this data.
1Welcome to the course!
2Program Announcements
3Labs - Data Loads and Processing
4Module 1 - Snowflake Introduction
5Module 2 - Snowflake Architecture
6Module 3 - Data Loading in Snowflake
7Module 4 - Performance Optimization
8Module 5 - Time Travel
9Module 6 - Secure Data Sharing
10Module 7 - Snowflake Access Management

Announcement 001 - You MUST Create a FREE Snowflake account

Module 1 - Overview and Learning Objectives

Module 1.1 - Signing up for Snowflake Trial

Module 1.2 - The Snowflake Story

Module 1.3 - Creating our first Database & Table

Module 1.4 - Snowflake Pricing Overview

Assignment - Create, Load & Query a Table

Quiz - Snowflake Overview

Module 2 - Overview and Learning Objectives

Module 2.1 - What is a Data Warehouse?

Module 2.2 - Why Cloud Computing?

Module 2.3 - Snowflake Architecture

Module 2.4 - Virtual Warehouse and Scalability

Module 2.5 - Snowflake Pricing

Labs - Overview

Lab 1 - Load Taxi Trajectory Data

Lab 2 - Transactions

Lab 3 - Unload To Internal Stage

Lab 4 - Load Data to Multiple Tables

Lab 5 - Load Tobacco Data Using Internal Stage - Unguided

Lab 6 - Create Integration Object

Lab 7 - Using Snowflake as Query Engine

Lab 8 - AWS Open Data

Lab 9 - Loading Parquet File

Lab 10 - Finding Bug During Upload to S3

Lab 11 - Loading Json Book Data

Lab 12 - Loading Twitter Data Unstructured

About this course: Overview, Learning Outcomes, Who Should Enroll...

Curriculum Description

Instructor bio - Hamid Qureshi

Module 3 - Overview and Learning Objectives

Module 3.1 - Install Snow CLI

Module 3.2 - Introduction to Stages

Module 3.3 - Types of Internal Stages

Module 3.4 - External Internal Stage Diff

Module 3.5 - Creating Stage Obj (Fileformat Obj)

Module 3.6 - Upload Data Using Snow CLI

Module 3.7 - Download Data Using Snow CLI

Module 3.8 - Using Different Stage Types

Module 3.8A - Taxi Trajectory - Data Load Demo - 1( Preparing Data)

Module 3.8B - Taxi Trajectory - Data Load Demo - 2 (Loading Sample File)

Module 3.8C - Taxi Trajectory - Data Load Demo 3 ( Understanding Copy Command Performance )

Module 3.8D - Taxi Trajectory Copy Command Performance

Module 3.9 - Policy for External Stage

Module 3.10 - Role for External Stage

Module 3.11 - Creating Integration Obj

Module 3.12 - Load from S3 to Snowflake

Module 3.13 - Upload to S3 from Snowflake

Module 3.14 - Snowpipe Demo

Lab 3.1 - Connect Tasks Together

Lab 3.2 - Create a Stream

Lab 3.3 - Create a Task

Lab Submission - Module 3 (Submit all labs for this module AT ONCE, in a single file)

Module 5 - Overview and Learning Objectives

Module 5.1 - Back to the Future with Snowflake

Module 5.2 - Lab - Travel to a Time or Before a Query

Module 5.3 - Undrop Databases, Schemas & tables

Module 5.4 - Fail Safe in Snowflake

Module 5.5 - Lab - Failsafe Storage Usage

Module 5.6 - Zero Copy Cloning

Module 5.7 - Zero Copy Cloning with Time Travel

Hamid Qureshi

Hamid Qureshi

With over two decades of experience in data-centric solutions, Hamid Qureshi brings a wealth of expertise in architecting and implementing robust data warehouse infrastructures and cloud-based ecosystems. His career spans a wide range of industries including Financial Services, Retail, and Healthcare, where he has led the development of comprehensive data governance frameworks and advanced data lake solutions.

A hands-on practitioner with a strategic mindset, Hamid Qureshi seamlessly blends technical acumen with business insight to drive successful data platform implementations that align with and exceed business objectives. He has held pivotal roles at global firms, where he has spearheaded complex information architecture projects and data governance initiatives with lasting impact.

Known for his ability to engage effectively with stakeholders at all levels—from senior executives to technical teams—Hamid Qureshi has a proven track record of delivering scalable, efficient data solutions. His passion for automation and simplification fuels innovation in data processes, consistently resulting in increased operational efficiency and substantial cost savings for clients.

Specializing in Snowflake-based data warehousing and business intelligence, Hamid Qureshi is certified and highly proficient. He has authored industry-recognized courses and books on the subject, reinforcing his reputation as a thought leader in the field.

Beyond project execution, Hamid Qureshi is committed to mentorship and talent development within the data engineering and analytics community. He actively shares insights from his extensive career, helping to shape the next generation of data professionals.

VIEW MY CHANNEL

Module 4 - Overview and Learning Objectives

Module 4.1 - Performance Optimisation

Module 4.2 - Dedicated Virtual Warehouse

Module 4.3 - Dedicated Virtual Warehouse Hands On

Module 4.4 - Scale Up Virtual Warehouse

Module 4.5 - Scale Out Virtual Warehouse

Module 4.6 - Auto Scaling

Module 4.7 - Maximize Cache Usage

Module 4.8 - Lab - Maximize Cache Usage

Module 4.9 - Clustering Keys

Module 4.10 - Lab - Clustering Keys

Module 7 - Overview and Learning Objectives

Module 7.1 - Snowflake Approach to Access Control & Key Concepts

Module 7.2 - Out of the Box Snowflake Roles

Module 7.3 - Role Hierarchy in Snowflake

Module 7.4 - ACCOUNTADMIN role

Module 7.5 - Outline of the IAM Hands on Lectures

Lab - Demonstrating ACCOUNTADMIN role

Module 7.6 - SECURITYADMIN role

Lab - Demonstrating SECURITYADMIN role

Module 7.7 - SYSADMIN role

Lab - Demonstrating SYSADMIN role

Lab - Demonstrating use of the Custom Roles

Module 7.8 - Custom Roles

Module 7.9 - Public Role

Assignment - Assign Privileges Through a New Custom Role

Module 6 - Overview and Learning Objectives

Module 6.1 - Secure Data Sharing

Module 6.2 - Sharing Views

Module 6.3 - Sharing with a Snowflake User

Module 6.4 - Sharing Who's Compute is Used

Module 6.5 - Sharing Data Always Uptodate

Module 6.6 - What is a Share?

Module 6.7 - Sharing with Non-Snowflake Users

Module 6.8 - Sharing Complete Databases and Schemas

Module 6.9 - Lab - Sharing - Through Web UI