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
New Release!

Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications
Packt Subscription
FREE
$9.99/m after trial
eBook
$22.40
RRP $31.99
Save 29%
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
$22.40
$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
$ 22.40
Mastering PostgreSQL 11 - Second Edition Book Cover
Mastering PostgreSQL 11 - Second Edition
$ 31.99
$ 22.40
Buy 2 for $44.80
Save $19.18
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

Read More Reviews

Recommended for You

Mastering PostgreSQL 11 - Second Edition Book Cover
Mastering PostgreSQL 11 - Second Edition
$ 31.99
$ 22.40
Mastering Ansible - Third Edition Book Cover
Mastering Ansible - Third Edition
$ 31.99
$ 22.40
Learning PostgreSQL 10 - Second Edition Book Cover
Learning PostgreSQL 10 - Second Edition
$ 27.99
$ 19.60
Mastering Windows PowerShell Scripting - Third Edition Book Cover
Mastering Windows PowerShell Scripting - Third Edition
$ 35.99
$ 25.20
PostgreSQL 11 in 7 days [Video] Book Cover
PostgreSQL 11 in 7 days [Video]
$ 124.99
$ 106.25
RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3 [Video] Book Cover
RDS PostgreSQL and DynamoDB CRUD: AWS with Python and Boto3 [Video]
$ 54.99
$ 46.75