Jump to content

Welcome to BeAugur

Guest Image

Welcome to BeAugur, like most online communities you must register to view or post in our community, but don't worry this is a simple free process that requires minimal information for you to signup. Be apart of BeAugur by signing in or creating an account.

  • Start new topics and reply to others
  • Subscribe to topics and forums to get email updates
  • Get your own profile page and make new friends
  • Send personal messages to other members.
  • Be a member to read hidden contents.

Postgresql - Up and Running Hd Pdf


Recommended Posts

  • Moderators

Postgresql - Up and Running Hd Pdf


PostgreSQL is a free, open-source relational database management system, known as the most successful database in the world. It has a long history dating back to 1985, started as a research project at the University of California, Berkeley. It not only supports many advanced features, but its performance can even exceed that of most databases in many application scenarios, including commercial databases. In fact, PostgreSQL has been considered one of the most popular databases in the world, one of the most admired databases by developers, and one of the databases with the strongest user demand.

PostgreSQL: Up and Running will help you understand and use PostgreSQL, an advanced database system. Not only will you learn the enterprise-level features in PostgreSQL, you will also discover that it is not only a database system, but also an excellent application platform. Through a large number of examples, this book shows you how to achieve tasks that are difficult or impossible to accomplish in other databases, fully demonstrating the powerful functions and enterprise-level features of PostgreSQL as a full-stack database.

PostgreSQL: Up and Running mainly introduces the core concepts and features of PostgreSQL 9.x and PostgreSQL 10, but it also covers some advanced features already supported in earlier versions, which are common in newer versions of commercial databases such as Oracle, SQL Server, DB2, but almost non-existent in the open-source database community, as well as PostgreSQL’s unique features. For example: ANSI-SQL syntax, external data wrapper enhancements, full-text search functions and operators, XML syntax, logical replication, LATERAL queries, enhanced JSON support, materialized views, window functions, ordinary CTE expressions, recursive CTE expressions, streaming replication, etc.

PostgreSQL: Up and Running is suitable for readers who have some experience in using relational databases, but it is not required to have used PostgreSQL. The book will compare the mechanisms used by PostgreSQL and other databases to handle the same task. If you have never used a database before, you can learn the functions and usage of PostgreSQL through this book. However, the book will not introduce too much basic knowledge about SQL or relational database theory. We recommend that you read other related books to understand these contents. In short, PostgreSQL: Up and Running is a practical PostgreSQL quick start guide that can help readers quickly learn, understand and use this great database.

  • Learn basic administration tasks such as role management, database creation, backup, and restore
  • Apply the psql command-line utility and the pgAdmin graphical administration tool
  • Explore PostgreSQL tables, constraints, and indexes
  • Learn powerful SQL constructs not generally found in other databases
  • Use several different languages to write database functions
  • Tune your queries to run as fast as your hardware will allow
  • Query external and variegated data sources with foreign data wrappers
  • Learn how to use built-in replication to replicate data

Table Of Contents
1. The Basics
2. Database Administration
3. psql
4. Using pgAdmin
5. Data Types
6. Tables, Constraints, and Indexes
7. SQL: The PostgreSQL Way
8. Writing Functions
9. Query Performance Tuning
10. Replication and External Data
A. Installing PostgreSQL
B. PostgreSQL Packaged Command-Line Tools

Download | ENGLISH | PDF | 4.10 MB


This is the hidden content, please

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Write what you are looking for and press enter or click the search icon to begin your search