Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Database Design and Modeling with PostgreSQL and MySQL
  • Table Of Contents Toc
Database Design and Modeling with PostgreSQL and MySQL

Database Design and Modeling with PostgreSQL and MySQL

By : Alkin Tezuysal, Ibrar Ahmed
2.7 (3)
Buy this Book
close
close
Database Design and Modeling with PostgreSQL and MySQL

Database Design and Modeling with PostgreSQL and MySQL

2.7 (3)
By: Alkin Tezuysal, Ibrar Ahmed
Buy this Book

Overview of this book

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. By the end of this 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.
Table of Contents (16 chapters)
close
close
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Download the example code files
Icon
Conventions used
Icon
Get in touch
Icon
Share Your Thoughts
Icon
Download a free PDF copy of this book
1
Part 1: Introduction to Databases
Icon
Part 1: Introduction to Databases
Lock Free Chapter
2
Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs
chevron up
Icon
Chapter 1: SQL and NoSQL Databases: Characteristics, Design, and Trade-Offs
Icon
Understanding databases and data models
Icon
Exploring the relational data model (SQL databases)
Icon
Navigating the document data model (NoSQL databases)
Icon
Applying the CAP theorem and NoSQL design choices
Icon
Managing transaction management and concurrency control in NoSQL
Icon
Analyzing the advantages and disadvantages of NoSQL databases
Icon
Summary
3
Chapter 2: Building a Strong Foundation for Database Design
Icon
Chapter 2: Building a Strong Foundation for Database Design
Icon
The importance of a solid foundation in database design
Icon
Advanced database design
Icon
Concluding thoughts
Icon
Summary
4
Part 2: Practical Implementation
Icon
Part 2: Practical Implementation
5
Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL
Icon
Chapter 3: Getting Your Hands Dirty with PostgreSQL and MySQL
Icon
Understanding the sample database
Icon
EDA and preprocessing
Icon
Summary
6
Part 3: Core Concepts in Database Design
Icon
Part 3: Core Concepts in Database Design
7
Chapter 4: Mastering the Building Blocks of Database Design and Modeling
Icon
Chapter 4: Mastering the Building Blocks of Database Design and Modeling
Icon
Understanding database objects
Icon
Database checks and constraints
Icon
Checking data quality with constraints
Icon
Database consistency and beyond
Icon
Concurrency control – managing multiple users
Icon
Summary
8
Part 4: Advanced Database Techniques
Icon
Part 4: Advanced Database Techniques
9
Chapter 5: Advanced Techniques for Advanced Databases
Icon
Chapter 5: Advanced Techniques for Advanced Databases
Icon
Creating custom views of your data
Icon
Indexing – how to find data faster
Icon
Stored procedures – reusable code for your database
Icon
Understanding CTEs
Icon
Summary
10
Chapter 6: Understanding Database Scalability
Icon
Chapter 6: Understanding Database Scalability
Icon
Introducing database scaling
Icon
Serverless databases
Icon
Summary
11
Part 5: Best Practices and Future Trends
Icon
Part 5: Best Practices and Future Trends
12
Chapter 7: Best Practices for Building and Maintaining Your Database
Icon
Chapter 7: Best Practices for Building and Maintaining Your Database
Icon
Designing for performance – optimizing database efficiency
Icon
Advanced query optimization techniques
Icon
Optimizing aggregates and GROUP BY clauses
Icon
Understanding database scaling
Icon
Ensuring database security
Icon
Exploring data encryption
Icon
Learning about data cleaning
Icon
Collaboration and documentation
Icon
Tools for monitoring PostgreSQL
Icon
Summary
13
Chapter 8: The Future of Databases and Their Designs
Icon
Chapter 8: The Future of Databases and Their Designs
Icon
Understanding vectorized search
Icon
PostgreSQL – expanding horizons
Icon
EnterpriseDB – elevating PostgreSQL for the enterprise
Icon
Introduction to columnar databases with ClickHouse
Icon
Summary
14
Index
Icon
Index
Icon
Why subscribe?
15
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Packt is searching for authors like you
Icon
Share Your Thoughts
Icon
Download a free PDF copy of this book

Summary

In this chapter, we explored the fundamental aspects of SQL and NoSQL databases, emphasizing their significance in the digital age. Databases serve as organized data repositories, with the relational data model for SQL databases and diverse models for NoSQL databases. We discussed SQL’s structured tables, robust querying through the SQL language, and support for ACID transactions. In contrast, NoSQL databases offer flexibility with various data models but require trade-offs, as per the CAP theorem. Transaction management in NoSQL follows the BASE model. We highlighted the advantages and drawbacks of NoSQL databases, such as scalability and flexibility, as well as potential challenges, such as limited standardization. This knowledge will help you make informed database choices for specific applications, setting the stage for deeper exploration in subsequent chapters.

In the following chapters, we will dive deeper into each database paradigm, exploring their data models, transaction management, query languages, and use cases. Understanding the strengths and weaknesses of both SQL and NoSQL databases will empower developers and database administrators to make informed decisions when they’re choosing the most suitable database solution for their specific application requirements.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Database Design and Modeling with PostgreSQL and MySQL
End of Chapter 2
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon