Learn Snowflake SQL
Essentials
- CAST: Convert Data Types
- COALESCE: Get the First Non-NULL value
- EXCEPT: Data Difference
- GROUP BY: Aggregate Data into Groups
- IFNULL: Handle Missing Values
- ROUND: Numbers Rounding
- UNION: Combine Data Sets
Table Management
- ADD COLUMNS
- ALTER TABLE STRUCTURE
- CLONE TABLES
- CREATE SCHEMAS
- CREATE TABLES
- CREATE VIEWS
- CREATE USERS
- DROP TABLES
- DROP COLUMNS
- RENAME COLUMNS
- RENAME TABLES
- TRUNCATE TABLES
Table Manipulation
String Functions
- CONCAT: Concatenate Strings
- LISTAGG: Aggregate Values Into Delimited String
- REPLACE: Find and Replace Substrings
- SPLIT: Divide Strings into Arrays
- SUBSTRING: Extract Parts of a String
- TRIM: Clean Up Strings
Date & Time Functions
- CONVERT_TIMEZONE: Convert Time Zone
- CURRENT_DATE: Get Current Date
- DATE_TRUNC: Round Down Date/Time
- DATEADD: Modify Date/Time
- DATEDIFF: Calculate Difference Between Dates/Times
Conditional Expression
- BETWEEN: Filter Data Within Range
- CASE: Apply "if-then" Logic
- COUNT_IF: Conditional Counting
- IFF: Single Conditional Logic
Window Functions
- FIRST_VALUE: Retrieve First Value in Data Sets
- ROW_NUMBER: Assign Sequential Row Numbers Within Partitions
- QUALIFY: Filter Window Function Results
Semi-Structured Data
Advanced SQL
- CREATE STAGE: Define Storage Spaces for Data
- COPY INTO: Efficient Data Loading
- Common Table Expressions (CTE)
- EXCLUDE: Exclude Columns from Queries
- PERCENTILE: Calculate Percentiles
- PIVOT: Turn Rows Into Columns
- DATA SHARING: Share Data Securely
Automation
