Деталі електронної книги

Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases

Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases

Alkin Tezuysal, Ibrar Ahmed, Peter Zaitsev

Eлектронна книга
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.
  • 1. SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs
  • 2. Building a Strong Foundation for Database Design
  • 3. Getting Your Hands Dirty with PostgreSQL and MySQL
  • 4. Mastering the Building Blocks of Database Design and Modeling
  • 5. Advanced Techniques for Advanced Databases
  • 6. Understanding Database Scalability
  • 7. Best Practices for Building and Maintaining Your Database
  • 8. The Future of Databases and Their Designs
  • Назва: Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases
  • Автор: Alkin Tezuysal, Ibrar Ahmed, Peter Zaitsev
  • Оригінальна назва: Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases
  • ISBN: 9781803240961, 9781803240961
  • Дата видання: 2024-07-26
  • Формат: Eлектронна книга
  • Ідентифікатор видання: e_3yqj
  • Видавець: Packt Publishing