Chapter 13. Classification of Data—Real-World Examples

Selecting data is not the only purpose for relational databases. For reporting, it is essential to perform some sort of aggregation and classification. You have already learned about aggregation functions in this book. A lot of software can be used to deal with classification and aggregation. In this chapter, you learn to work with SQL and the EFEU package. These two ways of working with data are good examples for different concepts.

Working with SQL

In this section, you take a close look at how data can be classified with the help of joins and tables.

In general, classification means that certain values are combined in one group, which is assigned to a new name. How can you tell the database ...

Get PostgreSQL Developer's Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.