Książka Database Essentials for Web Developers YOO BYUNG HONG

Database Essentials for Web Developers

A Practical Guide to RDBMS, SQL, MySQL, PostgreSQL, Oracle, Indexing, and Tuning

Język: Angielski
Oprawa: Miękka
Dostępność: Dostępna u dostawcy
Wysyłamy za 9-15 dni
116.55
The Database Book Written for Developers, Not DBAsYou write SQL every day, but do you really underst...

Informacje o książce

Język
Angielski
Oprawa
Książka - Miękka
Data wydania
2026
strony
160
EAN
9798252993843
Enbook ID
51520195
Waga
225
Wymiary
152 x 229 x 9

Pełny opis

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 DB
  • Part 2 - MySQL/MariaDB architecture, storage engines, and essential configuration
  • Part 3 - Why PostgreSQL is special, and a head-to-head comparison with MySQL
  • Part 4 - Oracle architecture, licensing reality, and Tibero migration guide
  • Part 5 - Index design, reading execution plans, transactions and lock management
  • Part 6 - Backup strategies, connection pooling, and session management

Who This Book Is For:

  • Web developers who use databases daily but want deeper understanding
  • Backend engineers preparing for system design interviews
  • Developers migrating between Oracle, MySQL, PostgreSQL, or Tibero
  • Anyone 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.