توضیحات
Written by Hans-Jürgen Schönig, this book is designed for developers, DBAs, and data engineers who want to harness the full power of PostgreSQL 17, one of the most advanced open-source relational databases. It combines conceptual explanations with hands-on tutorials, covering modern PostgreSQL features, real-world use cases, and performance best practices.
Key topics include:
Database Design and Modeling: Advanced relational design, normalization, and schema management.
SQL and Query Optimization: Writing efficient queries, using indexes, and understanding execution plans.
New Features in PostgreSQL 17: Latest enhancements in JSON handling, partitioning, and indexing.
Stored Procedures and Functions: Creating reusable logic with PL/pgSQL and other procedural languages.
Transactions and Concurrency: Managing ACID properties, isolation levels, and locking mechanisms.
Security and Access Control: Roles, privileges, authentication, and data encryption.
Backup and Recovery: Strategies for disaster recovery, replication, and high availability.
Performance Tuning: Monitoring, analyzing, and optimizing database performance.
Advanced Data Types: Working with arrays, JSON, XML, and geometric types.
Integration and Extensions: Using PostGIS, full-text search, and other PostgreSQL extensions.
Practical Administration: Automating tasks, monitoring, and maintaining large-scale databases.
By completing this book, readers will gain in-depth knowledge of PostgreSQL 17, enabling them to design, manage, and optimize production-grade databases for high-performance and scalable applications.










نقد و بررسیها
هنوز بررسیای ثبت نشده است.