Skip to content
UdemyPostgreSQLPaid courseAll Levels

PostgreSQL Tutorials for Beginners (Udemy.com)

Introduction to PostgreSQL, basic SQL queries, SQL command tutorials

Created by: Arthur Fong

Last updated October 2023

icon
What you will learn

  • Downloading and Installing PostgreSQL
  • Basic SQL commands and scripts
  • Creating new table
  • Altering content in the table

How it compares

Against the other 47 rated Udemy courses in PostgreSQL on CourseDuck:

  • Rating4.4 out of 5higher than 57% of them
  • Reviews486#14 of 48 by number of reviews
  • Length1.3 hoursshorter than 95% of them
  • Last updatedOctober 2023earlier than 53% of them

icon
Course Description

Today, we are all surrounded with full of data.

Data can be in the form of structured data(eg: Tables, worksheets), or unstructured data (free text fields or comments from social media).

Data can be also in the form of a bi-product that is produced during day-to-day transactions.

For example, when we are buying something from supermarkets, we are being issued a resit upon payment. The resit is a bi-product as our intention is not to collect the resit but to retrieve all the goods that we purchased from the supermarket. If we take a look at the resit, it has sufficient data as evidence that we bought the specific product from the supermarket. It has all the required data to perform a return when the product bought has defects. It has the date purchased, the location of the store, and the list of products, unit cost, and quantities that have been purchased.

The question is, where did all the data has been stored into? How did the company keep track of its revenue, and also increase the number of customers visiting their store?

In this course, we are going to learn how to download and install PostgreSQL, a database to store data, and to be retrieved by other systems for their designated purpose.


Data is the core of an AI model, which utilizes data input for the model to train, test, and learn from the data.

The usage of Machine Learning has allowed computers to perform predictions and provides suggestions to humans based on the data input that has been fed into the machine.

An example of Machine Learning is the Web Search Engine, which tries to understand what is the content we are searching for based on the data input that has been entered into the Search Engine.

Data can also be fed into BI systems to translate the data into useful insights to make the correct decision on a certain matter.

Hence, data is very important where database admins are hired to ensure data hygiene is taken good care of.

Join now to know more about PostgreSQL as a service for data warehousing.


The Objective of the course:

To provide a very understanding of the basic functionality of PostgreSQL.


Learning Outcomes:

1. How to install and configure PostgreSQL.

2. How to create and modify tables in PostgreSQL.

3. How to perform basic SQL commands in PostgreSQL.


#PostgreSQL Tutorials, #SQL query, #PosgreSQL basic commands, #Database System

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Arthur Fong

I have been in BI Industry for 7 years. In my past experience, I have being with a Qlik partner organization which helped me in gaining experience on developing some of the Qlik products, namely QlikView, Qlik Sense, and NPrinting. And I would like to share my knowledge as a developer with everyone here. Hopefully you will find my class informative for your learning.

icon
More PostgreSQL courses

$159.99

$139.99

$15.99

$129.99

$139.99

$74.99

icon
Reviews

4.4

486 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Doug Hoffer on 2/6/2026

Good course, but needs to be updated to current version of PostgreSQL. Course was built on PostgreSQL 14, and current release is 18. There's just enough differences that this course needs a refresh.

By Nikita Chemerys on 8/18/2024

Very thank you for this cool course. I waited more information about PostgreSQL, but unfortunately this is the short course. In my opinion, informations about '"JOIN" are very important

By K. D on 8/15/2024

Crisp, brief and very informative beginner course covering PostgresSQl and SQL Commands. Thank you to Instructor Arthur Fong for this information. Highly Recommended!

By Arnau on 8/8/2024

Simple but well done! Practical. Thank you for your time that you put into this course! TIP: Postgress 16.3 installation running on Mac needs for a column SELECT: "" around the column-name, like "Column-Name" or the column name should be a single and a fully lowercase word like region (in that case no need for single or double quotes). It will run fine. Success!

By Nils Langfeld on 3/18/2024

Sehr gut. Die Basics wurden gut erklärt und selbst in diesem kurzen Tutorial konnte ein zwei neue Dinge gelernt werden.

By Gary Eckhardt on 3/17/2024

As an Oracle professional getting ready to do a bit of PostgreSQL work, this helped me freshen up on PostgreSQL as it's been a while since I worked with it. Nice, simple basic things you'll need to get started, and confirms my memory that it's very much like Oracle SQL, just a bit different syntax. Thank you!

By SHANTHAMURTHY HANUMANTHARAYAPPA on 7/6/2023

Dear PostgreSQL Trainer, I hope this message finds you well. I would like to provide some feedback regarding the PostgreSQL training that I recently attended. Firstly, I want to express my appreciation for the comprehensive content covered during the training. The course materials were well-structured and easy to follow. The trainer's knowledge and expertise in PostgreSQL were evident throughout the sessions. Additionally, the practical exercises and hands-on activities were extremely beneficial in solidifying my understanding of the concepts. The trainer's guidance and support during these exercises were invaluable. I found the pace of the training to be just right. The trainer managed to strike a balance between covering the material thoroughly and allowing time for questions and discussions. This created a conducive learning environment. Furthermore, the training venue was well-equipped and comfortable. The facilities provided a conducive atmosphere for learning, with all necessary resources readily available. In terms of improvement, it would have been helpful to have more real-world examples and case studies incorporated into the training. This would have further enhanced the practical application of the concepts learned. Overall, I am extremely satisfied with the PostgreSQL training. It has equipped me with the necessary skills and knowledge to confidently work with PostgreSQL in my professional endeavors. Thank you once again for delivering an excellent training program. Your expertise and dedication to imparting knowledge are greatly appreciated. Best regards, Shanthamurthy

By Mark Calvelo on 1/11/2023

A good brief overview of functions and queries of PostgreSQL, would be nice if some exercises with solution videos were included in this course though

By Daniel Rivera on 9/14/2022

The instructor has knowledge of the database subject, very clear in his explanation. But there are many topics related to PostgreSql that are not covered as relational database basics.

By Achu Akoh Norbert on 6/6/2022

it was a good match for someone very new to the concept of SQL, for me wanted to know if there were difference in the syntax used in postgreSQL and i am happy you made it clearly visible that there is no difference.

Showing all 10 reviews on CourseDuck

Read all 486 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 88 / 100