Databases
All articles
Level 3: The Infrastructure
Databases, servers, APIs, and the cloud. Where software runs, how it stores data, and how systems communicate …Stored Procedures and Triggers
Server-side database programs that encapsulate reusable logic and automatically respond to data events, …SQL Fundamentals
Structured Query Language, the standard language for defining, manipulating, and querying data in relational …Relational Algebra
The formal mathematical foundation for querying relational databases, defining operations like select, …NoSQL Databases
A broad category of non-relational database systems designed for specific data models and access patterns, …Entity-Relationship Model
A conceptual data modeling technique that represents data as entities, attributes, and relationships, …Database Transactions
Units of work in a database that group multiple operations into a single atomic, consistent, isolated, and …Database Normalization
A systematic approach to organizing relational database tables to reduce data redundancy and improve data …Database Indexing
Data structures that improve query performance by providing fast lookup paths to rows in database tables, …Data Modeling
The process of creating visual representations of data structures at conceptual, logical, and physical levels …CAP Theorem
A fundamental theorem in distributed systems stating that a distributed data store can provide at most two of …ACID Properties
The four guarantees that database transactions provide to ensure data reliability: Atomicity, Consistency, …
Open source projects