You're reading from Database Design and Modeling with PostgreSQL and MySQL Build efficient and scalable databases for modern applications using open source databases

Product type Paperback

Published in Jul 2024

Publisher Packt

ISBN-13 9781803233475

Length 222 pages

Edition 1st Edition

Languages

SQL

Tools

MySQL

Concepts

Artificial Intelligence

Authors (2):

Alkin Tezuysal

Ibrar Ahmed

View More author details

Table of Contents (16) Chapters

Preface

1. Part 1: Introduction to Databases

2. Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs FREE CHAPTER

3. Chapter 2: Building a Strong Foundation for Database Design

4. Part 2: Practical Implementation

5. Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL

6. Part 3: Core Concepts in Database Design

7. Chapter 4: Mastering the Building Blocks of Database Design and Modeling

8. Part 4: Advanced Database Techniques

9. Chapter 5: Advanced Techniques for Advanced Databases

10. Chapter 6: Understanding Database Scalability

11. Part 5: Best Practices and Future Trends

12. Chapter 7: Best Practices for Building and Maintaining Your Database

13. Chapter 8: The Future of Databases and Their Designs

14. Index

Why subscribe?

15. Other Books You May Enjoy

To get the most out of this book

Before diving into this book, it is helpful to have a basic understanding of database concepts and some familiarity with SQL. While no prior experience with PostgreSQL or MySQL is necessary, a general knowledge of relational databases will allow you to grasp the more advanced topics. Additionally, having basic proficiency in any programming language will be advantageous as we explore practical examples and database interactions.

Software/hardware covered in the book	Operating system requirements
MySQL 8.X or higher	Windows, macOS, or Linux
PostgreSQL 15.X or higher	Windows, macOS, or Linux

If you are using the digital version of this book, we advise you to type the code yourself or access the code from the book’s GitHub repository (a link is available in the next section). Doing so will help you avoid any potential errors related to the copying and pasting of code.

The rest of the chapter is locked

You're reading from Database Design and Modeling with PostgreSQL and MySQL Build efficient and scalable databases for modern applications using open source databases

Table of Contents (16) Chapters

To get the most out of this book

Authors (3)

Personalised recommendations for you

You're reading from Database Design and Modeling with PostgreSQL and MySQL Build efficient and scalable databases for modern applications using open source databases

Table of Contents (16) Chapters

To get the most out of this book

Unlock this book and the full library FREE for 7 days

Authors (3)

Personalised recommendations for you