Books by splitShops
Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases - Paperback
$53.26
In stock
Shipping charges, applicable taxes, the final order total, and available payment methods are shown during checkout before payment. Delivery timing varies by item and fulfillment origin. Standard U.S. returns are by mail for eligible new, unopened items within 30 days of carrier delivery. Customers pay standard return shipping; there is no restocking fee. Approved refunds are issued within 5 business days after the return is received and inspected. Standard exchanges are not offered.
Cindi Book items have a flat $9.99 shipping charge. Shopify Collective items use shipping rates set by the supplier. Orders containing items from different fulfillment sources may include more than one shipping charge. Your full shipping total is shown at checkout before payment.
Return eligibility is subject to the full policy. Opened, read, or unsealed books with broken seals or visible wear are final sale. Digital downloads, gift cards, and personalized products are non-refundable. Original shipping charges are not refunded for standard returns. Contact us within 7 days of delivery about damaged, defective, or incorrect items.
by Alkin Tezuysal (Author), Ibrar Ahmed (Author), Peter Zaitsev (Foreword by)
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
Pay with
Available payment methods and your final total are shown at checkout before payment.
Clear Information Before You Order
Cindi Book is the trade name of Cindi Book LLC, a Texas-registered online-only retailer. We provide clear contact, shipping, return, and checkout information so customers can make informed purchasing decisions.
Business & Customer Care
Cindi Book LLC
2124 Cactus Ct, Keller, TX 76248
Administrative office only; no storefront or local pickup.
214-308-1733 · info@cindibook.com
Monday–Friday, 8:00 AM–5:00 PM CT
Shipping Transparency
Orders ship within the United States. Cindi Book branded titles typically arrive in 5–9 business days, including 0–2 business days of handling and 5–7 business days in transit. Supplier-fulfilled items typically arrive in 8–11 business days, including 1–3 business days of handling and 7–8 business days in transit. Business days are Monday–Friday, excluding U.S. federal holidays. Delivery estimates are not guarantees. Cindi Book items have a flat $9.99 shipping charge. Shopify Collective items use shipping rates set by the supplier. Orders containing items from different fulfillment sources may include more than one shipping charge. Your full shipping total is shown at checkout before payment.
Returns & Refunds
Standard U.S. returns are accepted for eligible new, unopened items within 30 days of carrier delivery. Returns are by mail. Customers are responsible for standard return shipping, there is no restocking fee, and standard exchanges are not offered. Once an approved return is received and inspected, the refund is issued to the original payment method within 5 business days. Damaged, defective, or incorrect items are handled at no return-shipping cost to the customer.
Return eligibility is subject to the full policy. Opened, read, or unsealed books with broken seals or visible wear are final sale. Digital downloads, gift cards, and personalized products are non-refundable. Original shipping charges are not refunded for standard returns. Contact us within 7 days of delivery about damaged, defective, or incorrect items.
Payment & Checkout
Checkout is processed securely through Shopify. Shipping charges, applicable taxes, the final order total, and available payment methods are shown before you submit payment.
Order Responsibility
Some items may ship from Cindi Book or U.S.-based publishing, manufacturing, or distribution suppliers that fulfill orders for Cindi Book. Cindi Book LLC remains the customer-service contact for order questions, delivery support, returns, and refunds.