Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases
About this ebook
- 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
- 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
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.
About the author
Alkin Tezuysal is EVP of Global Services at ChistaDATA Inc. He has extensive experience in open-source relational databases, working in various sectors and large functions. With over three decades of industry experience, he has led global operations teams for MySQL customers and users. He's a known speaker at worldwide open-source database events. He was awarded Most Influential in Database Community 2022 by The Redgate 100. He has co-authored MySQL Cookbook, 4th Edition 2022, by O'Reilly Media, Inc. He was awarded MySQL Rockstar 2023 - Oracle (MySQL Community).
Ibrar Ahmed is an accomplished principal engineer at Percona LLC with over 23 years of experience in designing and developing software. He is a renowned expert in the field of the PostgreSQL core database engine, having contributed significantly to open source development. His extensive knowledge and expertise have led to the implementation of major performance feature enhancements and the development of various PostgreSQL modules. Apart from his specialization in PostgreSQL, Ibrar has a wealth of experience working with other prominent databases, including MySQL, Oracle, and NoSQL databases such as MongoDB and Hadoop. He is also well-versed in tools related to databases, such as Hive, HBase, and Spark.
