1Keydata

Learn Basic SQL Commands: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Table Constraints in SQL: NOT NULL, DEFAULT, UNIQUE, and CHECK

SQL Intersect, Union, Union All, Minus, and Except

What is Dimensional Modeling | 1Keydata

2-Minute SQL Tip: Sorting Data with Order By

Database vs Data Warehouse vs Data Lake | 1Keydata

Learn Basic SQL Commands: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Slowly Changing Dimension in Data Warehousing | 1Keydata

SQL Tutorial - Database Views

Manage Tables in SQL: CREATE TABLE, DROP TABLE, TRUNCATE TABLE

2-Minute SQL Tips: Calculating Moving Averages Using Window Function

Conformed Dimension in Data Warehousing | 1Keydata

2-Minute SQL Tips: Finding Unique Values Using COUNT DISTINCT

2-Minute SQL Tips: Checking For Duplicates With ROW NUMBER

2-Minute SQL Tips: Using Multiple CTEs In A Query

2-Minute SQL Tips: When to use ROW_NUMBER ( ), RANK ( ), and DENSE_RANK ( ) in window functions

2-Minute SQL Tip: Difference Between INNER JOIN and LEFT JOIN

2-Minute SQL Tips: How To Use Wildcards With LIKE

2-Minute SQL Tips: How To Use Aliases

2-Minute SQL Tips: Writing Comments in SQL Queries

2-Minute SQL Tips: Understanding the EXISTS Operator

2-Minute SQL Tips: Introduction To Correlated Subquery

2-Minute SQL Tips: Using the CASE Statement for Conditional Logic

2-Minute SQL Tips: Handling Duplicates With EXISTS

2-Minute SQL Tips: Using IN and NOT IN for list comparisons

2-Minute SQL Tips: Quickly Find Duplicates In Your Data

2-Minute SQL Tip: Calculating Running Totals With A Window Function

2-Minute SQL Tips: Conditional Aggregation Using Case When

2-Minute SQL Tip: Find The Nth Occurrence Of A Value

2-Minute SQL Tips: Subquery vs CTE