PostgreSQL for Jobseekers
(ebook)
(audiobook)
(audiobook)
- Wydawnictwo:
- BPB Publications
- Ocena:
- Stron:
- 314
- Dostępne formaty:
-
ePubMobi
Czytaj fragment
Opis
książki
:
PostgreSQL for Jobseekers
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
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
BPB Publications - inne książki
Dzięki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep@helion.pl
Proszę wybrać ocenę!
Proszę wpisać opinię!
Książka drukowana
Proszę czekać...
Oceny i opinie klientów: PostgreSQL for Jobseekers Sonia Valeja, David Gonzalez (0) Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.