PostgreSQL 18.6 Database Administration Handbook (The Modern Developer)

Want to build reliable databases, write better SQL queries, and get more out of PostgreSQL?

Whether you're a beginner learning database fundamentals or an experienced developer looking to strengthen your skills, this guide helps you understand PostgreSQL through practical explanations and essential techniques you can apply to real-world projects.

Inside, you'll learn how to:

• Design relational databases, manage schemas, and work with PostgreSQL data types.
• Write SQL queries using joins, subqueries, common table expressions, and window functions.
• Optimize queries and analyze execution plans to improve database performance.
• Manage transactions, concurrency, and data integrity.
• Develop functions, procedures, and triggers using PL/pgSQL.
• Work with JSON and JSONB, full-text search, partitioning, and advanced database features.
• Implement database security, manage user permissions, and protect sensitive information.
• Perform backups, recovery, replication, monitoring, and production deployment.
• Integrate PostgreSQL with applications, manage migrations, and troubleshoot database problems.

You don't just need to know how to write queries. You need to understand how to build, secure, optimize, and maintain databases that perform reliably. This guide brings these essential skills together in a structured, accessible resource you can learn from and return to whenever you need practical guidance.

Ready to strengthen your PostgreSQL skills and take your database knowledge further? Get your copy today and start building your confidence, one database at a time.