PostgreSQL - Course

Here are the things I have learned, you can use this as a roadmap if you want to learn from basic SQL up to advanced SQL with PostgreeSQL.

We will be working with TablePlus or PgAdmin, and we will also need to have Docker installed on our system. If you have never worked with Docker before, don't worry, it's simple.

Required Installations

• Docker

• TablePlus

Prepare the enviorement

1. Create a folder for the course..

2. Download the docker-compose.yml file into the folder.

3. Open the terminal and run:

   docker pull postgres:15.3
   docker pull dpage/pgadmin4
   

4. Now navigate from the terminal to the newly created folder and run:

   docker compose up -d
   

5. Close the terminal

Database Connection

• Table plus

  Open TablePlus and add a new PostgreSQL connection. Fill in the fields with the following information:

  Name      :   learning-sql 
  Host      :   localhost
  Port      :   5432
  User      :   student
  Password  :   123456
  Database  :   course-db
  

  Then, click on connect.

• PgAdmin

  Open a browser tab, in the address bar enter localhost:8080. Log in with the following credentials:

  Email Address :  student@google.com
  Password      :  123456
  

Sections

1. Basics and First Steps

   • Uploaded

2. Aggregate functions, Grouping and Ordering

   • Uploaded

3. Relations Key and Constraints

   • Uploaded

4. Data separation in other tables

   • Uploaded

5. Joins-Unions

   • Uploaded

6. Queries Dates, Intervals and Function

   • Uploaded

7. Generation of Primary Keys

   • Uploaded

8. Database Design

   • Uploaded

9. Database Exercises and Functions

   • Uploaded

10. Database Design II

    • Uploaded

11. Views, Materialized Views, and Common Table Expressions (CTE)

    • Uploaded

12. Custom Functions

    • Uploaded

13. Store_procedures

    • Uploaded

14. Triggers_Functions_and_Procedures

    • Uploaded

🔗 Connect with me

---