Back-To-School Deals - hours only!Up to 80% off on all courses and bundles.-Close

Description

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!

Map of San Francisco

Are you ready? Let's jump right in!

Requirements

  • A web browser
  • Knowledge of basic SQL, including the JOIN and GROUP BY clauses

Objectives

  • Learn what spatial databases are
  • Learn the basics of working with PostGIS, a spatial extension of PostgreSQL
  • Learn how geographical data is stored in a database
  • Learn about the basic geographical functions available in PostGIS
  • Learn how to write SQL queries using geographical functions

Who Should Take This Course?

  • Students taking classes on relational databases
  • Anyone who wants to learn how to use spatial databases
  • Developers working with geographical data
    Start for free
    Gift this course

    Bundle deals

    87%
    off

    Reg. price
    $1551

    One to Rule 'Em All

    Includes 41 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, Introduction to R, Tidyverse, Data Visualization 101, 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, How to Read and Write CSV Files in Python, Introduction to Python for Data Science, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, Creating Basic SQL Reports in PostgreSQL, 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

    Bundle price $199

    36 hours left at this price!

    73%
    off

    Reg. price
    $359

    SQL Complete Track

    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 $95

    36 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 148 exercises done

    1. Introductory Quiz

    Not sure if you're ready to take this course? Take this preliminary quiz to find out.

    More details Less
    Start now

    0% completed 0 of 8 exercises done

    2. Introduction to spatial databases and PostGIS

    We're getting started with PostGIS. You'll learn the basic terminology related to spatial databases.

    More details Less
    Start now

    0% completed 0 of 6 exercises done

    3. Geometry basics

    That's where the real fun begins. You'll get to know points, linestrings and polygons.

    More details Less
    Start now

    0% completed 0 of 38 exercises done

    4. Relationships between geometries

    How can points, linestrings and polygons relate to each other? Let's find out in this part of the course.

    More details Less
    Start now

    0% completed 0 of 29 exercises done

    5. Additional geometry features

    In this part, we'll present further spatial functions and introduce collections.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    6. Geography

    Finally, it's time to get to know geography column type.

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    7. Practice

    Do you think you remember everything from our course? It's time to practice before the final quiz.

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    8. Final quiz

    The time has come to test your knowledge in the final PostGIS quiz.

    More details Less
    Start now

    0% completed 0 of 12 exercises done

    Reviews

    Average rating

    4.3/586.66666666666666 (6)

    Details

    5 Stars 83%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 17%
      Load more reviews

      Comments

      0