- Learning PostgreSQL
- Table of Contents
- Learning PostgreSQL
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Relational Databases
- 2. PostgreSQL in Action
- 3. PostgreSQL Basic Building Blocks
- 4. PostgreSQL Advanced Building Blocks
- 5. SQL Language
- SQL fundamentals
- Querying the data with the SELECT statement
- Changing the data in the database
- Summary
- 6. Advanced Query Writing
- 7. Server-Side Programming with PL/pgSQL
- 8. PostgreSQL Security
- 9. The PostgreSQL System Catalog and System Administration Functions
- The system catalog
- Getting the database cluster and client tools version
- Terminating and canceling user sessions
- Setting and getting database cluster settings
- Getting the database and database object size
- Cleaning up the database
- Cleaning up data in the database
- Managing database locks
- Adding missing indexes on foreign keys and altering the default statistic
- Getting the views dependency tree
- Summary
- 10. Optimizing Database Performance
- 11. Beyond Conventional Data types
- 12. Testing
- 13. PostgreSQL JDBC
- 14. PostgreSQL and Hibernate
- Introduction to ORM and Hibernate
- Installation and configuration
- Working with entities
- Summary
- Index
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.