4.65 out of 5
4.65
28 reviews on Udemy

Learn The Basics of PostgreSQL For Beginners

The practical guide to learn the basics of PostgreSQL and pgAdmin for beginners.
Instructor:
Ahmad Mohey
1,143 students enrolled
English [Auto-generated]
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.

  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.

Introduction to PostgreSQL and Cloud Databases

1
Introduction to The Course

Introduction to the course, to show you what we are going to discuss in the next section.

2
What is Relational Databases and PostgreSQL?

In this lecture you will understand what is relational databases and what is PostgreSQL.

3
Relational Databases (Article)
4
Install PostgreSQL

Now we are going to install the download and install PostgreSQL database engine.

5
pgAdmin

pgAdmin is a tool which will enable us to perform different tasks on the PostgreSQL database engine.

6
PostgreSQL (Article)
7
PostgreSQL Database on Amazon Web Services (AWS)

Now we are going to create a PostgreSQL instance on Amazon Web Services (AWS).

8
Amazon Web Services - AWS RDS (Article)
9
Summary

Summary of the section to remind you of the points we discussed in brief.

Databases, Users and Privileges In PostgreSQL

1
Create and Drop Databases in PostgreSQL

In this lecture you are going to learn how to create and drop PostgreSQL databases.

2
Create Users

Now you will learn how to create users in PostgreSQL.

3
Grant Privileges

After we created users in the database, now it's time to see how to grant them privileges.

4
Database Schemas

In this lecture you will understand what is a database schema and why developers use schema and how to create them.

5
Exercise : Create Database, Schema and User

Now it's time for an exercise to test your knowledge on what you have learned.

6
Summary

Summary of the section to remind you of the points we discussed in brief.

Database Tables, Primary and Foreign Keys In PostgreSQL

1
Introduction to The Chapter

Introduction to section three.

2
Database Tables

In this lecture you are going to work with the most important database object which is the tables, think of tables as the heart of relational databases.

3
Data Types

In this video we are going to explore some  of the PostgreSQL datatypes.

4
Primary Keys

Now it's time to discuses one of the most important concepts in relational database which is primary keys, you are going to learn how to create them in different ways.

5
Constraints

Let's dive deeper in creating tables with applying constraints to the columns.

6
Exercise : Create Tables Employees and Jobs

In this exercise you are going to build some of the tables for the human resources database.

7
Foreign Keys

In this lecture we are going to see how to create foreign keys and make relationships between tables.

8
Exercise : Create Table Previous Experience

In this exercise you will be asked to create a new called contains the previous experience of employees in case some employees had experience in the past.

9
Import Data Into Database

This is an interesting lecture we are going to fill our tables with data using Import wizard feature in pgAdmin.

10
Exercise : Import Data (Employees and Cities)

A small exercise on how to import data and continue fill our database with data samples.

11
Entity Relationship Diagram (ERD) - DbVisualizer

We have an interesting lecture, we are going to see how to generate ERD and visually view database objects and track relationships.

12
Summary

Summary of the section to remind you of the points we discussed in brief.

13
The Final Lecture

Questions and Answers

1
Part 1 (Questions 1 to 5)

BONUS SECTION

1
BONUS LECTURE : Install SQL Server

In this bonus lecture we are going to see how to install the SQL Server.

For the full course follow the link in the resources or check my other courses.

2
BONUS LECTURE : Management Studio

In this bonus lecture we are going to install the Management Studio...The tool that will allow use to perform different tasks on the SQL Server database engine.

For the full course follow the link in the resources or check my other courses.

3
BONUS LECTURE : SQL Server Database on Microsoft Azure

In this bonus lecture you will learn how to create a SQL Server database instance on Microsoft Azure.

For the full course follow the link in the resources or check my other courses.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.7
4.7 out of 5
28 Ratings

Detailed Rating

Stars 5
12
Stars 4
14
Stars 3
2
Stars 2
0
Stars 1
0
db4db252446b699dce78d34eec18b354
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
4 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion