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

SQL Tutorial - Database Views

Slowly Changing Dimension in Data Warehousing | 1Keydata

Conformed Dimension in Data Warehousing | 1Keydata

Database vs Data Warehouse vs Data Lake | 1Keydata

2-Minute SQL Tips: Introduction To Window Functions

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

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

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

2-Minute SQL Tips: Conditional Aggregation Using Case When

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

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