PostgreSQL is a general purpose and object-relational database management system (ORDBMS), according to the Encyclopedia Britannica there are three types of database models; hierarchical model, network model and the relational model.

PostgreSQL started originally in 1986 as the POSTGRES Project lead by Michael Stonebraker at Berkeley, the project was sponsored by; Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL Inc.

This post is a road map for anyone willing to start learning PostgreSQL online for free from scratch, the post will present and compare between the best online sources where beginners can start from and follow along, the sources stated in this post are full structured courses so you won’t find a link to a single video or a group of unrelated tutorials.

If you just want the bottom line (the road map to learn PostgreSQL) and you don’t wish to read the entire article then go to the “Bottom Line” section at the end of the article.

Start Learning PostgreSQL Online for Free from Scratch

PostgreSQL Tutorial

PostgreSQL Tutorial is the first free online outlet where beginners can start learning PostgreSQL through a text-based tutorial, you don’t have to register to have access to the training.

Structure: The training is divided into two main sections, each section is divided into lessons (27 in total) and each of these lessons covers a certain topic in PostgreSQL.

Interface: The interface is very simple, just click on the lesson you’re interested in and you’ll be directed to the page where the lesson resides.

Now, the pros and cons:

Pros

1. Free.
2. The training is well-structured and organized for beginners.
3. The training is up to date with the latest release of PostgreSQL.

Cons

1. The training is available as text only so that might be a problem for beginners who prefer video tutorials.

Verdict: This is the best outlet where beginners can start learning PostgreSQL online through a text-based tutorial.

Computer Junks YouTube Channel (Update: Not Available)

Computer Junks YouTube Channel is the second free online outlet where beginners can start learning PostgreSQL through a video tutorial.

Structure: The training is divided into 30 video lessons, each video lesson covers a certain topic in PostgreSQL.

Interface: The standard YouTube Interface.

Now, the pros and cons:

Pros

1. Free.
2. The training is well-structured and organized for beginners.

Cons

1. The training doesn’t cover the latest release of PostgreSQL, though this won’t be a big problem for beginners.

Verdict: This is the best outlet where beginners can start learning PostgreSQL through video tutorials.

Tutorials Point

Tutorials Point is the third free online outlet where beginners can start learning PostgreSQL from scratch. This is a text based course and you don’t need to register to have access to the course.

Structure: The training is divided into 4 sections, and each section is divided into topics covering PostgreSQL.

Interface: The interface is very simple, just click on the topic you’re interested in and you’ll be directed to the topic’s window.

Now, the pros and cons:

Pros

1. Free.
2. The course is very suitable for those who want to revise a certain topic in PostgreSQL.
3. PostgreSQL interface with programming languages (C, C++, PHP, Python, Java, Perl) is covered in this outlet.

Cons

1. The course is structured more towards revising certain topics in PostgreSQL.

Verdict: This outlet is suitable for those who want to revise certain topics in PostgreSQL.

W3 Resources

W3 Resources is the fourth free online outlet where beginners can start learning PostgreSQL through a text based tutorial, you don’t need to register to have access to the training.

Structure: The training is divided into 26 lessons and each of the lessons covers a certain topic PostgreSQL.

Interface: The interface is very simple, just click on the lesson you’re interested in and you’ll be directed to the page where the lesson resides.

Now, the pros and cons:

Pros

1. Free.
2. The training is well-structured and organized for beginners.

Cons

1. The training doesn’t cover the latest release of PostgreSQL, though this won’t be a big problem for beginners.

Verdict: This is a good outlet where beginners can start learning PostgreSQL through a text-based tutorial.

Bottom Line

The recipe for learning PostgreSQL

1. Computer Junks YouTube Channel is the best outlet for beginners to start learning PostgreSQL through video tutorials.
2. PostgreSQL Tutorial is the best outlet to start learning PostgreSQL through text-based tutorials.

Remember that the first step is always the toughest step, and the aim of this post is to provide you with resources that will help you take your first step in PostgreSQL.