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
 


Programming in C (4e)

Author: Stephen G. Kochan
Publisher: Addison Wesley
Pages: 600
ISBN: 978-0321776419
Print: 0321776410
Kindle: B00MTUNHDQ
Audience: Newcomers to C
Rating: 4
Reviewer: Alex Armstrong

 

Learning to program in C - is this book a good approach?



Python: An Introduction to Programming

Author: J R Parker
Publisher: Mercury Learning & Information
Pages:600
ISBN: 978-1944534653
Print: 1944534652
Kindle:B01N0DRA28
Audience: Science students 
Rating: 4
Reviewer: Alex Armstrong

There are lots of books on Python, so why another?


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.