Learning PostgreSQL

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



Bookstore > Books > Learning PostgreSQL

Price$31.51 - $63.63
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 9

Similar Books


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 guide will te...

Price:  $40.88  |  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...

Publisher:  Self-publishing  |  Release:  2018

Deep Learning Pipeline

Deep Learning Pipeline

by Hisham El-Amir, Mahmoud Hamdy

Build your own pipeline based on modern TensorFlow approaches rather than outdated engineering concepts. This book shows you how to build a deep learning pipeline for real-life TensorFlow projects. You'll learn what a pipeline is and how it works so you can build a full application easily and rapidly. Then troubleshoot and overcome basic ...

Price:  $30.46  |  Publisher:  Apress  |  Release:  2020

Deep Learning with Python

Deep Learning with Python

by Nihkil Ketkar

Master the practical aspects of implementing deep learning solutions with PyTorch, using a hands-on approach to understanding both theory and practice. This new edition will prepare you for applying deep learning to real world problems with a sound theoretical foundation and practical know-how with PyTorch, a platform developed by Faceboo...

Price:  $32.99  |  Publisher:  Apress  |  Release:  2020

Next-Generation Machine Learning with Spark

Next-Generation Machine Learning with Spark

by Butch Quinto

Access real-world documentation and examples for the Spark platform for building large-scale, enterprise-grade machine learning applications.The past decade has seen an astonishing series of advances in machine learning. These breakthroughs are disrupting our everyday life and making an impact across every industry.Next-Generation Machine...

Price:  $26.41  |  Publisher:  Apress  |  Release:  2020

Learning TensorFlow

Learning TensorFlow

by Itay Lieder, Yehezkel Resheff, Tom Hope

Roughly inspired by the human brain, deep neural networks trained with large amounts of data can solve complex tasks with unprecedented accuracy. This practical book provides an end-to-end guide to TensorFlow, the leading open source software library that helps you build and train neural networks for computer vision, natural language proc...

Price:  $26.99  |  Publisher:  O'Reilly Media  |  Release:  2017

TensorFlow for Deep Learning

TensorFlow for Deep Learning

by Reza Zadeh, Bharath Ramsundar

Learn how to solve challenging machine learning problems with Tensorflow, Google's revolutionary new system for deep learning. If you have some background with basic linear algebra and calculus, this practical book shows you how to build - and when to use - deep learning architectures. You'll learn how to design systems capable of detecti...

Price:  $15.99  |  Publisher:  O'Reilly Media  |  Release:  2018

Machine Learning with Python Cookbook

Machine Learning with Python Cookbook

by Chris Albon

This practical guide provides nearly 200 self-contained recipes to help you solve machine learning challenges you may encounter in your daily work. If you're comfortable with Python and its libraries, including pandas and scikit-learn, you'll be able to address specific problems such as loading data, handling text or numerical data, model...

Price:  $43.62  |  Publisher:  O'Reilly Media  |  Release:  2018