Learning PostgreSQL

Create, develop and manage relational databases in real world applications using PostgreSQL



Bookstore > Books > Learning PostgreSQL

Price$31.51 - $54.99
Rating
AuthorsSalahaldin Juba, Achim Vannahme, Andrey Volkov
PublisherPackt Publishing
Published2015
Pages464
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101783989181
ISBN-139781783989188
EBook Hardcover Paperback

PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. Also it provides NoSQL capabilities, and very rich data types and extensions. All that makes PostgreSQL a very attractive solution in various kinds of software systems.

The book starts with the introduction of relational databases with PostegreSQL. It then moves on to covering data definition language (DDL) with emphasis on PostgreSQL and common DDL commands supported by ANSI SQL. You will then learn the data manipulation language (DML), and advanced topics like locking and multi version concurrency control (MVCC). This will give you a very robust background to tune and troubleshoot your application. The book then covers the implementation of data models in the database such as creating tables, setting up integrity constraints, building indexes, defining views and other schema objects. Next, it will give you an overview about the NoSQL capabilities of PostgreSQL along with Hstore, XML, Json and arrays. Finally by the end of the book, you'll learn to use the JDBC driver and manipulate data objects in the Hibernate framework.




4 5 18

Similar Books


Machine Learning with Spark

Machine Learning with Spark

by Nick Pentreath

Apache Spark is a framework for distributed computing that is designed from the ground up to be optimized for low latency tasks and in-memory data storage. It is one of the few frameworks for parallel computing that combines speed, scalability, in-memory processing, and fault tolerance with ease of programming and a flexible, expressive, ...

Price:  $34.99  |  Publisher:  Packt Publishing  |  Release:  2015

Mastering Azure Machine Learning, 2nd Edition

Mastering Azure Machine Learning, 2nd Edition

by Christoph Korner, Marcel Alsdorf

Azure Machine Learning is a cloud service for accelerating and managing the machine learning (ML) project life cycle that ML professionals, data scientists, and engineers can use in their day-to-day workflows. This book covers the end-to-end ML process using Microsoft Azure Machine Learning, including data preparation, performing and logg...

Price:  $41.99  |  Publisher:  Packt Publishing  |  Release:  2022

Learn PostgreSQL

Learn PostgreSQL

by Luca Ferrari , Enrico Pirozzi

PostgreSQL is one of the fastest-growing open source object-relational database management systems (DBMS) in the world. As well as being easy to use, it's scalable and highly efficient. In this book, you'll explore PostgreSQL 12 and 13 and learn how to build database solutions using it. Complete with hands-on tutorials, this gui...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2020

Machine Learning Yearning

Machine Learning Yearning

by Andrew Ng

AI is transforming numerous industries. Machine Learning Yearning, a free ebook from Andrew Ng, teaches you how to structure Machine Learning projects.This book is focused not on teaching you ML algorithms, but on how to make ML algorithms work. After reading Machine Learning Yearning, you will be able to: Prioritize the most promising di...

Free ebook  |  Publisher:  Self-publishing  |  Release:  2018

Learning Swift 2 Programming, 2nd Edition

Learning Swift 2 Programming, 2nd Edition

by Jacob Schatz

Learning Swift 2 Programming is a fast-paced, hands-on introduction to writing production-quality iOS and OS X apps with Apple's programming language. Written for developers with experience in any modern language, this book explains Swift simply and clearly, using relevant examples that solve realistic problems.Author Jacob Schatz�...

Price:  $28.32  |  Publisher:  Addison-Wesley  |  Release:  2015

Learning Angular, 2nd Edition

Learning Angular, 2nd Edition

by Brad Dayley, Brendan Dayley, Caleb Dayley

Learning Angular teaches modern application development with Angular 2 and Angular 4. It begins with the basics of Angular and the technologies and techniques used throughout the book, such as key features of TypeScript, newer ES6 syntax and concepts, and details about the tools needed to write professional Angular applications.The reader...

Price:  $15.00  |  Publisher:  Addison-Wesley  |  Release:  2017

Learning Regular Expressions

Learning Regular Expressions

by Ben Forta

Regular expression experts have long been armed with an incredibly powerful tool, one that can be used to perform all sorts of sophisticated text processing and manipulation in just about every language and on every platform. That's the good news. The bad news is that for too long, regular expressions have been the exclusive property...

Price:  $29.86  |  Publisher:  Addison-Wesley  |  Release:  2018

Learning React, 2nd Edition

Learning React, 2nd Edition

by Kirupa Chinnathambi

As far as new web frameworks and libraries go, React is quite the runaway success. It not only deals with the most common problems developers face when building complex apps, it throws in a few additional tricks that make building the visuals for such apps much, much easier.What React isn't, though, is beginner-friendly and approacha...

Price:  $9.47  |  Publisher:  Addison-Wesley  |  Release:  2018