{"product_id":"postgresql-18-for-developers-anthony-parer-9798185805831","title":"PostgreSQL 18 for Developers: Build High-Performance Databases with SQL, Database Design, Query Optimization, JSONB, Security, Docker, Cloud Deploymen","description":"\u003cp\u003e\u003cb\u003eStill using PostgreSQL like a simple database when it can do so much more?\u003c\/b\u003e\u003cbr\u003ePostgreSQL 18 for Developers is a practical, hands-on guide designed to help you build modern, reliable, and high-performance database applications with the latest features of PostgreSQL 18. If you know SQL basics but want to design better databases, write faster queries, and create production-ready applications, this book gives you the skills to do it with confidence.\u003cbr\u003eMany developers can create tables and run simple queries, but struggle when projects become larger and more demanding. This book bridges that gap by showing you how to design efficient schemas, optimize performance, secure your data, and use PostgreSQL's advanced capabilities in real-world development.\u003c\/p\u003e\u003cp\u003eInside, you'll learn how to: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eBuild well-structured databases using modern PostgreSQL 18 best practices\u003c\/li\u003e\n\u003cli\u003eDesign schemas, relationships, constraints, and indexes that scale\u003c\/li\u003e\n\u003cli\u003eWrite efficient SQL queries, joins, subqueries, window functions, and Common Table Expressions (CTEs)\u003c\/li\u003e\n\u003cli\u003eUse PostgreSQL 18 features, including UUIDv7 support, generated columns, JSON, arrays, and advanced data types\u003c\/li\u003e\n\u003cli\u003eOptimize query performance with EXPLAIN, indexing strategies, and query tuning\u003c\/li\u003e\n\u003cli\u003eImplement transactions, concurrency control, backups, replication, and high availability\u003c\/li\u003e\n\u003cli\u003eSecure your databases with roles, permissions, authentication, and encryption\u003c\/li\u003e\n\u003cli\u003eConnect PostgreSQL to Python, Java, Node.js, and modern web applications\u003c\/li\u003e\n\u003cli\u003eBuild a complete production-ready application while applying professional database development practices\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eBy the end of this book, you'll know how to design robust databases, write efficient SQL, troubleshoot performance issues, and build scalable PostgreSQL applications that are ready for real-world deployment. Whether you're a software developer, backend engineer, database administrator, or computer science student, you'll gain practical skills you can immediately apply to professional projects.\u003cbr\u003eStop relying on basic SQL tutorials. Get your copy of PostgreSQL 18 for Developers today and start building faster, smarter, and more reliable database applications with PostgreSQL 18.\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eAuthor:\u003c\/b\u003e Anthony Parer\u003cbr\u003e\u003cb\u003eISBN-13:\u003c\/b\u003e 9798185805831\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Independently Published\u003cbr\u003e\u003cb\u003eLanguage:\u003c\/b\u003e English\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 07\/06\/2026\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 330\u003cbr\u003e\u003cb\u003eFormat:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 1.26lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 10.00h x 7.00w x 0.69d","brand":"Anthony Parer","offers":[{"title":"Paperback","offer_id":48997892587775,"sku":"9798185805831","price":30.99,"currency_code":"USD","in_stock":true}],"url":"https:\/\/www.whiterainbookhouse.com\/products\/postgresql-18-for-developers-anthony-parer-9798185805831","provider":"WR Book House","version":"1.0","type":"link"}