Beginner's Guide to Database

SQL

SQL is the query language for updating/fetching data from Database.

1. Learn SQL In 20 Minutes | TutorialZine

The most commonly used SQL Commands to get a basic hang of SQL are listed below.

1. SELECT
2. INSERT
3. UPDATE
4. WHERE
   
5. LEFT JOIN
6. DELETE
7. DROP

Postgres

Below are a collection of useful Pi Genie wiki articles related to Postgres Database.

1. Stopping and Starting Postgres SQL Database Server
2. Force Deleting a Postgres Database
3. Creating Migration Query in Postgres

PostgreSQL Cheat Sheet