Search icon Close icon
Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning PostgreSQL 11 - Third Edition

You're reading from  Learning PostgreSQL 11 - Third Edition

Product type Book
Published in Jan 2019
Publisher
ISBN-13 9781789535464
Pages 556 pages
Edition 3rd Edition
Languages
Concepts
Authors (2):
Salahaldin Juba Salahaldin Juba
Profile icon Salahaldin Juba
LinkedIn
Salahaldin Juba has over a decade of experience in industry and academia, with a focus on database development for large-scale and enterprise applications. He holds an MSc in environmental management with a distinction, and a B.Eng in computer systems. He is also a Microsoft Certified Solution Developer (MCSD). He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.
Read more
See other products by Salahaldin Juba
Andrey Volkov Andrey Volkov
Profile icon Andrey Volkov
LinkedIn
Andrey Volkov studied information systems in banking, and started his career as a financial analyst at a commercial bank. He joined a data warehouse team, and after some time, he lead the team by taking the position of the data warehouse architect. There he worked mainly with Oracle database stack and used it to develop logical and physical models of financial and accounting data, implement them in the database, develop ETL processes, and perform analytical tasks. Now Andrey works as a senior database developer at a telecommunication provider. There, he works mainly with PostgreSQL databases, being responsible for data modeling, developing a data warehouse, reporting, and billing systems.
Read more
See other products by Andrey Volkov
View More author details
Toc

Table of Contents (18) Chapters close

1. Relational Databases 2. PostgreSQL in Action 3. PostgreSQL Basic Building Blocks 4. PostgreSQL Advanced Building Blocks 5. SQL Language 6. Advanced Query Writing 7. Server-Side Programming with PL/pgSQL 8. OLAP and Data Warehousing 9. Beyond Conventional Data Types 10. Transactions and Concurrency Control 11. PostgreSQL Security 12. The PostgreSQL Catalog 13. Optimizing Database Performance 14. Testing 15. Using PostgreSQL in Python Applications 16. Scalability 17. What's Next? 18. Other Books You May Enjoy

OLAP and Data Warehousing

A database usually performs the role of a storage component of a complex software solution. Depending on the type of the solution and what problem it aims to solve, the configuration of the database and the data structure can be different. It's common to configure a database and data structure in one of two ways: online transaction processing (OLTP) or online analytical processing (OLAP).

In this chapter, we will discuss some features of PostgreSQL that help implement a data warehouse solution based on a PostgreSQL database, and theoretical concepts related to that, namely:

  • OLTP and OLAP: their purpose and differences
  • Online analytical processing: What it is and why it's special
  • Partitioning: A way to physically organize and manage huge tables
  • Parallel query: A feature that increases the speed of query execution
  • Index-only scans: A way to...
lock icon The rest of the chapter is locked
arrow left Previous Section
Section 1 of 8
Next Section arrow right
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Sign up now
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Start free trial
Renews at €14.99/month. Cancel anytime}

Authors (2)

Left arrow icon
Profile icon Salahaldin Juba
LinkedIn
Salahaldin Juba has over a decade of experience in industry and academia, with a focus on database development for large-scale and enterprise applications. He holds an MSc in environmental management with a distinction, and a B.Eng in computer systems. He is also a Microsoft Certified Solution Developer (MCSD). He has worked mainly with SQL server, PostgreSQL, and Greenplum databases. As a software engineer, he works mainly with defining ETL processes with external parties, promoting SQL best practices, designing OLTP and OLAP applications, and providing training and consultation services.
Read more
See other products by Salahaldin Juba
Profile icon Andrey Volkov
LinkedIn
Andrey Volkov studied information systems in banking, and started his career as a financial analyst at a commercial bank. He joined a data warehouse team, and after some time, he lead the team by taking the position of the data warehouse architect. There he worked mainly with Oracle database stack and used it to develop logical and physical models of financial and accounting data, implement them in the database, develop ETL processes, and perform analytical tasks. Now Andrey works as a senior database developer at a telecommunication provider. There, he works mainly with PostgreSQL databases, being responsible for data modeling, developing a data warehouse, reporting, and billing systems.
Read more
See other products by Andrey Volkov
Right arrow icon

Other recommended products

Related to this chapter
Left arrow icon
PostgreSQL High Performance Cookbook
PostgreSQL High Performance Cookbook
Read more
This book will guide you to enhance your database’s performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. You will be a able to perform various essential database tasks such as bench marking the database and optimizing the server’s memory usage. This book will also help you to explore various memory optimization techniques offered by PostgreSQL.
Read more
Mar 2017 12 hours 0 minutes
Learn PostgreSQL
Learn PostgreSQL
Read more
This book will get you up and running with the working of relational databases, data modeling, data manipulation, and more. You will learn to build efficient relational database solutions from scratch using the latest features of PostgreSQL 12 and 13. You’ll also be able to identify bottlenecks to enhance the performance of database applications.
Read more
Oct 2020 21 hours 40 minutes
PostgreSQL 13 Cookbook
PostgreSQL 13 Cookbook
Read more
PostgreSQL has become the most advanced open source database on the market. This book adopts a step-by-step approach to meet almost every requirement you can think of while deploying PostgreSQL in production environments. You will not only learn how to design and manage your database but also discover how to administer and secure the database.
Read more
Feb 2021 11 hours 28 minutes
PostgreSQL 11 Server Side Programming Quick Start Guide
PostgreSQL 11 Server Side Programming Quick Start Guide
Read more
PostgreSQL is a rock-solid, scalable, and safe, enterprise-level relational database. With a broad range of features and stability it is ever increasing in popularity. The book shows you how to take advantages of PostgreSQL 11 features for Server-Side-Programming. Server-Side-Programming enables strong data encapsulation and coherence.
Read more
Nov 2018 8 hours 40 minutes
Developing Modern Database Applications with PostgreSQL
Developing Modern Database Applications with PostgreSQL
Read more
This book is divided into two parts with the first helping you to build advanced and scalable PostgreSQL apps. The second part enables you to administer them using DevOps. All the projects in this book will be demonstrated via the use of a small banking application for managing ATM machine locations in a typical city.
Read more
Aug 2021 14 hours 40 minutes
Mastering PostgreSQL 12
Mastering PostgreSQL 12
Read more
This book includes the newly introduced features in PostgreSQL 12, and shows you how to build better PostgreSQL applications, and administer your database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build secured and fault-tolerant database solutions.
Read more
Nov 2019 15 hours 40 minutes
Mastering PostgreSQL 11
Mastering PostgreSQL 11
Read more
This book includes the newly introduced features in PostgreSQL 11, and shows you how to build better PostgreSQL applications, and administer your PostgreSQL database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build efficient database solutions.
Read more
Oct 2018 14 hours 52 minutes
Learn SQL Database Programming
Learn SQL Database Programming
Read more
SQL is a powerful querying language used to store, manipulate, and retrieve data. This is a comprehensive guide for who are new to SQL, which will have you up-to-speed and using SQL to streamline your work in no time. It gives users enough confidence to use SQL queries for retrieving and manipulating data relevant to their work-related tasks.
Read more
May 2020 18 hours 48 minutes
Mastering PostgreSQL 13
Mastering PostgreSQL 13
Read more
Updated to include the new features introduced in PostgreSQL 13, this book shows you how to build better PostgreSQL applications and administer your PostgreSQL database efficiently. You’ll master the advanced features of PostgreSQL and develop the skills you need to build secure and highly available database solutions.
Read more
Nov 2020 15 hours 52 minutes
Mastering PostgreSQL 10
Mastering PostgreSQL 10
Read more
PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently.
Read more
Jan 2018 14 hours 16 minutes
Mastering PostgreSQL 9.6
Mastering PostgreSQL 9.6
Read more
PostgreSQL is an open source database management tool used for handling large datasets (big data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.
Read more
May 2017 13 hours 52 minutes
PostgreSQL 11 Administration Cookbook
PostgreSQL 11 Administration Cookbook
Read more
PostgreSQL is a powerful open source database management system, now recognized as the experts’ choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL 11 solution.
Read more
May 2019 20 hours 0 minutes
Right arrow icon

Personalised recommendations for you

Based on your interests and search pattern
Left arrow icon
Et al.
Et al.
Read more
Ever wonder why speech recognition systems don't understand the Scottish accent, or what would happen if an astronaut only ate mac 'n' cheese, or other spurious reflections you'd have at a bar? We did, then collated those deliberations into absurd research articles with fake figures and methodologies inspired by even more fictionally absurd studies.
Read more
Aug 2023 7 hours 40 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Generative AI with LangChain
Generative AI with LangChain
Read more
This book is a comprehensive introduction to LLMs and LangChain, demystifying the basic mechanics of LangChain, its functionalities, and the myriad of applications it can be integrated into.
Read more
Dec 2023 12 hours 0 minutes
Mastering Tableau 2023
Mastering Tableau 2023
Read more
This book is a comprehensive resource to mastering your Tableau skills and becoming a BI expert. As you progress, you will learn how to build advanced dashboards and improve your storytelling to derive key business insight, as well as make you well-versed with advanced functionalities of Tableau in the business intelligence domain.
Read more
Aug 2023 22 hours 48 minutes
Building AI Applications with ChatGPT APIs
Building AI Applications with ChatGPT APIs
Read more
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Read more
Sep 2023 8 hours 36 minutes
Building AI Applications with ChatGPT APIs
Building AI Applications with ChatGPT APIs
Read more
This guide covers all ChatGPT API features for effortless creation of robust AI powered apps. With its help, you’ll be able to leverage ChatGPT’s cutting-edge NLP models to take your app development skills to the next level. You’ll also work on ten exciting projects that will give you the practical know-how that you can apply to your existing applications.
Read more
Sep 2023 8 hours 36 minutes
Data Engineering with AWS
Data Engineering with AWS
Read more
Embark on a journey to master data engineering pipelines on AWS! Our book offers a hands-on experience of AWS services for ingesting, transforming, and consuming data. Whether you're an absolute beginner or someone with basic data engineering experience, this guide is an indispensable resource.
Read more
Oct 2023 21 hours 12 minutes
Modern Data Architecture on AWS
Modern Data Architecture on AWS
Read more
Every organization wants an agile, performant, and cost-effective data platform that meets all their current and future business needs. Purpose-built AWS analytics services and their features play a big part in building such a modern data platform. This book brings to you all the design and architectural patterns that’ll help you achieve this goal.
Read more
Aug 2023 14 hours 0 minutes
Practical Guide to Applied Conformal Prediction in Python
Practical Guide to Applied Conformal Prediction in Python
Read more
Discover the power of Conformal Prediction with the "Practical Guide to Applied Conformal Prediction in Python." Master the latest techniques to quantify uncertainty in machine learning and computer vision models, and seamlessly apply them to your industry applications.
Read more
Dec 2023 8 hours 0 minutes
TinyML Cookbook
TinyML Cookbook
Read more
With over 70 project-based recipes, the TinyML Cookbook is a practical guide that will help you to get the most out of your microcontrollers. It provides a comprehensive understanding of the theoretical foundations while giving you hands-on experience training ML models for deployment on Arduino Nano 33 BLE Sense, Raspberry Pi Pico, and SparkFun RedBoard Artemis Nano microcontrollers.
Read more
Nov 2023 22 hours 8 minutes
Right arrow icon