Skip to content
Write a review
UdemyPostgreSQLPaid courseBeginner levelCertificate

Learn The Basics of PostgreSQL For Beginners (Udemy.com)

The practical guide to learn the basics of PostgreSQL and pgAdmin for beginners.

4.4
53 reviews

Created by: Ahmad Mohey

Last updated November 2020

icon
What you will learn

  • Install PostgreSQL and pgAdmin.
  • Understand basics of cloud databases.
  • Understand basics of PostgreSQL.
  • Create PostgreSQL database instances on Amazon Web Services (AWS).
  • Connect pgAdmin to cloud database (AWS).
  • Create PostgreSQL databases and schemas.
  • Create and manage users in PostgreSQL.
  • Create tables using SQL script.
  • Create tables using pgAdmin.
  • Learn about different data types available in PostgreSQL.
  • Understand Constraints and how to apply them.
  • Create primary keys and foreign keys.
  • Design relational databases and create relationships between tables in PostgreSQL.
  • Generate Entity Relationship Diagram (ERD).
  • Import and Export Data using pgAdmin.
  • Using a powerful tool called DbVisualizer.
  • How to grant privileges in PostgreSQL.

How it compares

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

  • Rating4.4 out of 5higher than 57% of them
  • Reviews53#40 of 48 by number of reviews
  • Length2.9 hoursshorter than 70% of them
  • Last updatedNovember 2020earlier than 68% of them

icon
Quality Score

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

Overall Score : 88 / 100

icon
Course Description

Welcome to Learn The Basics of PostgreSQL course, The practical guide to learn the basics of PostgreSQL and pgAdmin.
PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
Learning PostgreSQL is one of the best ways to boost your career! As it is getting popular each day and many giant companies are using PostgreSQL as a relational database.
This course will start with you from zero level experience in PostgreSQL and relational databases, starting to level up as we are going through the course. explaining all the questions you maybe asking yourself such as
What is a PostgreSQL? what is relational database? what is a cloud database?
This course will guide you how to install PostgreSQL on a local machine step by step and even how to create your own cloud databases on the one of the most required cloud services providers in the market...Amazon Web Services (AWS).
You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)
Some of the points we will be covering :
  • How to install the PostgreSQL.
  • How to install and use pgAdmin.
  • Create databases with PostgreSQL.
  • Understand what is schema and how to create a schema.
  • How create tables using SQL script.
  • How to create tables using pgAdmin.
  • Use different datatypes available in PostgreSQL.
  • How to create views.
  • Understand what does DBaaS mean.
  • You will learn how to create users to access your database based on specific permissions you gave them.
  • How to create different constraints.
  • Create primary keys in PostgreSQL.
  • Create foreign keys in PostgreSQL.
  • How to import a bulk of data in and out of your database.
  • Generate Entity Relationship Diagram (ERD) using another powerful tool called DbVisualizer.
Give your CV a huge boost by learning PostgreSQL...do not hesitate enrolling.Who this course is for:
  • Complete beginners, no prior experience is required.
  • Anyone want to learn PostgreSQL
  • Anyone want to learn relational databases and and be familiar with SQL syntax.
Read More Beginner Beginner Level product length iconTime: 2.9h

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.

Get the Udemy discount

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

placeholder

Hello there! My name is Ahmad Mohey I'm a senior full stack developer. I have been developing applications for the last 10 years and I hope more years of creative developing to come. I have been developing applications for oil and gas industry and the financial and human resources departments for many companies.
I love to learn about new technologies and what's new in the world of development as it's growing rapidly, I love to help people learn and solve their problems. I believe, we all shall share our knowledge and pass it to each others.
The path to become a developer or a programmer is never easy but it is not that hard, You just need to keep going and do not quit and always think of any skill you have now, remember that you did not master it from the first time, you had to keep trying to master it.
Far from the software world I love photography and you can check my photographs on my page on facebook or 500px website, I am passionate about learning management and emotional intelligence and I attended many courses about management, negotiations and leadership.
I love traveling a lot,I love to see new places, cities, countries, cultures and people if I were to choose one thing to continue doing the rest of my life I would choose traveling.
One last thing and I think it might be relevant for me being a developer, is that I love computer games maybe that's why I love programming :) . I hope one day I will make my own games.
Finally thanks for your time read

Read More

icon
More courses by Ahmad Mohey

$11.99

$84.99

$15

All courses by Ahmad Mohey

icon
More PostgreSQL courses

$159.99

$139.99

$15.99

$129.99

$139.99

$74.99

All PostgreSQL courses

icon
Reviews

4.4

53 ratings on Udemy

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

Write a review

By Idhi Tri Atmojo

it's nice and neat tutorial as always... i hope there is a next level for this course.. thanks AM

By Muhammad Mubashir Mukhtar

Really awesome course for a beginner!

By Misbah Siddiqui

So far. I am also looking for Installation on Linux

By Jose Fernandez del Valle

I liked the course by concise and concrete.

He did not play around and present what I wanted to see.

I hope you publish an advanced series of this course, which will present topics such as the full SQL language for Postgre, triggers, performance improvements, among other issues.

By Lynette Buckley

Really enjoyed the PostgreSQL introduction. The information presented was useful and exactly what I expected.

Thank you for the bonus SQL Server on Azure demonstration! I found this very interesting and useful!

By Leonid Kopylov

Great for beginners

By Deborah Vela

I really like that I can work along with the instructor but I have to keep pausing the video because he does some things a little fast. I had some issues connecting the server at the end as well. I was never able to connect it.

By Anmol Bir Kalra

Excellent introduction to the concept.

Well paced videos and instructions easy to follow and replicate as a user.

By Robbanie Ridlwan

saya menyukai pelajaran ini dan sangat cocok sekali

By William Thompson Jr

So far has been a good match for me. I became an Employee for a small company that utilizes PostgreSQL and PGAdmin so this is so far a good tool for me to learn the ropes.

By Joseph Delcambre

The content was ok, maybe 3 - 4 stars on average. But, the narrator was difficult to understand. His accent was thick, English was his second language, and he would speak too quickly in some parts of the sentence, pronouncing several words at a time, making almost impossible to understand.

By Latoya T

I appreciated being shown how to install pgadmin and SQL mgmt studio. I posted some questions and did not see any answers or feedback. That was concerning. Overall I appreciated the resources. The chrome browser should be mentioned as being the browser to use pgadmin. Features did not work in IE. IT was a good starter course — worth the money.

Showing all 12 reviews on CourseDuck

Read all 53 reviews on Udemy

Learn The Basics of PostgreSQL For Beginners
Visit course on Udemy Write a review
  • Video Duration: icon 2.9h
  • Price: $39.99
  • Provider: icon Udemy
  • Updated: icon November 2020
  • Level: Beginner Beginner
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com