Please visit the official tutorial at.
https://postgis.net/workshops/postgis-intro/