2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
  • Products
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Blog2 / PostgreSQL3 / Why should you learn PostgreSQL?
2ndQuadrant Press

Why should you learn PostgreSQL?

June 9, 2015/1 Comment/in PostgreSQL /by 2ndQuadrant Press

global_32032781A few weeks ago I asked one of my colleagues why I should learn PostgreSQL. Harald’s answer was: “To start any new journey of learning, asking ‘why’ is an excellent question. It gives us both a direction to send us on our way and an expected destination. Without a clear path to follow, our brains tend to filter out new information.” He then came up with some very valid reasons to learn PostgreSQL.

SQL is a powerful tool to get data under control

Why should we learn Structured Query Language (SQL)? SQL was initially created to enable non-IT specialists to query information from datasets without needing to ask a programmer for help. SQL aimed to be much more powerful than interfaces such as query by example, and more flexible than prebuild reports. The objective was to enable new ways of examining and querying existing data.

SQL is a declarative language – the user tells the database which data is required and the database decides how to perform the command. The emphasis is on the result of the process rather than the process itself – the ends rather than the means. This contrasts to the ancient way of programming, in which the user had to describe the data gathering step-by-step. However, the success and efficiency of SQL relies upon users asking the correct questions, and this is where companies such as 2ndQuadrant can help. 2ndQuadrant teaches database users how to best phrase their questions in order to receive the fastest, most accurate answers from the database.

Besides being able to use SQL to query databases, learning it also encourages us to build powerful mental models to think about data. We gather and store more and more data – and being capable of reasoning that data is a powerful mental ability. Just think of all the data collected by big social networks or agencies that protect the free world!

PostgreSQL is free, open and unlimited

PostgreSQL is available for free and it is open. It will never be bought.  This makes it the best tool for learning about relational databases. PostgreSQL has very exhaustive and detailed documentation. Although tough on the beginner – it is hard to find an easy entry point – having mastered the first step, you will never run out of information to further your knowledge.

Look at the source, Luke, may be the ultimate answer when your progress stalls – which isn’t exactly comforting, but much better than knowing there is no possible answer.

PostgreSQL works hard

Besides all the cool kids running NoSQL for their Web startup, relational databases are still the workhorses of the computer industry. PostgreSQL has an advanced implementation of SQL and is very close to the SQL standard. So your knowledge would be of use as it is transferable, so other SQL databases are available to you.

It’s good for your mind – and your career

Still need convincing that learning SQL is worth it? Well, in addition to creating new neural pathways in your brain, it could do wonders for your career prospects as it will make you a desirable candidate. Having “PostgreSQL knowledge” in your CV and online profile will almost certainly attract the attention of recruiters, as the role of Data Scientist has been called, by the Harvard Business Review, “The Sexiest Job of the 21st Century”. Knowing about databases moves you in this direction.

Dear reader, maybe it is not too late for you or for me, and hopefully a lot of others, to understand the big mystery of SQL. Are you convinced? If so, do not miss our next post when Harald will be teaching us the basics. Join me soon!

Harald ArminMai2015-021Harald Armin Massa

Harald has been working with PostgreSQL as an application programmer and DBA since 1996. Since 1999 he has been active as an entrepreneur, doing development with various SQL databases and using Python.  He joined 2ndQuadrant in 2010 and founded 2ndQuadrant Deutschland GmbH in 2011. He has a wide range of training experience and renowned for hosting ‘lightning talks’ at many international events.

 

Tags: 2ndQuadrant, NOSQL, sql, Structured Query Language
Share this entry
  • Share on Facebook
  • Share on Twitter
  • Share on WhatsApp
  • Share on LinkedIn
1 reply
  1. Achim
    Achim says:
    June 9, 2015 at 10:51 am

    Thanks for the nice article! Looking forward to Haralds stuff. Would like to see some real world examples of using the full text search functionality of Postgres.

    Reply

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Get in touch with us!

Recent Posts

  • Random Data December 3, 2020
  • Webinar: COMMIT Without Fear – The Beauty of CAMO [Follow Up] November 13, 2020
  • Full-text search since PostgreSQL 8.3 November 5, 2020
  • Random numbers November 3, 2020
  • Webinar: Best Practices for Bulk Data Loading in PostgreSQL [Follow Up] November 2, 2020

Featured External Blogs

Tomas Vondra's Blog

Our Bloggers

  • Simon Riggs
  • Alvaro Herrera
  • Andrew Dunstan
  • Craig Ringer
  • Francesco Canovai
  • Gabriele Bartolini
  • Giulio Calacoci
  • Ian Barwick
  • Marco Nenciarini
  • Mark Wong
  • Pavan Deolasee
  • Petr Jelinek
  • Shaun Thomas
  • Tomas Vondra
  • Umair Shahid

PostgreSQL Cloud

2QLovesPG 2UDA 9.6 backup Barman BDR Business Continuity community conference database DBA development devops disaster recovery greenplum Hot Standby JSON JSONB logical replication monitoring OmniDB open source Orange performance PG12 pgbarman pglogical PG Phriday postgres Postgres-BDR postgres-xl PostgreSQL PostgreSQL 9.6 PostgreSQL10 PostgreSQL11 PostgreSQL 11 PostgreSQL 11 New Features postgresql repmgr Recovery replication security sql wal webinar webinars

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
The WITHIN GROUP and FILTER SQL clauses of PostgreSQL 9.4 BDR 0.9.2 and BDR-PostgreSQL 9.4.4 released
Scroll to top
×