The Basics of PostgreSQL Database

Ahmad Mohey, Software Developer & Instructor

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
21 Lessons (2h 16m)
    • 1. Introduction To The Course

      2:47
    • 2. What is Relational Databases and What PostgreSQL

      3:40
    • 3. Install PostgreSQL

      3:35
    • 4. PgAdmin

      3:51
    • 5. PostgreSQL Database on AWS

      11:50
    • 6. Create and Drop Databases in PostgreSQL

      6:04
    • 7. Create Users

      14:34
    • 8. Grant Privileges

      6:58
    • 9. Database Schema

      6:53
    • 10. Exercise Create Database, Schema and User

      2:35
    • 11. Database Tables

      11:36
    • 12. Data Types

      2:53
    • 13. Primary Keys

      7:58
    • 14. Constraints

      5:36
    • 15. Exercise Create Tables Employees and Jobs

      8:25
    • 16. Foreign Keys

      13:27
    • 17. Execrise Create Tables Previous Experience

      5:09
    • 18. Import Data Into Database

      5:16
    • 19. Exercise Import Data (Employees and Cities)

      3:06
    • 20. Entity Relationship Diagram (ERD) DbVisualizer

      8:57
    • 21. The Final Lecture

      1:00

About This Class

  Welcome to 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.