Hands-On PostgreSQL Project: Spatial Data Science. This interactive, hands-on course teaches you how to perform advanced spatial SQL operations on a local database. Instructor Maggie Ma shows you how to set up a local DBeaver pgAdmin 4 database, import public data, and run PostGIS SQL queries to perform spatial joins. This course is ideal for database administrators and data scientists who want to learn more about the value of spatial data. Spatial data science is currently very popular, and its appeal is not limited to just a few specific fields. Its real-world applications are vast, and it is used in a wide range of industries, including aerospace, agriculture, urban planning, and technology.
What you will learn:
- Setting up a local DBeaver database pgAdmin 4
- Importing general data into the database
- Running PostGIS SQL queries to perform spatial joins
- Understanding the value of spatial data in different industries
This course is suitable for people who:
- Want to improve their spatial SQL skills
- Seeking a deeper understanding of spatial data
- Want to use spatial data to solve real-world problems
- Are looking for a practical and interactive course
