Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases
Tezuysal, Alkin, Ahmed, Ibrar, Zaitsev, Peter
- 出版商: Packt Publishing
- 出版日期: 2024-07-26
- 售價: $1,650
- 貴賓價: 9.5 折 $1,568
- 語言: 英文
- 頁數: 222
- 裝訂: Quality Paper - also called trade paper
- ISBN: 1803233478
- ISBN-13: 9781803233475
-
相關分類:
MySQL、PostgreSQL、JVM 語言、SQL、資料庫
海外代購書籍(需單獨結帳)
商品描述
Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises
Key Features:
- Get to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQL
- Explore database integration with web apps, emerging trends, and real-world case studies
- Leverage practical examples and hands-on exercises to reinforce learning
- Purchase of the print or Kindle book includes a free PDF eBook
Book Description:
Database Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills you need to architect, build, and optimize efficient databases using two of the most popular open-source platforms.
As you progress through the chapters, you'll gain a deep understanding of data modeling, normalization, and query optimization, supported by hands-on exercises and real-world case studies that will reinforce your learning. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced topics will empower you to tackle complex database challenges confidently and effectively. Additionally, you'll explore emerging trends, such as NoSQL databases and cloud-based solutions, ensuring you're well-versed in the latest developments shaping the database landscape. By embracing these cutting-edge technologies, you'll be prepared to adapt and innovate in today's ever-evolving digital world.
By the end of this book, you'll be able to understand the technologies that exist to design a modern and scalable database for developing web applications using MySQL and PostgreSQL open-source databases.
What You Will Learn:
- Design a schema, create ERDs, and apply normalization techniques
- Gain knowledge of installing, configuring, and managing MySQL and PostgreSQL
- Explore topics such as denormalization, index optimization, transaction management, and concurrency control
- Scale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategies
- Integrate databases with web apps, use SQL, and implement best practices
- Explore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and ML
Who this book is for:
This book is for a wide range of professionals interested in expanding their knowledge and skills in database design and modeling with PostgreSQL and MySQL. This includes software developers, database administrators, data analysts, IT professionals, and students. While prior knowledge of MySQL and PostgreSQL is not necessary, some familiarity with at least one relational database management system (RDBMS) will help you get the most out of this book.
Table of Contents
- SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs
- Building a Strong Foundation for Database Design
- Getting Your Hands Dirty with PostgreSQL and MySQL
- Mastering the Building Blocks of Database Design and Modeling
- Advanced Techniques for Advanced Databases
- Understanding Database Scalability
- Best Practices for Building and Maintaining Your Database
- The Future of Databases and Their Designs
商品描述(中文翻譯)
成為資料庫建模和 SQL 優化的專家，並透過實際範例和練習深入了解交易系統。
主要特色：
- 從基礎到進階，掌握 PostgreSQL 和 MySQL 的資料庫設計和建模概念。
- 探索資料庫與網頁應用程式的整合、新興趨勢和真實案例研究。
- 利用實際範例和動手練習來加強學習效果。
- 購買印刷版或 Kindle 版書籍可獲得免費 PDF 電子書。
書籍描述：
《PostgreSQL 和 MySQL 的資料庫設計與建模》將為您提供架構、建設和優化高效資料庫所需的知識和技能，使用兩個最受歡迎的開源平台。隨著您逐章進行，您將深入了解資料建模、正規化和查詢優化，並透過動手練習和真實案例研究來加強學習。您將探索如併發控制、備份和恢復策略，以及與網頁和行動應用程式的無縫整合等主題。這些進階主題將使您能夠自信且有效地應對複雜的資料庫挑戰。此外，您還將探索新興趨勢，如 NoSQL 資料庫和雲端解決方案，確保您熟悉塑造資料庫領域的最新發展。透過掌握這些尖端技術，您將能夠在當今不斷演變的數位世界中適應和創新。
在本書結束時，您將能夠理解設計現代且可擴展的資料庫所需的技術，以便使用 MySQL 和 PostgreSQL 開發網頁應用程式。
您將學到的內容：
- 設計架構、創建 ERD 並應用正規化技術。
- 獲得安裝、配置和管理 MySQL 和 PostgreSQL 的知識。
- 探索如反正規化、索引優化、交易管理和併發控制等主題。
- 透過分片、複製和負載平衡來擴展資料庫，並實施備份和恢復策略。
- 將資料庫與網頁應用程式整合，使用 SQL 並實施最佳實踐。
- 探索新興趨勢，包括 NoSQL 資料庫和雲端資料庫，同時了解 AI 和 ML 的影響。
本書適合對擴展 PostgreSQL 和 MySQL 資料庫設計與建模知識和技能感興趣的各類專業人士，包括軟體開發人員、資料庫管理員、資料分析師、IT 專業人員和學生。雖然不需要具備 MySQL 和 PostgreSQL 的先前知識，但對至少一種關聯資料庫管理系統 (RDBMS) 的熟悉將有助於您充分利用本書。
目錄：
- SQL 和 NoSQL 資料庫：特性、設計和權衡
- 建立資料庫設計的堅實基礎
- 動手操作 PostgreSQL 和 MySQL
- 精通資料庫設計和建模的基礎構件
- 進階資料庫的進階技術
- 理解資料庫的可擴展性
- 建立和維護資料庫的最佳實踐
- 資料庫及其設計的未來
