Learning PostgreSQL 11

Learning PostgreSQL 11
Author :
Publisher : Packt Publishing Ltd
Total Pages : 545
Release :
ISBN-10 : 9781789535211
ISBN-13 : 1789535212
Rating : 4/5 (212 Downloads)

Book Synopsis Learning PostgreSQL 11 by : Salahaldin Juba

Download or read book Learning PostgreSQL 11 written by Salahaldin Juba and published by Packt Publishing Ltd. This book was released on 2019-01-31 with total page 545 pages. Available in PDF, EPUB and Kindle. Book excerpt: Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications Key FeaturesMonitor, secure, and fine-tune your PostgreSQL 11 databaseLearn client-side and server-side programming using SQL and PL/pgSQLDiscover tips on implementing efficient database solutionsBook 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. What you will learnUnderstand the basics of relational databases, relational algebra, and data modelingInstall a PostgreSQL server, create a database, and implement your data modelCreate tables and views, define indexes and stored procedures, and implement triggersMake use of advanced data types such as Arrays, hstore, and JSONBConnect your Python applications to PostgreSQL and work with data efficientlyIdentify bottlenecks to enhance reliability and performance of database applicationsWho this book is for This book is for you if you're interested in learning about PostgreSQL from scratch. Those looking to build solid database or data warehousing applications or wanting to get up to speed with the latest features of PostgreSQL 11 will also find this book useful. No prior knowledge of database programming or administration is required to get started.


Learning PostgreSQL 11 Related Books

Learning PostgreSQL 11
Language: en
Pages: 545
Authors: Salahaldin Juba
Categories: Computers
Type: BOOK - Published: 2019-01-31 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications Key FeaturesMonitor, secure, and fine-tune your PostgreSQL 11 d
Learning PostgreSQL
Language: en
Pages: 464
Authors: Salahaldin Juba
Categories: Computers
Type: BOOK - Published: 2015-11-30 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn about the PostgreSQL development life cycle in
PostgreSQL 11 Administration Cookbook
Language: en
Pages: 589
Authors: Simon Riggs
Categories: Computers
Type: BOOK - Published: 2019-05-03 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

A practical guide to administer, monitor and replicate your PostgreSQL 11 database Key FeaturesStudy and apply the newly introduced features in PostgreSQL 11Tac
PostgreSQL 11 Server Side Programming Quick Start Guide
Language: en
Pages: 252
Authors: Luca Ferrari
Categories: Computers
Type: BOOK - Published: 2018-11-29 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

Extend PostgreSQL using PostgreSQL server programming to create, test, debug, and optimize a range of user-defined functions in your favorite programming langua
Learn PostgreSQL
Language: en
Pages: 636
Authors: Luca Ferrari
Categories: Computers
Type: BOOK - Published: 2020-10-09 - Publisher: Packt Publishing Ltd

DOWNLOAD EBOOK

A comprehensive guide to building, managing, and securing scalable and reliable database and data warehousing applications using Postgres 12 and 13 Key Features