Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
8 Hour(s) 18 Minute(s)
Language
English
Taught by
Shoaib Shahzad Obaidi
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Unlock the Power of Spatial Databases: Master PostGIS and Harness Spatial Queries for Geospatial Excellence.
Are you ready to dive into the world of PostGIS and spatial queries?
This comprehensive course is designed to equip you with the knowledge and skills to harness the potential of geographic information and spatial data analysis. From building and managing databases to executing complex SQL queries, you'll gain hands-on experience in a wide array of topics.
The course begins with an introduction to PostgreSQL, followed by lessons on creating databases and importing tables using PostGIS loader. You'll delve into SQL terminologies and learn to execute and specify SQL statements effectively. Explore various SQL queries, including statements, OR-AND operators, and query limits.
Next, discover the magic of spatial functions, mathematical statements, and CRS, EPSG, and SRID concepts. You'll learn to create spatial tables, insert spatial values, and import files into the PostGIS database seamlessly. Uncover the potential of spatial aggregate functions, spatial joins, and constructing functions for advanced data analysis.
The course also covers essential PostgreSQL features, such as triggers, database backup, and restore. Additionally, you'll find valuable insights on finding EPSG codes in ArcGIS Pro, QGIS, and PostgreSQL base map.
Prepare to unlock the full potential of geospatial data analysis and visualization. Whether you're a GIS enthusiast, a data scientist, or a professional in a related field, this course will equip you with essential skills to leverage spatial information effectively.
Join us on this journey, and let's delve into the world of PostGIS and spatial queries together!
Course Content
- 2 section(s)
- 43 lecture(s)
- Section 1 Postgres Installation and PostGRES Configuration
- Section 2 Hands-on Spatial, Non-Spatial Queries and Aggregate functions
What You’ll Learn
- Understanding Spatial Data
- Setting up PostgreSQL and PostGIS
- Spatial Data Management
- Spatial Querying with SQL and Geospatial Analysis
Skills covered in this course
Reviews
-
GGeorge Theodoropoulos
Excellent course!!
-
RR Achmann
repeating so much, wasting time do so, seeing 3 or 4 repeats in subsequent lesssons and I thought the ability to know SQL was a must to get into Spatial queries
-
GGraciela Rosas Calvo
muy interesante y hasta el momento he aprendido bastantes cosas
-
IIzza Prasatya Arief
I think this course is suitable for people who want to learn PostGIS and spatial data query from scratch. So far it is a good course and I'm looking forward to learn more.
