Handling Advanced SQL

In the previous chapter, you learned about indexing as well as about PostgreSQL's ability to run custom indexing code to speedup queries. In this chapter you will learn about advanced SQL. Most readers of this book will have some experience of using SQL. However, experience has shown that those advanced features outlined in this book are not widely known and therefore it makes sense to cover them in this context to help people to achieve their goals faster and more efficiently.

The topics of this chapter are:

• Grouping sets
• Ordered sets
• Hypothetical aggregates
• Windowing functions and analytics

At the end of the chapter, you will be able to understand and use advanced SQL.