PostgreSQL Tutorial: SQL for beginners in PostgreSQL [EN]

[PostgreSQL tutorial] In this video, I will show you and explain step by step, SQL for beginners in PostgreSQL on Windows 10.

==== What is PostgreSQL ====
PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and technical standards compliance. It is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. It is the default database for macOS Server and is also available for Linux, FreeBSD, OpenBSD, and Windows.

==== What is PostGIS ====
PostGIS is an open-source project, and support is available from a number of sources. It is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL and compiles with open geospatial consortium (OGC).

==== What is SQL ====
SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them. Initially created in the 1970s, SQL is regularly used not only by database administrators, but also by developers writing data integration scripts and data analysts looking to set up and run analytical queries.

============================
0:09 Select Statement (SELECT *)
2:41 Select Statement
4:06 DISTINCT Clause
502 WHERE Clause
6:00 AND/OR Clause
6:41 BETWEEN Clause
7:36 LIKE Clause
8:21 ORDER BY Clause
10:21 COUBT Clause
11:11 INSERT INTO Statement
12:27 UPDATE Statement
13:47 DELETE Statement
14:44 DROP TABLE Statement

============================
GIS4Dev : GIS for beginners
QGIS for beginners, QGIS tutorial, GIS tutorial, GIS web services tutorial, WMS tutorial, WMTS tutorial,
WFS tutorial, WCS tutorial, Google Earth Engine tutorial, ESRI ArcGIS tutorial, Postgresql tutorial, Postgres tutorial,
PostGIS tutorial, GeoServer tutorial for beginners, GeoServer tutorial, OGC, open source software, Google Maps, How to use Google Maps, Google Map tutorial

============================

============================

============================
#PostgreSQL #SQL #Query #GIS #Shapefile #Extension #Plugin #Windows #PgAdmin4 #geo #geospatial #mapping #geography #spatial

[pattrawuth]

SQL (Structured Query Language) is a standardized programming language that's used to manage relational databases and perform various operations on the data in them.