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

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.

 

 

Banner
 


Introducing SQL Server

Author: Mike McQuillan
Publisher: Apress
Pages: 388
ISBN: 978-1484214206
Print: 148421420X
Kindle: B0142D693W

Audience: Database developers
Rating: 4.0
Reviewer: Ian Stirk 

  

This book aims to get the newcomer started in SQL Server development, how does it fare?& [ ... ]



Algorithms Unlocked

Author: Thomas H. Cormen
Publisher: MIT Press, 2013
Pages: 240
ISBN: 978-0262518802
Print: 0262518805
Kindle: B00H4D1W94
Audience: General readers interested in Computer Science
Rating: 4
Reviewer: Mike James

An easy to read book about algorithms. What could be better reading for a programmer -  [ ... ]


More Reviews