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
 


Designing with Data, 2nd Edition

Author: Rochelle King, Elizabeth F Churchill, and Caitlin Tan
Publisher: O'Reilly
Pages: 370
ISBN: 978-1449334833
Print: 1449334830
Kindle: B06XY9TTN8
Audience: Data developers
Rating: 4
Reviewer: Kay Ewbank

 

This book looks at how you can use data-driven A/B testing for making design d [ ... ]



The Fourth Industrial Revolution

Author: Klaus Schwab
Publisher: The Fourth Industrial Revolution
Pages: 198
ISBN: 978-1944835002
Print: 1944835008
Kindle: B01AIT6SZ8
Audience: Everyone
Rating: 4.5
Reviewer: Ian Stirk

Our final selection from the book reviews of 2016 aims to be a primer on the fourth industrial revolu [ ... ]


More Reviews

 
 

   
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.