Title: PostgreSQL 15 Cookbook: Efficient data management with 100+ recipes (English Edition)
Publisher: BPB Publications
Publication Date: 2024
Language: English
ISBN 10: 9355516614
ISBN 13: 9789355516619
Binding: Soft cover
Condition: New

About this title

Synopsis

Level up database administration with PostgreSQL 15 recipes for mastery

Key Features

● Explore PostgreSQL 15 through 100 plus practical recipes, gaining expertise in monitoring, logging, and migration.

● Master cloud setup, scaling, and PostgreSQL 15 resource management in the cloud.

● Enhance database efficiency, streamline backup, and recovery for administration.

Description

PostgreSQL 15 is a powerful, open-source database system known for its reliability, flexibility, and advanced features. It stores and manages data efficiently, making it ideal for everything from personal projects to large-scale applications.

Get started with installation, configuration, and user management. Learn the basics of tables, views, and functions. Deploy your database securely on AWS, migrate seamlessly from other systems, and explore replication for high availability. Write efficient SQL queries, optimize performance, and safeguard your information with backups and recovery techniques. Control user access, implement robust security measures, and monitor your database health for proactive troubleshooting. Solve common errors and optimize performance, Practical tips and real-world scenarios provide a hands-on learning experience, making it easy to apply new knowledge.

By the end of this book, you will have the confidence and skills to manage data like a pro, tackle challenges with ease, and unleash the full potential of PostgreSQL 15.

What you will learn

● To setup, configure, and manage users with expertise.

● Scale your database to the cloud securely and migrate seamlessly.

● Protect your data, recover from unexpected events.

● Control access, implement robust security measures, and monitor your database's health.

● Troubleshooting, problem-solving, and fixing common errors.

Who this book is for

This book is for aspiring students, IT professionals, database administrators, and solution architects looking to enhance their database management skills.

Table of Contents

1. Up and Running with PostgreSQL 15

2. Database Hierarchy

3. Cloud Provisioning

4. Migration

5. Transaction Log

6. Partitioning and Sharding

7. Replication and High Availability

8. Leveraging SQL

9. Server Controls and Auditing

10. Backup

11. Recovery

12. Monitoring and Diagnosis

13. Troubleshooting

About the Author

Mohammad Samsad Hussain is based in Malaysia. He is a Database Architect and consultant with more than 13 years of experience in different roles (Data Analyst, Database Solution Architect, Application Consultant) among software industries. He is an IBM DB2 DBA Certified Professional and PostgreSQL, MySQL & MariaDB database Consultant as he has worked on different technologies and architectures, such as SAP HANA, Oracle, MongoDB, MS SQL and IBMi (As400).

"About this title" may belong to another edition of this title.

Store Description

Hello! Ria Christie Collections is an online venture that was initially set up in 2012 to sell books. We do not have a physical high street store. We are professional online booksellers. We only sell brand new books in perfect condition that we source from various suppliers and the publishers. Primarily, our aim is to provide an excellent service to all our customers. We always work as a team to achieve this. Our other objectives are to: 1. Ensure that all our products reach their destination quickly in a safe and secure manner 2. Answer to all our customer queries within 24 hours 3. Ensure that our customers are happy with their purchases 4. Provide all the items at a competitive price 5. Always listen to our customers Ria Christie Collections is not a registered company. It is a Sole Trader venture. Other key information is shown below: Contact Person Name: Rakesh Luchmun (Mr) Storefront Name: Ria Christie Collections Place of Establishment Address: Suite B; ARUN House; ARUN Building Arundel Road Uxbridge UB8 2RR United Kingdom E-Mail Address: riachristie@hotmail.co.uk VAT Number: GB 160 5650 25 We always work hard and aim to comply with all of Abebooks Policies. If you have any issues, please do not hesitate to write to us whether before or after a purchase. We promise to reply to you promptly and, in any case, within 24 hours. Thank you kindly! Yours sincerely Mr Rakesh Luchmun (Founder) and the Ria Christie Collections Team

Visit Seller's Storefront

Seller's business information

Ryefield Investments Limited
175 Pield Heath Road, Uxbridge, UB8 3NL, United Kingdom

Sale & Shipping Terms

Terms of Sale

All Returns and Refund are as per Abebooks policies.

Shipping Terms

Orders usually ship within 2 business days. If your book order is heavy or oversized, we may contact you to let you know extra shipping is required. Thank you!