Snowflake Database - Querying Data Part 1

Overview

SQL is the most used query language in the world and Snowflake is quickly becoming the most used cloud data platform in the world. There are, of course, other query languages for different types of databases, such as NoSQL databases but SQL remain the standard and Snowflake's SQL implementation is full ANSISQL compliant.

Syllabus

• Introduction to Snowflake
Overview of Cloud Data Platforms
Introduction to Snowflake's Architecture
Key Features of Snowflake
• SQL Basics
Introduction to SQL
Data Types and Table Structures
Basic SQL Syntax
• Querying Data in Snowflake
Writing and Executing Queries
Using SELECT Statements
Filtering Data with WHERE Clauses
• Working with Snowflake SQL
Using Joins to Combine Tables
Sorting and Limiting Results with ORDER BY and LIMIT
Functions and Expressions
• Advanced Query Techniques
Subqueries and Nested Queries
Common Table Expressions (CTEs)
Handling NULL Values
• Managing and Modifying Data
Inserting, Updating, and Deleting Data
Transactions in Snowflake
Using DML Commands
• Optimizing Queries
Understanding Query Performance
Indexing and Execution Plans
Best Practices for Writing Efficient Queries
• Introduction to Snowflake Specific Features
Time Travel and Data Retention
Cloning and Data Sharing
Schema Management in Snowflake
• Practical Exercises and Projects
Real-World Query Scenarios
Collaborative Queries in a Cloud Environment
Final Project: Building and Optimizing a Query-Driven Report
• Review and Q&A
Recap of Key Concepts
Open Discussion and Questions
Preparing for Part 2 of the Course

Taught by

Randy Minder

Subjects

Business