Learn PostgreSQL
Build and manage high-performance database solutions using PostgreSQL 12 and 13
| Price | $44.99 - $58.08
|
| Rating |  |
| Authors | Luca Ferrari , Enrico Pirozzi |
| Publisher | Packt Publishing |
| Published | 2020 |
| Pages | 650 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 183898528X |
| ISBN-13 | 9781838985288 |
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 teach you how to achieve the right database design required for a reliable environment.
You'll learn how to install and configure a PostgreSQL server and even manage users and connections. The book then progresses to key concepts of relational databases, before taking you through the Data Definition Language (DDL) and commonly used DDL commands. To build on your skills, you'll understand how to interact with the live cluster, create database objects, and use tools to connect to the live cluster. You'll then get to grips with creating tables, building indexes, and designing your database schema. Later, you'll explore the Data Manipulation Language (DML) and server-side programming capabilities of PostgreSQL using PL/pgSQL, before learning how to monitor, test, and troubleshoot your database application to ensure high-performance and reliability.
By the end of this book, you'll be well-versed with the Postgres database and be able to set up your own PostgreSQL instance and use it to build robust solutions.
- Luca Ferrari (2 books)
- Enrico Pirozzi (2 books)
5 5 7
Similar Books
by Salahaldin Juba, Achim Vannahme, Andrey Volkov
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. ...
Price: $31.51 | Publisher: Packt Publishing | Release: 2015
Beginning PHP and PostgreSQL E-Commerce 
by Cristian Darie, Mihai Bucica, Emilian Balanescu
The PHP language and PostgreSQL database server have long offered an ideal blend of practicality and power for both the novice and experienced programmer alike. Yet the continued evolution of both technologies makes them better suited to drive enterprise-class applications than ever before.Each chapter is devoted to a specific new feature...
Price: $37.48 | Publisher: Apress | Release: 2006
by Nick Pentreath
Apache Spark is a framework for distributed computing that is designed from the ground up to be optimized for low latency tasks and in-memory data storage. It is one of the few frameworks for parallel computing that combines speed, scalability, in-memory processing, and fault tolerance with ease of programming and a flexible, expressive, ...
Price: $34.99 | Publisher: Packt Publishing | Release: 2015
PostgreSQL for Data Architects
by Jayadevan Maymala
PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up.PostgreSQL for Data...
Price: $49.99 | Publisher: Packt Publishing | Release: 2015
by Chitij Chauhan
PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and h...
Price: $21.00 | Publisher: Packt Publishing | Release: 2015
PostgreSQL Server Programming, 2nd Edition
by Usama Dar, Hannu Krosing, Jim Mlodgenski, Kirk Roybal
This book will show you that PostgreSQL is so much more than a database server. In fact, it could even be seen as an application development framework, with the added bonuses of transaction support, massive data storage, journaling, recovery, and a host of other features that the PostgreSQL engine provides.You will get to grips with creat...
Price: $49.99 | Publisher: Packt Publishing | Release: 2015
PostgreSQL 10 Administration Cookbook
by Simon Riggs, Gianni Ciolli
PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.Through...
Price: $49.99 | Publisher: Packt Publishing | Release: 2018
Mastering Azure Machine Learning, 2nd Edition
by Christoph Korner, Marcel Alsdorf
Azure Machine Learning is a cloud service for accelerating and managing the machine learning (ML) project life cycle that ML professionals, data scientists, and engineers can use in their day-to-day workflows. This book covers the end-to-end ML process using Microsoft Azure Machine Learning, including data preparation, performing and logg...
Price: $41.99 | Publisher: Packt Publishing | Release: 2022