Skip to content
Tagged articles

database-fundamentals

9 articles · Page 1 of 1
Architect's Guide
Architect's Guide
Oct 11, 2026 · Databases

Why Database Indexes Speed Up Queries: Binary Search & Clustered Indexes Explained

This article explains how database indexes accelerate queries by leveraging sorted data structures and binary search, detailing disk I/O mechanics, clustered vs. non-clustered indexes, index trade-offs on write performance, and common SQL optimization pitfalls like OR conditions and leading wildcards that cause index invalidation.

MySQLQuery PerformanceSQL Optimization
0 likes · 13 min read
Why Database Indexes Speed Up Queries: Binary Search & Clustered Indexes Explained
liandk
liandk
Aug 16, 2026 · Databases

Understanding DELETE vs DROP: How to Remove Data Without Dropping the Table

This article clarifies the difference between SQL DELETE and DROP TABLE, showing that DELETE removes rows while preserving table structure (and requires a WHERE clause), whereas DROP TABLE eliminates the entire table, and provides practical scenarios and code examples for each.

DELETEDROP TABLEData Manipulation
0 likes · 2 min read
Understanding DELETE vs DROP: How to Remove Data Without Dropping the Table
MaGe Linux Operations
MaGe Linux Operations
Feb 2, 2025 · Fundamentals

Unlock MySQL Storage Engines: InnoDB vs MyISAM and Transaction Essentials

This article explains MySQL's storage engine architecture, compares built‑in engines such as InnoDB and MyISAM, details their file system interactions, table‑space types, and transaction features—including ACID properties, isolation levels, locking mechanisms, and practical migration steps for production environments.

InnoDBMySQLdatabase-fundamentals
0 likes · 16 min read
Unlock MySQL Storage Engines: InnoDB vs MyISAM and Transaction Essentials
ITPUB
ITPUB
Aug 31, 2020 · Databases

Mastering MySQL: Keys, Indexes, Transactions, Storage Engines, and Optimization Explained

This comprehensive guide covers MySQL fundamentals—including primary, foreign, candidate, and super keys—auto‑increment primary keys, triggers, stored procedures, views, cursor usage, index types and design, transaction properties and isolation levels, storage engine differences, query execution order, EXPLAIN analysis, lock mechanisms, replication strategies, high‑concurrency solutions, and crash‑recovery via REDO and UNDO logs, providing practical examples and code snippets for each concept.

MySQLSQL OptimizationStorage Engines
0 likes · 52 min read
Mastering MySQL: Keys, Indexes, Transactions, Storage Engines, and Optimization Explained
Big Data Technology & Architecture
Big Data Technology & Architecture
Apr 12, 2020 · Databases

Comprehensive MySQL Fundamentals and Advanced Topics Overview

This extensive guide covers MySQL fundamentals and advanced concepts, including storage engines, data types, indexes, transactions, isolation levels, locking mechanisms, views, stored procedures, triggers, SQL optimization techniques, replication, backup strategies, and sharding approaches for high‑availability and scalability.

MySQLTransactionsdatabase-fundamentals
0 likes · 73 min read
Comprehensive MySQL Fundamentals and Advanced Topics Overview
Efficient Ops
Efficient Ops
Aug 15, 2019 · Fundamentals

Master SQL SELECT: 10 Steps to Understand Execution Order and Joins

This comprehensive guide explains how SQL's declarative nature, the mismatch between syntax and execution order, table references, various join types, derived tables, GROUP BY behavior, and key keywords like DISTINCT, UNION, ORDER BY, and OFFSET work together to help readers master SELECT statements.

JoinsSQLdatabase-fundamentals
0 likes · 20 min read
Master SQL SELECT: 10 Steps to Understand Execution Order and Joins
Java Captain
Java Captain
Oct 6, 2018 · Databases

Exploring MySQL Database Fundamentals and Indexing Principles

This article examines MySQL database fundamentals, including storage architecture, block-based data access, disk I/O bottlenecks, and detailed explanations of B+Tree and hash indexes in MyISAM and InnoDB, while offering practical guidance on index design, selectivity, left‑most prefix rules, and using EXPLAIN for SQL optimization.

B+TreeEXPLAINIndexing
0 likes · 11 min read
Exploring MySQL Database Fundamentals and Indexing Principles