Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

PostgreSQL: From Beginner to Intermediate

Name: PostgreSQL: From Beginner to Intermediate
Rating: 4.6 (58 reviews)

Learn Database and SQL From Zero to Intermediate, Become Able to Create a Whole Database From Scratch by Coding ONLY!

Created byMoustafa Ahmed Abd El-Azim, Blink Data

Last updated 2/2026

English

What you'll learn

Create a Whole Database From Scratch by Coding SQL
Dive into PostgreSQL Database Management System
Practice through Coding Exercises, Practice Texts and Assignments
Pure SQL Coding through Windows Command Prompt
Master The Fundamentals of Databases
Learn How To Create Users and Grant or Revoke Privileges
Gain an Emersive Understand of Manipulating Data in a Database using SQL
Learn how to insert, update, remove and retrieve data using SQL
Learn how to join data together from more than one table.
How to group data together and apply statistical computations

Coding Exercises

This course includes our updated coding exercises so you can practice your skills as you learn.

Course content

7 sections • 44 lectures • 2h 22m total length

Course Introduction3:13
Introduction to Database3:11
Explore the fundamentals of databases with PostgreSQL, from file-based systems to modern database management, including data redundancy, isolation, and the client–server workflow across front end and back end.
Relational VS Non-Relational Databases3:14
Compare relational and non-relational databases, focusing on tabular data, tables, and relationships, and show how SQL manages entities, attributes, and 1 to 1, 1 to many, and many to many.
Relational Database Management Systems (RDBMS)2:38
Introduction to SQL4:47
Explore sql command types: ddl, dcl, and dml, with definitions of create, drop, alter, truncate, grant, revoke, and their use in managing tables and data.
[Important] Resources0:14

Important Note0:35
PostgreSQL Download and Installation2:44
How to Initiate PostgreSQL in Command Prompt2:41
Learn to start PostgreSQL from the command prompt by locating cmd, updating the PostgreSQL install path in PATH, then running psql -U POSTGRES and entering your password to access SQL.
Ubuntu Download and Installation (Optional)2:26
PostgreSQL Package in Ubuntu (Optional)1:20
Install the postgresql package on Linux via the terminal for Mac and Windows users. Run sudo apt-get install postgresql postgresql-contrib and approve the disk space prompt.

CREATE DATABASE3:29
CREATE TABLE5:24
Connect to database, then create an employee table with id as serial primary key and first_name and last_name as varchar(50), and verify with backslash c and backslash d t commands.
CREATE USER4:47
Learn to create PostgreSQL users using the super user, with optional passwords, valid until dates, and the option to create a database.
SQL Constraints2:31
Explore sql constraints, including primary key, foreign key, not null, unique, and check; learn how keys ensure unique, non-null identifiers and link tables through references.
Data Types in PostgreSQL4:33
Explore why data types matter in PostgreSQL for accuracy, storage, and speed, and review core types such as integers, floats, serial, text, date/time, and boolean.
DDL Practice Test
Practice Test 17:29
DROP3:03
DROP USER1:31
Connect to PostgreSQL using the super user Posterous and learn how to remove a user. Execute drop user with the target name and verify by listing users again.
TRUNCATE2:21
ALTER8:20

INSERT7:21
Learn how to insert data into a PostgreSQL table using the insert command, create an employee table with id, name, and salary, and use both column-listed and unnamed insert forms.
DELETE3:29
Use the delete command to remove a specific row or all rows from a table, using a where clause with a primary key such as employee ID.
DROP - TRUNCATE - DELETE Summary1:36
Learn the differences between drop, truncate, and delete: remove a table or database, clear table data while preserving structure, or delete specific records, with rollback considerations.
UPDATE3:35
SELECT3:14
Learn to use the select command to retrieve all data or specific columns from a table, and filter by a where clause to view employee names and salaries.
Practice Test 32:36
Practice test three demonstrates using data manipulation language commands—insert, update, select, and delete—on an employee table, including inserting id five, updating salary from 5000 to 6000, and deleting the record.
ALIAS1:08
Operators1:57
Learn to perform arithmetic operations in PostgreSQL using addition, subtraction, multiplication, and division; compute new salaries by multiplying by two and alias the result as new_salary.
Comparison Operators1:43
ORDER BY2:23
Aggregate Functions4:20
DISTINCT1:41
Discover how to use the distinct clause with a select statement to suppress duplicate values when retrieving one or more attributes in PostgreSQL, illustrated with department names.
LIMIT1:18
Learn how the PostgreSQL limit clause retrieves a specific number of rows from a table, exemplified by getting the first two rows from a department table.
GROUP BY and HAVING3:49
JOINS INTUITION1:55
INNER JOIN5:23
Master inner join to link country and state tables by country_id and retrieve matching records, including country id, country name, and state name, as shown with Egypt and USA.
OUTER JOIN (Left, Right and Full)4:14
Learn how left outer join, right outer join, and full outer join work with country and state data linked by the country_id key.
CREATE VIEW3:39
Create a view as a virtual table to copy selected data from department, enabling safe computations and privilege management by granting access to specific columns like department name and salary.

