Great and informative course. More in-depth than I anticipated.
Introduction to Spatial Databases with PostGIS and QGIS 3
Learn Spatial SQL and database management for GIS Professionals
Lectures -69
Resources -2
Duration -12 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course is intended to provide an introduction to spatial databases in general and PostGIS in particular to GIS professionals who are interested in expanding their skillset to multi-user enterprise level spatial databases. You will learn
What a spatial database is and why you would want to use one.
What SQL is, why you would want to use it, and how it can be applied to geospatial concepts.
How to install PostGIS locally for development purposes and how to access a production version via a network or the internet.
How to load your spatial data into PostGIS and access it from a variety of clients, especially QGIS
The basics of SQL for both spatial and non-spatial queries
How to validate data and control user access with the tools built-in to PostGIS
Optimizing your queries for the best performance
How to work with raster data in PostGIS
The basics of programming custom functions with PL/pgSQL
The basics of database administration to keep your database operating smoothly
Goals
- Setup an instance of PostgreSQL and PostGIS either locally or accessible via the internet.
- Access your PostGIS instance and load your own geospatial data.
- Utilize PostGIS data from a variety of clients (Primarily QGIS, but also ArcGIS, pgAdmin4, web clients, and more)
- Learn to create new tables, modify existing tables, and view existing data via SQL
- Perform geospatial analysis using Spatial SQL
- Control user access to your data with roles and privileges
- Automate the datbase with custom functions
- Deploy your database to an internet accessible server
Prerequisites
- Basic understanding of QGIS (displaying geospatial data, etc.)
- Desire to expand your knowledge of multi-user spatial databases.
![Introduction to Spatial Databases with PostGIS and QGIS 3 Introduction to Spatial Databases with PostGIS and QGIS 3](https://d3mxt5v3yxgcsr.cloudfront.net/courses/4482/course_4482_image.png)
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
5 Lectures
-
Introduction 06:31 06:31
-
What can a spatial database do for you? 10:09 10:09
-
What exactly is a spatial database? 13:56 13:56
-
Where does a spatial database live? 08:09 08:09
-
What is SQL and why would you want to use it? 13:14 13:14
Installing software and loading data
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Data Query Language - SQL queries for non-spatial data
12 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Making SQL Spatial - Introduction
8 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Making SQL Spatial - Advanced Topics
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
SQL Data Definition Language
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
SQL Data Manipulation Language
5 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
SQL Data Control Language
4 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Automation
7 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Deploying your database
6 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Miscellaneous
2 Lectures
![Tutorialspoint](/market/public/assets/images/loader.gif)
Instructor Details
![Michael Miller](https://www.tutorialspoint.com/assets/profiles/323998/profile/200_73624-1620217052.jpg)
Michael Miller
I have been programming and working with database applications for over 30 years, and specializing in geospatial applications for over 20 years. I am a believer in the 80/20 pareto principle which suggests that you only need to understand 20% of a subject in order to do 80% of your work. My goal in all my courses is to teach at the level of that 20% sweet spot and to provide my students with the background and the tools they need to learn the rest of what they need on their own.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Feedbacks
I have learnt a lot from this course it . It was very informative and I would recommend it to anyone interested in GIS and SQL
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now![Annual Membership Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)