Computing & Internet      Databases

Database Design and Modeling with PostgreSQL and MySQL: Build efficient and scalable databases for modern applications using open source databases

(0 reviews)
Paper Back
£41.98
£39.46
Condition
Quantity
(531 available)
Share
Book Details
Language
English
Publishers
Packt Publishing - ebooks Account; 1st edition (26 July 2024)
Weight
0.39 KG
Publication Date
26/07/2024
ISBN-10
1803233478
Pages
222 pages
ISBN-13
9781803233475
Dimensions
1.25 x 19.05 x 23.5 cm
SKU
9781803233475
Author Name
Alkin Tezuysal (Author)
Read More

Reviews & Ratings

out of 5.0
(0 reviews)
There have been no reviews for this product yet.
Become well-versed with database modeling and SQL optimization, and gain a deep understanding of transactional systems through practical examples and exercisesKey FeaturesGet to grips with fundamental-to-advanced database design and modeling concepts with PostgreSQL and MySQLExplore database integration with web apps, emerging trends, and real-world case studiesLeverage practical examples and hands-on exercises to reinforce learningPurchase of the print or Kindle book includes a free PDF eBookBook DescriptionDatabase 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. What you will learnDesign a schema, create ERDs, and apply normalization techniquesGain knowledge of installing, configuring, and managing MySQL and PostgreSQLExplore topics such as denormalization, index optimization, transaction management, and concurrency controlScale databases with sharding, replication, and load balancing, as well as implement backup and recovery strategiesIntegrate databases with web apps, use SQL, and implement best practicesExplore emerging trends, including NoSQL databases and cloud databases, while understanding the impact of AI and MLWho this book is forThis 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.

Table of ContentsSQL and NoSQL Databases: Characteristics, Design, and Trade-OffsBuilding a Strong Foundation for Database DesignGetting Your Hands Dirty with PostgreSQL and MySQLMastering the Building Blocks of Database Design and ModelingAdvanced Techniques for Advanced DatabasesUnderstanding Database ScalabilityBest Practices for Building and Maintaining Your DatabaseThe Future of Databases and Their Designs. .

Frequently Bought Products

Product Queries (0)

Login Or Registerto submit your questions to seller

Other Questions

No none asked to seller yet

Bookiyos Books Solutions - Quality Books, Unbeatable Prices

Bookiyos Books Solutions is your premier online bookstore offering a vast selection of over 5 crore books. Whether you're looking for the latest releases, timeless classics, or rare finds, we have something for every reader. Our platform serves customers worldwide, including the USA, UK, and Europe, with fast delivery and easy return policies to ensure a hassle-free shopping experience. Discover daily updates, exclusive deals, and a comprehensive collection of books that cater to all your reading needs. Shop with confidence at Bookiyos, where quality books and unbeatable prices meet.

Why Choose Bookiyos?

Extensive Inventory: New, old, and rare books available.
Fast Delivery: Same or next-day shipping.
Easy Returns: Hassle-free refund and return policies.
Global Reach: Serving customers in the USA, UK, Europe, and beyond.
Daily Updates: Thousands of new titles added every day.
Join our community of book lovers and start your literary journey with Bookiyos Books Solutions today!