POSTGIS: How to connect a spatial database to QGIS | Write SQL Queries in QGIS

Working on a spatial database on QGIS is an easy-to-visualize query result in real-time. This QGIS/PostGIS tutorial will help you connect a spatial database and write queries directly on QGIS. The tutorial assumes you have PostGIS spatial extensions properly installed, if you don’t, check the referenced video section of this description.
----------------------------------------------------------------
This PostGIS tutorial will show you:
How to create a database using PgAdmin
How to create a spatial extension
How to connect a database to QGIS using the data source manager tool
How to set authentication for a database
How to access the Database management tool on QGIS
How to create schemas in a database
How to write queries, save, and load them to the QGIS workspace
How to import and export layers
How to save results to the QGIS database.
----------------------------------------------------------------
How to download and install PostgreSQL and its spatial extensions = • How to Download and In...
How to create a database using PgAdmin = • PostgreSQL: Create Dat...
How to import files to QGIS = • How to import vector (...
#HASHTAGS
#PostGIS #spatialSQL #QGIS
----------------------------------------------------------------
Want to reach me? Check the about section for links to my social media handles and direct contacts.

[@francisotia4370]

Super work here.
Please Sir, can this be done on MYSQL also?

[@spatialdatahub]

Thanks, sir!!
My SQL works, but I haven't tried it before. I'll be sure to update this comment when I do.