Learning PostgreSQL : create, develop, and manage relational databases in real-world applications using PostgreSQL / Salahaldin Juba, Andrey Volkov, Achim Vannahme.

Includes index.

Online resource; title from cover page (Safari, viewed January 11, 2016).

If you are a student, database developer, or administrator, interested in developing and maintaining a PostgreSQL database, then this book is for you. No knowledge of database programming or administration is necessary.

PostgreSQL is one of the most powerful and easy-to-use database management systems. It supports the most advanced features included in the SQL standards. The book starts with an intruduction to relational databases with PostgreSQL. It then moves on to cover data definition language (DDL), with an emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn data manipulation language (DML) and advanced topics such as locking and performance tuning. This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database, such as creating tables, setting up integrity constraints, building indexes, defining views, and other schema objects. Next, it will give you an overview of the NoSQL capabilities of PostgreSQL, along with Hstore, XML, JSON and arrays. By the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework.

eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - Worldwide