Database Essentials for Web Developers: A Practical Guide to RDBMS, SQL, MySQL, PostgreSQL, Oracle, Indexing, and Tuning

By YOO BYUNG HONG

The Database Book Written for Developers, Not DBAs

You write SQL every day, but do you really understand what happens behind the scenes? This book bridges the gap between "knowing SQL syntax" and "understanding databases."

What You'll Learn: Part 1 - RDBMS fundamentals, SQL syntax differences across databases, and how to choose the right DBPart 2 - MySQL/MariaDB architecture, storage engines, and essential configurationPart 3 - Why PostgreSQL is special, and a head-to-head comparison with MySQLPart 4 - Oracle architecture, licensing reality, and Tibero migration guidePart 5 - Index design, reading execution plans, transactions and lock managementPart 6 - Backup strategies, connection pooling, and session managementWho This Book Is For: Web developers who use databases daily but want deeper understandingBackend engineers preparing for system design interviewsDevelopers migrating between Oracle, MySQL, PostgreSQL, or TiberoAnyone who wants to write faster queries and design better schemas

Includes 8 architecture diagrams, 3 appendices (SQL syntax comparison, data type mapping, error message dictionary), and practical examples from real-world projects.

• Format: Paperback
• Language: English
• ISBN: B0GTDTTL2W
• ISBN13: 9798252993843
• Release Date: March 2026
• Publisher: Independently Published
• Length: 160 Pages
• Weight: 0.49 lbs.
• Dimensions: 0.3" x 6.0" x 9.0"