ACID Properties
The four guarantees that database transactions provide to ensure data reliability: Atomicity, Consistency, Isolation, and Durability.
Databases
CAP Theorem
A fundamental theorem in distributed systems stating that a distributed data store can provide at most two of three guarantees: Consistency, …
Data Modeling
The process of creating visual representations of data structures at conceptual, logical, and physical levels to define how data is stored, …
Database Indexing
Data structures that improve query performance by providing fast lookup paths to rows in database tables, including B-tree, hash, and bitmap …
Database Normalization
A systematic approach to organizing relational database tables to reduce data redundancy and improve data integrity, progressing through …
Database Transactions
Units of work in a database that group multiple operations into a single atomic, consistent, isolated, and durable sequence with commit and …
Entity-Relationship Model
A conceptual data modeling technique that represents data as entities, attributes, and relationships, typically visualized through ER …
NoSQL Databases
A broad category of non-relational database systems designed for specific data models and access patterns, including document, key-value, …
Relational Algebra
The formal mathematical foundation for querying relational databases, defining operations like select, project, and join that underpin SQL …
SQL Fundamentals
Structured Query Language, the standard language for defining, manipulating, and querying data in relational database management systems.
Stored Procedures and Triggers
Server-side database programs that encapsulate reusable logic and automatically respond to data events, executing within the database engine …