This book will familiarize you with the latest new features released in PostgreSQL 10, and get you up and running with building efficient PostgreSQL database solutions from scratch. Author Salahaldin Juba gives a thorough introduction to PostgreSQL and the new features introduced in PostgreSQL 10. Data Definition Language (DDL) is covered with an emphasis on PostgreSQL, as is Data Manipulation Language (DML) and PostgreSQL server-side programming capabilities using PL/pgSQL. The book also explores the NoSQL capabilities of PostgreSQL.

<ASIN:1788392019>

By the end of this book, you'll have a thorough understanding of the basics of PostgreSQL10 and will have the necessary skills to build efficient database solutions.

Author: Salahaldin Juba
Publisher: Packt
Date: Dec 2017
Pages: 488
ISBN: 978-1788392013
Print: 1788392019
Kindle: B077NQGV1G
Audience: Postgre SQL developers
Level: Intermediate
Category: Database

• Understand the fundamentals of relational databases, relational algebra, and data modeling
• Install a PostgreSQL cluster, create a database, and implement your data model
• Create tables and views, define indexes, and implement triggers, stored procedures, and other schema objects
• Use the Structured Query Language (SQL) to manipulate data in the database
• Implement business logic on the server side with triggers and stored procedures using PL/pgSQL
• Make use of advanced data types supported by PostgreSQL 10: Arrays, hstore, JSONB, and others
• Develop OLAP database solutions using the most recent features of PostgreSQL 10
• Connect your Python applications to a PostgreSQL database and work with the data efficiently
• Test your database code, find bottlenecks, improve performance, and enhance the reliability of the database applications

Purchase direct from Packt - PostgreSQL 10 High Performance

For more Book Watch just click.

Book Watch is I Programmer's listing of new books and is compiled using publishers' publicity material. It is not to be read as a review where we provide an independent assessment. Some, but by no means all, of the books in Book Watch are eventually reviewed.

To have new titles included in Book Watch contact  BookWatch@i-programmer.info

Follow @bookwatchiprog on Twitter or subscribe to I Programmer's Books RSS feed for each day's new addition to Book Watch and for new reviews.