🎓 CS × DS Vault
Search
Search
Dark mode
Light mode
Explorer
Tag: CS/Databases
83 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
One-Attribute Dimensions
CS/Databases
DataScience/DataWarehousing
Aug 12, 2026
Oracle SQL Toolkit (Cheatsheet)
CS/Databases
Tool/SQL
Aug 12, 2026
Two-Column Table Methodology
CS/Databases
DataScience/DataWarehousing
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 31, 2026
Star Schema
CS/Databases
DataScience/DataWarehousing
Jul 30, 2026
Functional Dependency
CS/Databases
Math/Discrete
Jul 30, 2026
Relation Properties
CS/Databases
Math/SetTheory
Jul 28, 2026
Data Engineering
DataScience/DataEngineering
CS/Databases
Jul 28, 2026
Data Warehouse
CS/Databases
DataScience/DataWarehousing
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
ACID Properties
CS/Databases
SWE/Design
Jul 25, 2026
Associative Entity
CS/Databases
SWE/Design
Jul 25, 2026
Attribute (Conceptual Modelling)
CS/Databases
SWE/Design
Jul 25, 2026
Big Data and the Vs
CS/Databases
DataScience/BigData
Jul 25, 2026
Cardinality (Crow's Foot Notation)
CS/Databases
SWE/Design
Jul 25, 2026
Column Value Constraints (Check vs Lookup)
CS/Databases
Tool/SQL
SWE/Design
Jul 25, 2026
Conceptual Model
CS/Databases
SWE/Design
Jul 25, 2026
Conceptual vs Logical Model
CS/Databases
SWE/Design
Jul 25, 2026
Concurrency Control and Locking
CS/Databases
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
Data Integrity
CS/Databases
SWE/Design
Jul 25, 2026
Database Anomalies
CS/Databases
SWE/Design
Jul 25, 2026
Database Design Life Cycle
CS/Databases
SWE/Design
Jul 25, 2026
Database Recovery
CS/Databases
SWE/Design
Jul 25, 2026
Database Transaction
CS/Databases
SWE/Design
Jul 25, 2026
Deadlock
CS/Databases
SWE/Design
Jul 25, 2026
Domain (Relational Model)
CS/Databases
Math/SetTheory
Jul 25, 2026
Entity (Conceptual Modelling)
CS/Databases
SWE/Design
Jul 25, 2026
Entity Relationship Diagram (ERD)
CS/Databases
SWE/Design
Jul 25, 2026
FIT2094 Unit Cheatsheet
CS/Databases
Jul 25, 2026
First Normal Form (1NF)
CS/Databases
SWE/Design
Jul 25, 2026
Foreign Key and Referential Integrity
CS/Databases
SWE/Design
Jul 25, 2026
Identifying vs Non-Identifying Relationship
CS/Databases
SWE/Design
Jul 25, 2026
Logical Modelling (ER Mapping)
CS/Databases
SWE/Design
Jul 25, 2026
Logical Modelling Constraints
CS/Databases
SWE/Design
Jul 25, 2026
Mapping Binary Relationships (Logical)
CS/Databases
SWE/Design
Jul 25, 2026
Mapping Entities and Attributes (Logical)
CS/Databases
SWE/Design
Jul 25, 2026
Mapping Unary and Ternary Relationships (Logical)
CS/Databases
SWE/Design
Jul 25, 2026
MongoDB CRUD Operations
CS/Databases
DataScience/BigData
Jul 25, 2026
MongoDB Document Model
CS/Databases
DataScience/BigData
Tool/SQL
Jul 25, 2026
NULL Value
CS/Databases
SWE/Design
Jul 25, 2026
NoSQL Data Models
CS/Databases
DataScience/BigData
Jul 25, 2026
NoSQL Databases
CS/Databases
DataScience/BigData
Jul 25, 2026
Normalisation
CS/Databases
SWE/Design
Jul 25, 2026
Oracle Data Types
CS/Databases
Tool/SQL
Jul 25, 2026
Personal Data and Privacy in Database Design
CS/Databases
SWE/Design
Ethics/Privacy
Jul 25, 2026
Primary Key
CS/Databases
SWE/Design
Jul 25, 2026
Query Processing and the Optimiser
CS/Databases
Tool/SQL
Jul 25, 2026
Relation (Database)
CS/Databases
Math/SetTheory
Jul 25, 2026
Relational Algebra Joins
CS/Databases
Math/Discrete
Jul 25, 2026
Relational Algebra
CS/Databases
Math/Discrete
Jul 25, 2026
Relational Model
CS/Databases
Math/SetTheory
Jul 25, 2026
Relationship (Conceptual Modelling)
CS/Databases
SWE/Design
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
Jul 25, 2026
SQL vs NoSQL Databases
DataScience/BigData
CS/Databases
Jul 25, 2026
Second Normal Form (2NF)
CS/Databases
SWE/Design
Jul 25, 2026
Select and Project (σ, π)
CS/Databases
Math/Discrete
Jul 25, 2026
Set Operations in Relational Algebra
CS/Databases
Math/SetTheory
Jul 25, 2026
Super Key and Candidate Key
CS/Databases
Math/Discrete
Jul 25, 2026
Surrogate Key
CS/Databases
SWE/Design
Jul 25, 2026
Synthesis (Normalisation)
CS/Databases
SWE/Design
Jul 25, 2026
Third Normal Form (3NF)
CS/Databases
SWE/Design
Jul 25, 2026
Unnormalised Form (UNF)
CS/Databases
SWE/Design
Jul 25, 2026
n-ary Relation
Math/Relations
CS/Databases