Sidekick
Workspace
Pricing
Blog
Sign In
Get Started
Get Early Access
Learn with
SQL Guides
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Using Snowflake's CAST Function
Performing Advanced Queries with Redshift's EXECUTE Command
Optimizing Queries with BigQuery's Partition Clause
Querying JSON Data with Snowflake's FLATTEN Command
Creating Multi-Step Queries in Snowflake
Using Redshift's DISTINCT ON Function
Using Snowflake's GENERATOR Expressions
Improving Query Performance with Redshift's ANALYZE Command
Storing Data with BigQuery's INSERT INTO Syntax
Creating Recursive Queries with Redshift's WITH Clause
Using Snowflake's SEQUENCE Objects
Using Redshift's IF/THEN Logic
Creating Temporary Tables in Snowflake
Performing Joins on Multiple Tables in Redshift
Using BigQuery's SELECT INTO Syntax
Managing Performance with Redshift's Vacuum Command
Checking Data Quality with Snowflake's QUALIFY Clause
Calculating Moving Averages in BigQuery
Generating UUIDs with Snowflake's UUID() Function
Loading Data with Redshift's COPY Command
Compiling Regular Expressions in Snowflake
Using LATERAL JOIN in Redshift
Integrating BigQuery with Google Cloud Storage
Exploring User Defined Functions in BigQuery
Managing Large Workloads with Snowflake's Task Automation
Managing Temporary Tables in BigQuery
Improving Performance with Snowflake's Result Caching
Pivoting Tables with Redshift's CROSSTAB
Working with Nested Structures in BigQuery
Using SUBSTRING to Extract Strings in Snowflake
Executing Stored Procedures in Redshift
Optimizing Queries with BigQuery's Query Planner
Performing Regex Replacements in Snowflake
Using Dynamic SQL in Redshift
Creating Materialized Views with BigQuery
Using REGEXP_MATCH for Pattern Matching in Snowflake
Leveraging Window Functions in Snowflake
Joining Tables with Redshift's CROSS JOIN
Unnesting Arrays in BigQuery
Understanding Wildcard Search in Snowflake
Creating a Common Table Expression (CTE) in Redshift
Using ARRAY_AGG to Create Arrays in BigQuery
How to Get Yesterday's Date in SQL
How to Get Day Names in SQL
How to Get All Possible Combinations of Rows From Two Tables in SQL
How to Order by Month Name in SQL
How to Add Ranking Positions to Rows with DENSE_RANK in SQL
How to Get the Current Time in SQL
How to Find the Last Day of the Month for a Given Date in SQL
How to Drop a Table in SQL
How to Insert a Single Quote in SQL
How to Trim a String in SQL
How to Change Seconds to a Time Value in SQL
How to Avoid Dividing by Zero in SQL
How to Find Minimum Values in Columns in SQL
How to Filter Records with the Aggregate Function AVG in SQL
How to Add Ranking Positions of Rows with RANK in SQL
How to Filter Records with the Aggregate Function SUM in SQL
How to Remove Trailing Zeros From a Decimal in SQL
How to Get the Current Date and Time with Time Zone Offset in SQL
How to Create a View in SQL
How to Write a Case Statement in SQL
How to Concatenate String and Null Values in SQL
How to Add a Month to a Date in SQL
How to Get the Day of the Year From a Date in SQL
How to Capitalize the First Letter of Every Word in SQL
How to Remove a Unique Constraint in SQL
How to Get the Previous Month in SQL
How to Remove Spaces from a String in SQL
How to Get the Current Time Without Time Zone in SQL
How to Filter Rows Without Null in a Column in SQL
How to Replace Part of a String in SQL
How to Compute an Absolute Value in SQL
How to Add Time to a DateTime Value in SQL
How to Find the Average of a Numeric Column in SQL
How to Find Records with Null in a Column in SQL
How to Get a Remainder Using Mod in SQL
How to Handle Divide by Zero in SQL
How to Find the Name of a Constraint in SQL
How to Get the Day from a Date in SQL
How to Format a DateTime in SQL
How to Calculate a Square Root in SQL
How to Find the Minimum Value of a Column in SQL
How to Compare Two Strings in SQL
How to Remove Unwanted Leading Characters From a String in SQL
How to Get the Current Date and Time in SQL
How to Get the Year from a DateTime Column in SQL
How to Subtract One Value from Another in SQL
How to Calculate the Difference Between Two DateTimes in SQL
How to Floor Numbers in SQL
How to Extract the Week Number From a Date in SQL
How to Remove Leading and Trailing Spaces of a String in SQL
How to Not Show Duplicates in SQL
How to Change Date and Time Formats in SQL
How to Limit Results in SQL
How to Calculate a Square in SQL
How to Trim Strings in SQL
How to Filter Records with Aggregate Function Count in SQL
How to Subtract 30 Days from a Date in SQL
How to Extract or Convert Time Data from a String in SQL
Next
