×
Dodano do koszyka:
Pozycja znajduje się w koszyku, zwiększono ilość tej pozycji:
Zakupiłeś już tę pozycję:
Książkę możesz pobrać z biblioteki w panelu użytkownika
Pozycja znajduje się w koszyku
Przejdź do koszyka

Zawartość koszyka

ODBIERZ TWÓJ BONUS :: »

PostgreSQL for Jobseekers

(ebook) (audiobook) (audiobook) Książka w języku angielskim
Ocena:
Bądź pierwszym, który oceni tę książkę
Stron:
314
Dostępne formaty:
     ePub
     Mobi
Czytaj fragment
A practical guide that will help you learn and leverage PostgreSQL's core features

Key Features
Acquire in-depth knowledge of PostgreSQL's key capabilities and gain a comprehensive understanding of its inner workings.
Discover the art of extending PostgreSQL's core features and effectively troubleshooting any challenges that may arise.
Explore the vibrant community and open-source ecosystem that forms the foundation of PostgreSQL's development and innovation.

Description
PostgreSQL is a powerful open-source relational database management system (RDBMS) that is widely used in the industry. If you are seeking to acquire knowledge about PostgreSQL, this book is for you.

This comprehensive book provides you with a solid foundation in working with PostgreSQL, a popular open-source database management system. It covers a broad spectrum of topics, allowing you to successfully install and configure PostgreSQL across various platforms and methods. By delving into the internal components that constitute a PostgreSQL service and their interplay, you will gain a deep understanding of how these elements collaborate to deliver a robust and dependable solution. From comprehending the process model and shared memory to mastering query execution and optimization, you will acquire comprehensive knowledge of PostgreSQL's internal workings. Furthermore, the book explores essential tasks performed by a database administrator (DBA), including backup and restore operations, security measures, performance tuning, and troubleshooting techniques. Lastly, it explores widely used extensions and compatible tools that can enhance the functionality of PostgreSQL.

Upon completing this book, you will have developed a comprehensive understanding of the internal components that comprise a PostgreSQL service and their collaborative dynamics, resulting in a reliable and robust solution.

What you will learn
Gain proficiency in installing and preparing PostgreSQL for various methods and platforms.
Develop a solid understanding of the internal components of a PostgreSQL service and their collaborative dynamics to deliver a comprehensive solution.
Acquire knowledge about essential tasks performed by PostgreSQL DBAs, including backup/restore operations, security measures, tuning, and troubleshooting.
Explore popular extensions and compatible tools that can expand and enhance the capabilities of PostgreSQL.
Discover the PostgreSQL Community and learn how to actively contribute to the project's development and growth.

Who this book is for
This book is highly recommended for Entry Level Database Administrators, as it provides a suitable starting point for their journey. It assumes some prior knowledge of Database Management Systems (DBMS) to ensure a smooth learning experience. Additionally, senior or experienced developers will find value in this book, particularly in gaining insights into the latest features incorporated in the most recent version of the DB, enhancing their understanding and proficiency in its use.

Table of Contents
1. Introduction to Opensource Database - PostgreSQL
2. Getting PostgreSQL to work
3. Modern Options to get PostgreSQL
4. Global Objects in PostgreSQL
5. Architecture of PostgreSQL
6. PostgreSQL Internals
7. Backup and Restore in PostgreSQL
8. Replicating Data
9. Security and Access Control
10. Most used Extensions/Tools
11. Basic Database Objects
12. Advance Database Objects
13. Performance Tuning
14. Troubleshooting
15. Contributing to PostgreSQL Community

Wybrane bestsellery

O autorze książki

David Gonzalez is a language agnostic Software Engineer working within financial services for a number of years trying to find solutions on the right level of abstraction learning how to get the right balance between “too concrete” and “too abstract”.

He studied in Spain but soon moved to a wider and interesting market, Dublin where he lives since 2011 and currently working in CurrencyFair as a Senior Engineer.

He also loves experiencing with new technologies and paradigms in order to get a wider picture of the complex world of software development.

To my wife Ester, for the unconditional support on every single day of my life.

BPB Publications - inne książki

Zamknij

Przenieś na półkę

Proszę czekać...
ajax-loader

Zamknij

Wybierz metodę płatności

Ebook
80,91 zł
Dodaj do koszyka
Zamknij Pobierz aplikację mobilną Ebookpoint