Learn SQL fast with PostgreSQL

Among the many SQLs like sqlite, MYSQL, MSSQL, Oracle and many more, PostgreSQL is a good choice to learn SQL for the following reasons:

  • - It is the most advanced free and open source relational database
  • - It emphasizes extensibility and SQL compliance
  • - It is supported by all major operating systems
  • - It handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

Learning Strategy

The motivation to publish this note is not to queue behind the already saturated contents on SQL but to introduce a unique method of learning that worked for me which I confidently believe will work for you as well, especially if you thought of wishing for a different pathway to learning. To understand my approach, click here.

Basic and General

Postgres has got some commands to help with exploration of the language. They are categorized as follows:
- General: \copyright | \crosstabview | \g | \q - to quit
- Help: To list a comprehensive list of commands - \? | To display help for stated command - \h [command]

CREATE POSTGRESQL Objects