PostgreSQL - Finish

• Wed, Jun 15, 2022
• One-minute read

I finished the course Learn PostgreSQL Tutorial - Full Course for Beginners.

What have I learned?

I’ve learned the fundamentals of using Postgres.

• What’s a Relational Database?
• How to manipulate a Database?
  • Create a Database.
  • Create, drop and alter tables.
  • Insert, delete and update records.
  • Ordering (ORDER BY) and Grouping (GROUP BY) queries.
  • How to deal with date and time?
  • Primary keys, Foreign keys, and Constraints
    • How to deal with conflicts?
  • Create relationships between tables and join tables.
  • UUIDs
• How to generate mock data?

What’s the next?

Now I have some basic knowledge about using Postgres, and I’m ready to get my feet wet.

I’ll create a toy service with a Postgres database. I’m sure I can get deeper into Postgres when tackling future problems.