Packt+ | Advance your knowledge in tech

Subscription

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Conferences

Free Learning

You're reading from Learn PostgreSQL Build and manage high-performance database solutions using PostgreSQL 12 and 13

Product type Paperback

Published in Oct 2020

Publisher Packt

ISBN-13 9781838985288

Length 650 pages

Edition 1st Edition

Languages

SQL

Tools

PostgreSQL

Concepts

Databases

Authors (2):

Enrico Pirozzi

Luca Ferrari

View More author details

Table of Contents (27) Chapters

Preface

1. Section 1: Getting Started

2. Introduction to PostgreSQL FREE CHAPTER

3. Getting to Know Your Cluster

4. Managing Users and Connections

5. Section 2: Interacting with the Database

6. Basic Statements

7. Advanced Statements

8. Window Functions

9. Server-Side Programming

10. Triggers and Rules

11. Partitioning

12. Section 3: Administering the Cluster

13. Users, Roles, and Database Security

14. Transactions, MVCC, WALs, and Checkpoints

15. Extending the Database - the Extension Ecosystem

16. Indexes and Performance Optimization

17. Logging and Auditing

18. Backup and Restore

19. Configuration and Monitoring

20. Section 4: Replication

21. Physical Replication

22. Logical Replication

23. Section 5: The PostegreSQL Ecosystem

24. Useful Tools and Extensions

25. Toward PostgreSQL 13

26. Other Books You May Enjoy

Leave a review - let other readers know what you think

Advanced Statements

In the previous chapter, we started taking our first steps with PostgreSQL. In this chapter, we will analyze the SQL language more deeply and write more complex queries. We will talk about SELECT/INSERT/UPDATE again, but this time, we will use the more advanced options surrounding them. We will then cover JOIN and common table expressions (CTEs) in depth.

The topics we will talk about will be the following:

Exploring the SELECT statement
Using UPSERT
Exploring CTEs

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 €18.99/month. Cancel anytime

Authors (2)

Ferrari

Luca Ferrari has been passionate about computer science since the Commodore 64 era, and today holds a master's degree (with honors) and a Ph.D. from the University of Modena and Reggio Emilia. He has written several research papers, technical articles, and book chapters. In 2011, he was named an Adjunct Professor by Nipissing University. An avid Unix user, he is a strong advocate of open source, and in his free time, he collaborates with a few projects. He met PostgreSQL back in release 7.3; he was a founder and former president of the Italian PostgreSQL Community (ITPUG). He also talks regularly at technical conferences and events and delivers professional training.

See other products by Ferrari

Enrico Pirozzi

Enrico Pirozzi, EnterpriseDB certified on implementation management and tuning, with a master's in computer science, has been a PostgreSQL DBA since 2003. Based in Italy, he has been providing database advice to clients in industries such as manufacturing and web development for 10 years. He has been training others on PostgreSQL since 2008. Dedicated to open source technology since early in his career, he is a cofounder of the PostgreSQL Italian mailing list, PostgreSQL-it, and of the PostgreSQL Italian community site, PSQL

See other products by Enrico Pirozzi