🎓 CS × DS Vault
Search
Search
Dark mode
Light mode
Explorer
Tag: Tool/SQL
28 items with this tag.
Aug 12, 2026
Building Dimension Tables
CS/Databases
Tool/SQL
DataScience/DataWarehousing
Aug 12, 2026
Data Cleaning (Dirty Data)
CS/Databases
Tool/SQL
DataScience/DataWarehousing
DataScience/DataQuality
Aug 12, 2026
Data Exploration (Warehouse Validation)
CS/Databases
Tool/SQL
DataScience/DataWarehousing
Aug 12, 2026
Multi-Role Facts
CS/Databases
Tool/SQL
DataScience/DataWarehousing
Aug 12, 2026
Oracle SQL Toolkit (Cheatsheet)
CS/Databases
Tool/SQL
Jul 31, 2026
Building Fact Tables
CS/Databases
Tool/SQL
DataScience/DataWarehousing
Jul 31, 2026
Fact Measure Aggregation Rules
CS/Databases
DataScience/DataWarehousing
Tool/SQL
Jul 28, 2026
SQL Joins (ANSI)
CS/Databases
Tool/SQL
Jul 28, 2026
Altering and Dropping Tables
CS/Databases
Tool/SQL
Jul 28, 2026
DML INSERT (Oracle)
CS/Databases
Tool/SQL
Jul 28, 2026
Populating Tables from Queries (INSERT-SELECT, CTAS)
CS/Databases
Tool/SQL
Jul 25, 2026
Column Value Constraints (Check vs Lookup)
CS/Databases
Tool/SQL
SWE/Design
Jul 25, 2026
DDL Table Creation
CS/Databases
Tool/SQL
Jul 25, 2026
DML UPDATE and DELETE (Oracle)
CS/Databases
Tool/SQL
Jul 25, 2026
MongoDB Document Model
CS/Databases
DataScience/BigData
Tool/SQL
Jul 25, 2026
Oracle Data Types
CS/Databases
Tool/SQL
Jul 25, 2026
Query Processing and the Optimiser
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Aggregate Functions and GROUP BY
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Conditional Expressions (CASE, DECODE)
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Formatting Functions (NVL, TO_CHAR, TO_DATE)
CS/Databases
Tool/SQL
Jul 25, 2026
SQL SELECT and WHERE
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Self Join and Outer Join
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Set Operators
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Sorting, Distinct & Alias
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Sublanguages (DDL, DML, DCL)
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Subquery (Nested SELECT)
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Subquery Approaches (Nested, Correlated, Inline)
CS/Databases
Tool/SQL
Jul 25, 2026
SQL Views
CS/Databases
Tool/SQL