Learning PostgreSQL 11

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.

Type
ebook
Category
Data
publication date
2019-01-31
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

no of pages
556
duration
1112
key features
Monitor, secure, and fine-tune your PostgreSQL 11 database * Learn client-side and server-side programming using SQL and PL/pgSQL * Discover tips on implementing efficient database solutions *
approach
This book takes a very comprehensive, step-by-step approach so you understand how the PostgreSQL 11 ecosystem can be used to develop efficient, scalable solutions. Every chapter is standalone and written in a very easy-to-understand manner, with a focus on both the hows and the whys of each concept.
audience
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.
meta description
Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications
short description
This book will get you up and running with building efficient relational database solutions right from scratch with the newest features of PostgreSQL 11. You will learn the end-to-end working of relational databases and how to work with database structures. You will also be able to write essential SQL statements, perform data manipulation and do more, with the help of this book.
subtitle
A beginner's guide to building high-performance PostgreSQL database solutions
keywords
Machine Learning, supervised learning, unsupervised learning, data sets, GPU, Python, Hadoop, Spark, R, Julia, Mahout, Data Architectures, Deep Learning, Neural Networks, Artificial Intelligence
Product ISBN
9781789535464