#DB
13 articles
10 Books for Learning Databases (SQL, Design, and Operations)
A staged reading list of 10 books for learning databases, from SQL basics to design and operations: SQL basics, deeper SQL, design, PostgreSQL, and distributed data. Each entry links to its full review.
Characteristics and Design of Nontemporal, Unitemporal, and Bitemporal
Exploring the features, design examples, advantages, and disadvantages of different temporal data models.
Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications
A review of Practical Introduction to Redis. A book that broadly covers Redis from its mechanisms to real-world use and operations. Valuable amid a scarcity of Japanese Redis books, it even digs into internals. One to keep at hand for whenever you get stuck with Redis.
PostgreSQL Comprehensive Guide, 4th Edition: From Installation to Features, Mechanisms, Application Development, Management, and Operations
A review of PostgreSQL Comprehensive Guide, 4th Edition. An introductory book spanning installation, features and mechanisms, application development, and management and operations. Just right for those new to PostgreSQL, it covers the basics with application examples.
A Comprehensive Guide to Database Design: For Those Who Don’t Want to Stop at Beginner Level
A review of a thorough guide to database design for those who don't want to stop at the beginner level. It explains DB design systematically and clearly, covering the essentials of normalization and table design as a guide for stepping beyond the basics.
Beginning SQL, 3rd Edition
A review of Beginning SQL, 3rd Edition. An easy-to-understand SQL primer you will wish you had read early in your career, also just right for revisiting how to write basic queries and the underlying ideas, and easy to recommend to those starting out with SQL.
Practical Introduction to Databases: Efficient SQL through the Relational Model
A review of a practical introduction to databases taught from theory via the relational model. Learning databases from relational theory helps organize how you approach RDBs, grounding the principles behind efficient SQL in set theory and logic.
SQL Anti-Patterns
A review of SQL Antipatterns. A go-to classic that introduces the antipatterns you tend to fall into with databases and SQL, with clear explanations. Knowing common mistakes and how to avoid them helps with design and implementation decisions.
Mastering SQL: A Comprehensive Guide for Advanced Beginners, 2nd Edition
A review of Mastering SQL: A Comprehensive Guide for Advanced Beginners, 2nd Edition. A book for learning the varied expressions of SQL beyond the basics. Full of oh-you-can-write-it-this-way moments that expand your repertoire, it suits those who want to step beyond the beginner level.
Practical Introduction to SQL: Writing Fast and Understandable Queries
A review of Practical Introduction to SQL. A book that organizes what to keep in mind when writing SQL. Grounded in execution plans, it teaches how to write queries that are both fast and easy to read.
What is a Database Index? How It Works and When You Need It
Understand how database indexes work internally—B-tree and hash structures—when to add or avoid indexes, and how to measure index effectiveness using EXPLAIN.
Database ID Design: UUID vs Auto Increment vs ULID — Which to Choose?
Compare auto-increment integers, UUIDs, and ULIDs as database IDs. Learn the trade-offs in performance, sortability, and distributed system compatibility.
NULL in Database Design: Common Pitfalls and Best Practices
Learn how NULL works in relational databases, the three-valued logic problem, common query mistakes with NULL, and schema design strategies to avoid NULL-related bugs.