Requirements

There are no requirements for this course. Your interest in the topic and your commitment to learning are all you need to achieve the utmost benefit from this course.

Description

Why should you enroll in this course?

This course is made to be concise and to the point, To up your skills and waste no time (No fillers, etc)
Perfectly covers the fundamentals of Databases and the basic topics of SQL up to the intermediate topics in SQL and PostgreSQL.
It's beginner user-friendly, Starting with those who have no clue about SQL to up their skill level from Beginner to Intermediate.
Comprehensive and easy-to-understand tech content.
It covers all business categories therefore, No matter what industry you're working in/want to work in, This course is for you.
On-Video and Off-Video practice tests, Coding Exercises, and Downloadable Resources to help you learn and practice simultaneously.
This course is all about coding, We will not use any software where you click on buttons to create a database, We will code only step-by-step
All your queries and questions will be answered by the instructor directly.
Finally, This course is updated regularly to match the latest PostgreSQL updates, Hence, You won't have to take another path.

What will you learn in this course?

Learn what's a database and what are database management systems available.
What are a Relational Database and A Non-Relational database?
What's SQL?
What are constraints and data types in SQL?
How to code SQL to create a database, Tables, and Users?
How to insert data into a database/table through coding SQL?
How to code SQL to update the structure of a database and tables?
How to remove a database, tables, and Users?
How to grant and revoke privileges from a User?
How to manipulate data in a database using SQL?
How to sort and group data in a database using SQL?
How to join more than one table together?
Practice SQL along the way through Quizzes, Practice Tests, and Coding Exercises.

What makes this course different from the other courses?

This course targets beginners and ups their skills to intermediate.
It validates your progress through on-video practice tests, Off-video practice tests, and Coding Exercises.
It offers auto-generated subtitles in more than 3 languages including (Arabic, Hindi, and Spanish)
Less than 8 hours avg response time (By the instructor)
Regularly updated downloadable resources.

What our students say about this course:

I started from nothing in SQL to a great level now because of this course, What truly made the difference was the easy to digest content, practice tests and coding exercises, totally recommended.
Exceptional, The coding exercises made the material easy to memorize and the overall experience is exceptional.
This course was short but very informative and rich with content and practices.

Why PostgreSQL and not MySQL?

PostgreSQL and MySQL are the two top open-source relational database management systems, Despite them being similar yet there are a number of differences, Some of them are:

PostgreSQL has more data types than MySQL, which is great for database optimization.
PostgreSQL performs better than MySQL in terms of the high volume of reads and writes applications.
PostgreSQL has multiple encrypted security-related connection options in comparison with a lower number to MySQL.

In conclusion, The ultimate decision relies on a personal choice despite the fact that PostgreSQL has more benefits.

Finally, By the end of this course, You will confidently be able to execute SQL codes to create and control a database, Insert, Delete, Update and Manipulate data in a database, Create, remove and control privileges of users in a database, and finally grouping, joining data from multiple tables and apply statistical operations on data.

Take the leap and enroll with us today. We can't wait to play a vital role in your journey to success.

Who this course is for:

Anyone who wants to learn about databases and how to communicate with them.

PostgreSQL: From Beginner to Intermediate

What you'll learn

Explore related topics

Coding Exercises

Course content

Getting Started6 lectures • 17min

Necessary Softwares (Download/Installation)5 lectures • 10min

SQL: Data Definition Language10 lectures • 43min

SQL: Data Control Language3 lectures • 14min

SQL: Data Manipulation Language18 lectures • 55min

Coding Exercises1 lecture • 1min

SQL Interview Questions1 lecture • 2min

Requirements

Description

Who this course is for: