Have a question?
Message sent Close
4.55 out of 5
4.55
66 reviews on Udemy

Manage spatial data with Microsoft SQL Server

Spatial SQL: a language for geographers
Instructor:
Arthur Lembo
1,090 students enrolled
English [Auto]
Students who complete this task will be comfortable writing traditional SQL and spatial SQL within SQL Server. They will understand how to address different data types, functions, and SQL workflows for traditional and spatial data operations.

Are you a database user who wants to learn about spatial data analytics?  Are you a GIS professional stuck in a rut of only knowing how to use a GIS GUI? Do you want to learn how to automate tasks, but are afraid of computer programming. If so, SQL is the most powerful tool you can learn to help you perform complex GIS tasks. This course is designed to teach you how to write SQL to replicate many database and GIS tasks using Microsoft’s SQL Server. We will start at a very basic overview, and then proceed to more advanced topics related to GIS.

Through a series of lectures, I will work side-by-side with you to develop SQL queries in SQL Server that perform advanced GIS tasks, some of which might be impossible to perform in the GUI. Once my students learn GIS, they very rarely want to return back to using the GUI.

By writing SQL code alongside me, you will see how solving GIS tasks in SQL is like a second nature. This is a very comprehensive course that should take multiple days to complete – but don’t worry about that – you will be having a lot of fun learning how powerful SQL can be, and continually ask yourself “why didn’t I start using SQL sooner!”

Starting the Course, Loading Software and Data

1
Install SQL Server and SQL Server Management Studio

For this lecture, students will download and install SQL Server and SQL Server Management Studio

2
Install Data

This lecture will allow show you how to load the Annapolis.bak file into SQL Server.  Make sure to download the file annapolis.zip, and unzip it.  The video will step you through the steps to restore the database.

3
Course Overview

Overview of SQL

1
Is Spatial Special?

This lecture will present some of the arguments people use to discourage the use of SQL.  It will also begin to answer why SQL is actually a preferable language for managing data. 

2
Why SQL is Superior

This lecture will continue to build the case for why SQL is superior to other methods of manipulating data.  Further, it will present the argument that SQL is actually far superior than traditional GIS processes.   

SQL Data Types

1
Numeric Data Types
2
Boolean operations
3
Character Operations
4
Date and Time Functions
5
Spatial Functions

Traditional SQL Statements

1
Select Statement
2
Group By Statement
3
Case Statement
4
SQL Potpourri
5
Editing data in SQL Server

Spatial Functions for Vector Data

1
Spatial Type Functions
2
Spatial Functions (mop up)

Geographic Models

1
Nearest Neighbor Index
2
Huff Model for Retail Gravitation
3
variogram of last spring frost data

Bonus: Real World Example

1
flooding and emergency response
2
Course completion, and where to go next
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.6
4.6 out of 5
66 Ratings

Detailed Rating

Stars 5
25
Stars 4
34
Stars 3
5
Stars 2
1
Stars 1
1
fd8feee1011d2456abb626b63765ad36

Includes

4 hours on-demand video
Certificate of Completion

About

AulaGEO is a Ge-engineering specialized academy.

Social Network

Udemy Black Friday Sale! Top Courses From $9.99