This is the code repository for Database Design and Modeling with PostgreSQL and MySQL, published by Packt.

Build efficient and scalable databases for modern applications using open-source databases

This book helps you create efficient databases, covering data modeling, query optimization, and more. You’ll be equipped with the skills needed to design robust databases using PostgreSQL and MySQL for modern data-driven applications.

This book covers the following exciting features:

• 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

If you feel this book is for you, get your copy today!

All of the code is organized into folders. For example, Ch02.

The code will look like the following:

CREATE SCHEMA IF NOT EXISTS `DesignAndModeling`
DEFAULT CHARACTER SET utf8mb4;
CREATE TABLE `StudentCourses` (
    `StudentID` int unsigned NOT NULL AUTO_INCREMENT,
    `StudentNAME` varchar(45) DEFAULT NULL,
    `Courses` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`StudentID`)
) ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_0900_ai_ci

Following is what you need for this book: 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.

With the following software and hardware list you can run all code files present in the book (Chapter 1-8).

• Database Design and Modeling with Google Cloud [Packt] [Amazon]

• Mastering PostgreSQL 15 - Fifth Edition [Packt] [Amazon]

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 2022, he was appointed as one of the 100 top open-source database influencers worldwide. He has also co-authored the MySQL Cookbook, 4th Edition.

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 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.