Learn how to work with maps in SQL
Did you know that databases can store geographical data? With the help of spatial extensions, a database can store the locations of stores, ATMs, hotels, streets, districts, and other points of interest. Moreover, you can use SQL queries to process this information.
In this course, you'll learn about PostGIS, a spatial extension of the PostgreSQL database. You will learn how PostGIS stores geographical data and how its basic geographical functions can be used in simple and complex SQL queries.
To make your learning process more interesting, we'll be working with both real and not-so-real places in San Francisco and the United States. Additionally, we've prepared a special surprise—some exercises will even let you see the results of your queries drawn on a real world map!
Are you ready? Let's jump right in!
92%
off
Reg. price
$1372
Includes 36 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python
Bundle price $99
37 hours left at this price!
87%
off
Reg. price
$359
Includes 9 courses SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Window Functions, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, PostGIS
Bundle price $45
37 hours left at this price!
86%
off
Reg. price
$324
Includes 8 courses SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Creating Basic SQL Reports in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS
Bundle price $45
37 hours left at this price!
Not sure if you're ready to take this course? Take this preliminary quiz to find out.
0% completed 0 of 8 exercises done
We're getting started with PostGIS. You'll learn the basic terminology related to spatial databases.
0% completed 0 of 6 exercises done
That's where the real fun begins. You'll get to know points, linestrings and polygons.
0% completed 0 of 38 exercises done
How can points, linestrings and polygons relate to each other? Let's find out in this part of the course.
0% completed 0 of 29 exercises done
In this part, we'll present further spatial functions and introduce collections.
0% completed 0 of 19 exercises done
Finally, it's time to get to know geography column type.
0% completed 0 of 18 exercises done
Do you think you remember everything from our course? It's time to practice before the final quiz.
0% completed 0 of 18 exercises done
The time has come to test your knowledge in the final PostGIS quiz.
0% completed 0 of 12 exercises done
