https://r0tbyt3.dev/tags/databases/Recent content in Databases on Jesus OsegueraHugoen-ushttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/acid/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/acid/ACID ACID - properties (Atomicity, Consistency, Isolation, Durability) that guarantee reliable database transactions. Atomicity - a transaction is either completed or not at all. Consistency - a transaction must bring the database from one valid state to another. Isolation - concurrent transactions must not affect each other. Durability - once a transaction is committed, it must persist even in the event of a system failure. Atomicity Example Scenario Scenario: A transaction to transfer $100 from account A to account B fails due to a system failure.https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/advanced-sql/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/advanced-sql/Advanced SQL Advanced SQL - complex SQL techniques including window functions, CTEs, and query optimization. Related Links: Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/aggregate-queries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/aggregate-queries/Aggregate queries Aggregate Queries - SQL queries using functions like COUNT, SUM, and AVG to summarize data. Related Links: Advanced SQL Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/cap-theorem/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/cap-theorem/CAP theorem CAP Theorem - principle stating distributed systems can guarantee only two of: Consistency, Availability, Partition tolerance. Consistency - all nodes see the same data at the same time. Availability - every request receives a response, without guarantee that it contains the most recent data. Partition tolerance - the system continues to operate despite arbitrary partitioning due to network failures. CAP Theorem Trade-offs Consistency and Partition tolerance (CP) - The system sacrifices availability to ensure data consistency during a network partition, often returning an error or time-out if data cannot be synced.https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/column-dbs/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/column-dbs/Column dbs Column Databases - databases storing data by columns instead of rows for analytical query performance. Related Links: Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/common-table-expressions-ctes/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/common-table-expressions-ctes/Common table expressions (CTEs) Common Table Expressions - temporary named result sets within a SQL statement for cleaner query structure. Related Links: Advanced SQL Aggregate queries Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-constraints/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-constraints/Data constraints Data Constraints - rules enforced at the database level to ensure data integrity and validity. Related Links: ACID CAP theorem Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-definition-language/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-definition-language/Data definition language Data Definition Language - SQL commands for defining and modifying database schema structures. Related Links: ACID CAP theorem Data constraints Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-integrity-and-normalization-and-security/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-integrity-and-normalization-and-security/Data integrity and normalization and security Data Integrity, Normalization, and Security - practices ensuring data correctness, minimal redundancy, and protection. Related Links: ACID CAP theorem Data constraints Data definition language Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-manipulation-language/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/data-manipulation-language/Data manipulation language Data Manipulation Language - SQL commands for querying and modifying data within tables. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/data-replication/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/data-replication/Data replication Data Replication - process of copying data across multiple database servers for availability and redundancy. Related Links: Database index Database scaling Indexes and performance optimization Indexing and Query Performance N+1 query problem Performance tuning and query optimization Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/Database Fundamentals Database Fundamentals - core concepts underlying all database systems including transactions, ACID, normalization, and data modeling. ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions Transactions and isolation levels Related Links: Database Performance Database Types SQLhttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/database-index/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/database-index/Database index Database Index - data structure improving the speed of data retrieval operations on a database table. Related Links: Data replication Database scaling Indexes and performance optimization Indexing and Query Performance N+1 query problem Performance tuning and query optimization Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/Database Performance Database Performance - techniques for indexing, scaling, and optimizing database queries and infrastructure. Data replication Database index Database scaling Indexes and performance optimization Indexing and Query Performance N+1 query problem Performance tuning and query optimization Sharding Related Links: Database Fundamentals Database Types SQLhttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/database-scaling/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/database-scaling/Database scaling Database Scaling - strategies for handling increasing database load through vertical or horizontal scaling. Related Links: Data replication Database index Indexes and performance optimization Indexing and Query Performance N+1 query problem Performance tuning and query optimization Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/Database Types Database Types - survey of relational, NoSQL, and specialized database systems and their appropriate use cases. Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databases Related Links: Database Fundamentals Database Performance SQLhttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/Databases Databases - foundational database systems covering SQL, NoSQL, data modeling, and performance for backend development. Database Fundamentals Database Performance Database Types SQL Related Links: Backend Engineering Concurrency Django DSA Python Security System Design Webhttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/databases-and-data-modeling/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/databases-and-data-modeling/Databases and Data Modeling Databases and Data Modeling - design principles for organizing and representing data in database systems. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Migrations Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/document-dbs/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/document-dbs/Document dbs Document Databases - NoSQL databases storing data as flexible JSON-like documents. Related Links: Column dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/dynamic-sql/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/dynamic-sql/Dynamic SQL Dynamic SQL - SQL statements constructed and executed at runtime based on variable input conditions. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/elasticsearch/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/elasticsearch/Elasticsearch Elasticsearch - distributed search and analytics engine built on Apache Lucene for full-text search. Related Links: Column dbs Document dbs Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/graphdbs/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/graphdbs/Graphdbs Graph Databases - databases using graph structures with nodes and edges to store and query relationships. Related Links: Column dbs Document dbs Elasticsearch Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/indexes-and-performance-optimization/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/indexes-and-performance-optimization/Indexes and performance optimization Indexes and Performance Optimization - strategies for using database indexes to improve query speed. Related Links: Data replication Database index Database scaling Indexing and Query Performance N+1 query problem Performance tuning and query optimization Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/indexing-and-query-performance/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/indexing-and-query-performance/Indexing and Query Performance Indexing and Query Performance - techniques for creating and maintaining database indexes to speed up queries. Related Links: Data replication Database index Database scaling Indexes and performance optimization N+1 query problem Performance tuning and query optimization Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/join-queries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/join-queries/Join queries Join Queries - SQL operations combining rows from two or more tables based on related columns. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/key-value/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/key-value/Key value Key-Value Stores - simplest NoSQL database form storing data as key-value pairs for fast lookups. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/memcached/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/memcached/Memcached Memcached - distributed memory caching system for speeding up dynamic web applications. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/migrations/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/migrations/Migrations Migrations - version-controlled changes to database schema applied incrementally over time. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Normalization ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/n+1-query-problem/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/n+1-query-problem/N+1 query problem N+1 Query Problem - performance antipattern causing excessive database queries in ORM-based code. Related Links: Data replication Database index Database scaling Indexes and performance optimization Indexing and Query Performance Performance tuning and query optimization Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/non-relational-databases/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/non-relational-databases/Non-relational databases Non-Relational Databases - databases that do not use the tabular schema of relational systems. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached NoSQL databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/normalization/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/normalization/Normalization Normalization - process of organizing database schema to reduce redundancy and improve data integrity. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations ORMs Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/nosql-databases/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/nosql-databases/NoSQL databases NoSQL Databases - non-relational databases designed for flexible schema, horizontal scale, and performance. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases Redis Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/orms/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/orms/ORMs ORMs - libraries mapping database tables to object-oriented code for convenient database interaction. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization Transactions Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/performance-tuning-and-query-optimization/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/performance-tuning-and-query-optimization/Performance tuning and query optimization Performance Tuning and Query Optimization - techniques for improving database query speed and resource efficiency. Related Links: Data replication Database index Database scaling Indexes and performance optimization Indexing and Query Performance N+1 query problem Shardinghttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/pivot-and-unpivot-operations/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/pivot-and-unpivot-operations/Pivot and unpivot operations Pivot and Unpivot Operations - SQL transformations rotating rows to columns or columns to rows. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/recursive-queries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/recursive-queries/Recursive queries Recursive Queries - SQL queries using CTEs to traverse hierarchical or tree-structured data. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/redis/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/redis/Redis Redis - in-memory data structure store used as a cache, database, and message broker. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Relational databases Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/relational-databases/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/relational-databases/Relational databases Relational Databases - databases organizing data into structured tables with defined relationships between them. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Search engines Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/search-engines/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/search-engines/Search engines Search Engines - systems designed for full-text search and information retrieval from large datasets. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Solr Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/select-insert-delete-update-statements/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/select-insert-delete-update-statements/Select, insert, delete, update statements Select, Insert, Delete, Update Statements - core DML statements for reading and modifying database data. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Stored procedures and triggers Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/sharding/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-performance/sharding/Sharding Sharding - horizontal database partitioning distributing data across multiple servers for scale. Related Links: Data replication Database index Database scaling Indexes and performance optimization Indexing and Query Performance N+1 query problem Performance tuning and query optimizationhttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/solr/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/solr/Solr Solr - open-source enterprise search platform built on Apache Lucene. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Time series dbs Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/SQL SQL - Structured Query Language for defining, querying, and manipulating relational database data. Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views Window functions Related Links: Database Fundamentals Database Performance Database Typeshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/stored-procedures-and-triggers/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/stored-procedures-and-triggers/Stored procedures and triggers Stored Procedures and Triggers - precompiled SQL code stored in the database for reuse and automation. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Subqueries Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/subqueries/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/subqueries/Subqueries Subqueries - SQL queries nested inside other queries to filter or transform result sets. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Views Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/time-series-dbs/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/time-series-dbs/Time series dbs Time Series Databases - databases optimized for storing and querying timestamped data sequences. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Vector databaseshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions/Transactions Transactions - units of work in a database that must execute atomically to maintain consistency. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactions and isolation levelshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions-and-isolation-levels/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-fundamentals/transactions-and-isolation-levels/Transactions and isolation levels Transactions and Isolation Levels - database transaction guarantees and concurrent access control levels. Related Links: ACID CAP theorem Data constraints Data definition language Data integrity and normalization and security Data manipulation language Databases and Data Modeling Migrations Normalization ORMs Transactionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/vector-databases/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/database-types/vector-databases/Vector databases Vector Databases - databases optimized for storing and querying high-dimensional vector embeddings. Related Links: Column dbs Document dbs Elasticsearch Graphdbs Key value Memcached Non-relational databases NoSQL databases Redis Relational databases Search engines Solr Time series dbshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/views/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/views/Views Views - virtual tables defined by a SQL query providing a simplified or filtered interface to data. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Window functionshttps://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/window-functions/Mon, 01 Jan 0001 00:00:00 +0000https://r0tbyt3.dev/wiki/content/backend-engineering/databases/sql/window-functions/Window functions Window Functions - SQL functions performing calculations across rows related to the current row. Related Links: Advanced SQL Aggregate queries Common table expressions (CTEs) Dynamic SQL Join queries Pivot and unpivot operations Recursive queries Select, insert, delete, update statements Stored procedures and triggers Subqueries Views