Tag

database fundamentals

0 views collected around this technical thread.

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.

SQLdatabase fundamentalsjoins

0 likes · 20 min read

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

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