Learning PostgreSQL 11 - Third Edition

Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications

Learning PostgreSQL 11 - Third Edition

Salahadin Juba, Andrey Volkov

1 customer reviews
Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications
Packt Subscription
FREE
$9.99/m after trial
eBook
$12.80
RRP $31.99
Save 59%
Print + eBook
$39.99
RRP $39.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$12.80
$39.99
$9.99 p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start a FREE 10-day trial

Frequently bought together


Learning PostgreSQL 11 - Third Edition Book Cover
Learning PostgreSQL 11 - Third Edition
$ 31.99
$ 12.80
PostgreSQL 11 Administration Cookbook Book Cover
PostgreSQL 11 Administration Cookbook
$ 35.99
$ 14.40
Buy 2 for $27.20
Save $40.78
Add to Cart

Book Details

ISBN 139781789535464
Paperback556 pages

Book Description

PostgreSQL is one of the most popular open source database management systems in the world, and it supports advanced features included in SQL standards. This book will familiarize you with the latest features in PostgreSQL 11, and get you up and running with building efficient PostgreSQL database solutions from scratch.

Learning PostgreSQL, 11 begins by covering the concepts of relational databases and their core principles. You’ll explore the Data Definition Language (DDL) and commonly used DDL commands supported by ANSI SQL. You’ll also learn how to create tables, define integrity constraints, build indexes, and set up views and other schema objects. As you advance, you’ll come to understand Data Manipulation Language (DML) and server-side programming capabilities using PL/pgSQL, giving you a robust background to develop, tune, test, and troubleshoot your database application. The book will guide you in exploring NoSQL capabilities and connecting to your database to manipulate data objects. You’ll get to grips with using data warehousing in analytical solutions and reports, and scaling the database for high availability and performance.

By the end of this book, you’ll have gained a thorough understanding of PostgreSQL 11 and developed the necessary skills to build efficient database solutions.

Table of Contents

What You Will Learn

  • Understand the basics of relational databases, relational algebra, and data modeling
  • Install a PostgreSQL server, create a database, and implement your data model
  • Create tables and views, define indexes and stored procedures, and implement triggers
  • Make use of advanced data types such as Arrays, hstore, and JSONB
  • Connect your Python applications to PostgreSQL and work with data efficiently
  • Identify bottlenecks to enhance reliability and performance of database applications

Authors

Table of Contents

Book Details

ISBN 139781789535464
Paperback556 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

PostgreSQL 11 Administration Cookbook Book Cover
PostgreSQL 11 Administration Cookbook
$ 35.99
$ 14.40
Mastering PostgreSQL 11 - Second Edition Book Cover
Mastering PostgreSQL 11 - Second Edition
$ 31.99
$ 12.80
Learning Ansible 2.7 - Third Edition Book Cover
Learning Ansible 2.7 - Third Edition
$ 27.99
$ 5.60
Expert Python Programming - Third Edition Book Cover
Expert Python Programming - Third Edition
$ 31.99
$ 12.80
Odoo 12 Development Cookbook - Third Edition Book Cover
Odoo 12 Development Cookbook - Third Edition
$ 35.99
$ 14.40
Machine Learning with R - Third Edition Book Cover
Machine Learning with R - Third Edition
$ 31.99
$ 12.80