Introduction to PostgreSQL for the Data Professional

Comments 0

Share to social media

Learning something new has elements of bliss and terror. We all know the bliss of learning something new. The first time you figure out how to do something is a magical feeling that one never tends to lose. Stuck in the back of your mind is the first time you rode a bike, solved a complex math problem, and as a DBA, when you built your first backup system that you felt you could rely on in a catastrophe.

The terror on the other hand, is often simply centered around the problem of not knowing how to get started. This can be doubly difficult when you are learning something new that is very similar to what you already know. As a data professional well versed in one database platform’s technology, taking your skills from one platform to another can be daunting.

This book was written by two of Simple-Talk’s writers: Ryan Booz and Grant Fritchey to reduce the terror of getting started with PostgreSQL in this book.

Why this book?

Of course, there’s always just reading the PostgreSQL documentation. It is great at showing you how to do specific tasks, but not as much with helping you find what you need when you aren’t sure how to ask. In this book, Ryan and Grant work to help you find the path to learning all about what PostgreSQL is. What it does, and how to use it to get you past the terror stage and quickly into the bliss stage, on your way to becoming a database platform polyglot!

The book covers topics like:

  • Creating your first instance (known as a cluster in PostgreSQL)
  • Backups,
  • Server configurations, a
  • Major maintenance tasks (VACUUM, monitoring, indexing)
  • Query and procedural languages
  • So much more more.

Most every basic you need to get started with PostgreSQL is covered in this book. Every chapter provides fundamental knowledge and guidance to quickly get you up to speed on how to utilize PostgreSQL.

To download your copy, go to:

Introduction to PostgreSQL (for the data Professional)

Load comments

About the author

Louis Davidson

Simple Talk Editor

See Profile

Louis is the editor of this Simple-Talk website. Prior to that, has was a corporate database developer and data architect for a non-profit organization for 25 years! Louis has been a Microsoft MVP since 2004, and is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.