Select your country
Americas
Argentina
Brazil
Canada
Chile
Colombia
Costa Rica
Dominican Republic
Ecuador
El Salvador
Mexico
Peru
U.S.A.
Uruguay
Europe
Austria
Belgium
Croatia
Czech Republic
Denmark
Finland
France
Germany
Greece
Hungary
Ireland
Italy
Latvia
Malta
Netherlands
Norway
Poland
Portugal
Serbia
Slovakia
Slovenia
Spain
Sweden
Switzerland
United Kingdom
Rest of the world


Database Essentials for Web Developers. A Practical Guide to RDBMS, SQL, MySQL, PostgreSQL, Oracle, Indexing, and Tuning
Yoo Byung Hong (Author) · Independently published · Paperback
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 schemasIncludes 8 architecture diagrams, 3 appendices (SQL syntax comparison, data type mapping, error message dictionary), and practical examples from real-world projects.
Do you have a question about the book? Login to be able to add your own question.

