Database Design and Modeling with PostgreSQL and MySQL
Packt Publishing Limited (Verlag)
978-1-80323-347-5 (ISBN)
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, hands-on exercises, and analyze real-world case studies to reinforce learning
Purchase of the print or Kindle book includes a free PDF eBook
Book DescriptionDatabase Design and Modeling with PostgreSQL and MySQL will equip you with the knowledge and skills 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 and provide valuable practical experience. You'll explore topics like concurrency control, backup and recovery strategies, and seamless integration with web and mobile applications. These advanced discussions will empower you to tackle complex database challenges confidently and effectively.
But that's not all – you’ll also explore emerging trends like 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 well prepared to adapt and innovate in today's ever-evolving digital world.
By the end of this book, you will be able to design a useful, modern, scalable database to make a web application using MySQL and PostgreSQL open-source databases.What you will learn
Design a schema, create ERDs, and apply normalization techniques
Gain practical knowledge of installing, configuring, and managing MySQL and PostgreSQL
Delve into topics such as denormalization, index optimization, transaction management and concurrency control
Scale databases with sharding, replication, load balancing, and implement backup and recovery strategies
Integrate databases with web apps, utilize SQL effectively and implement best practices
Explore emerging trends, including NoSQL databases, cloud databases, and the impact of AI and machine learning
Who this book is forThis 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 follow along.
Alkin Tezuysal has extensive experience in open-source relational databases, working in various sectors for large corporations. With over 28 years of industry experience, he has acquired skills for managing large projects from the ground up to production. For the past decade, he's been focused on e-commerce, SaaS, and MySQL technologies. Alkin has managed and architected database topologies for high-volume sites. He has several years of experience in 24X7 support, operational tasks, and improving database systems for major companies. He has led global operations teams on Tier 1/2/3 support for MySQL customers. He holds the EVP - Global Services position at fast-growing startup ChistaDATA Inc. In the year 2022, he's appointed 100 top open-source database influencers worldwide. He's also co-authored the MySQL Cookbook 4th Edition Ibrar Ahmed is an accomplished Principle Engineer at Percona LLC with over 23 years of experience in designing and developing software. He is a renowned expert in the field of 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 like MongoDB and Hadoop. He is also well-versed in tools related to databases such as Hive, HBase, and Spark
Table of Contents
SQL and NoSQL Databases
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
Future of Databases and Their Designs
Erscheinungsdatum | 21.02.2024 |
---|---|
Verlagsort | Birmingham |
Sprache | englisch |
Maße | 191 x 235 mm |
Themenwelt | Informatik ► Datenbanken ► Data Warehouse / Data Mining |
Informatik ► Software Entwicklung ► User Interfaces (HCI) | |
ISBN-10 | 1-80323-347-8 / 1803233478 |
ISBN-13 | 978-1-80323-347-5 / 9781803233475 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
aus dem Bereich