Database Design and Modeling with PostgreSQL and MySQL

eBook Details:

• Paperback: 222 pages
• Publisher: WOW! eBook (July 26, 2024)
• Language: English
• ISBN-10: 1803233478
• ISBN-13: 978-1803233475

eBook Description:

Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases. Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercises.

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.

• 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

By the end of this Database Design and Modeling with PostgreSQL and MySQL 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.