The Basics of PostgreSQL Database | Ahmad Mohey | Skillshare

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