Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Database Design and Modeling with PostgreSQL and MySQL

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

Arrow left icon
Product type Paperback
Published in Jul 2024
Publisher Packt
ISBN-13 9781803233475
Length 222 pages
Edition 1st Edition
Languages
Tools
Arrow right icon
Authors (2):
Arrow left icon
Alkin Tezuysal Alkin Tezuysal
Author Profile Icon Alkin Tezuysal
Alkin Tezuysal
Ibrar Ahmed Ibrar Ahmed
Author Profile Icon Ibrar Ahmed
Ibrar Ahmed
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

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 15. Other Books You May Enjoy

Summary

In this chapter, you have journeyed through an immersive exploration of the intricate world of database design and management, emerging with a toolkit of vital skills that underscore the essence of structuring efficient, reliable, and purpose-driven databases.

We began with the art of proficient database design. The chapter then initiated discussions by unfolding the transformative impacts of robust database design, emphasizing its capacity to fortify security, enrich data quality, streamline operations, and, ultimately, sustain the digital ecosystems of businesses and applications.

Then we learned about objective-oriented design – the strategic compass. The narrative stressed the importance of precise objectives that act as the strategic compass in the voyage of database design. These objectives, encompassing aspects such as functionality, performance, security, and scalability, serve as the foundational pillars in sculpting the database’s architecture...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime