Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Learning PostgreSQL 11 A beginner's guide to building high-performance PostgreSQL database solutions

Product type Paperback

Published in Jan 2019

Publisher

ISBN-13 9781789535464

Length 556 pages

Edition 3rd Edition

Languages

SQL

Tools

PostgreSQL

Concepts

Database Programming

Authors (2):

Andrey Volkov

Christopher Travers

View More author details

Table of Contents (18) Chapters

1. Relational Databases FREE CHAPTER

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

Leave a review - let other readers know what you think

Questions

What is OLAP and what is the difference between OLAP and OLTP?
What is ETL?
What are fact tables and dimension tables?
Why would we denormalize data in data warehouses?
What is the difference between dimensions and measures?
What is the purpose of partitioning?
What is a partition key?
Which partitioning schemes are supported by PostgreSQL? What are the typical use cases for each of them?
How do we implement sub-partitioning?
How do we utilize multiple CPU cores of the database server when executing a query?
What are index-only scans?
Is there a way to enable index-only scans for a field without building an index on that field?

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

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 $19.99/month. Cancel anytime

Authors (2)

Christopher Travers

Contacted on 30th Jan 2017 for Video Course on PostgreSQL High Performance.

See other products by Christopher Travers

Volkov

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.

See other products by Volkov