Learning PostgreSQL 10, 2nd Ed (Packt)
Learning PostgreSQL 10, 2nd Ed (Packt)
Thursday, 19 April 2018

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

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.

 

Banner
 


Optimized C++

Author:  Kurt Guntheroth
Publisher: O'Reilly
Pages: 388 
ISBN:  978-1491922064
Print: 1491922060
Kindle: B01EVXNWLK
Audience: Experienced C++ programmers
Rating: 5
Reviewer: Mike James

If you think that the one rule about optimization is don't do it then you s [ ... ]



Common Information Models for an Open, Analytical and Agile World

Authors: Mandy Chessell, Gandhi Sivakumar, Dan Wolfson, Kerard Hogg and Ray Harishankar
Publisher: IBM Press
Pages: 240
ISBN: 978-0133366150
Print: 0133366154
Kindle: B00VVG07IM
Aimed at: Enterprise architects
Rating: 4
Reviewer: Kay Ewbank

Can Common Information Mod [ ... ]


More Reviews

 
 

   
Banner
Banner
RSS feed of all content
I Programmer - full contents
Copyright © 2018 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.