Manage spatial data with Microsoft SQL Server
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
775 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Manage spatial data with Microsoft SQL Server to your Wishlist.

Add to Wishlist

Manage spatial data with Microsoft SQL Server

Spatial SQL: a language for geographers
4.7 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
775 students enrolled
Created by Dr. Arthur Lembo
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $30 Discount: 67% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • While it is not an absolute necessity, students taking this course should be familiar with spatial data concepts and have some familiarity with database technology.
Description

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!"

Who is the target audience?
  • This course is targeted toward database professionals who want to learn how to leverage spatial data constructs within SQL Server to solve spatial problems. While there are many databases that support spatial constructs, this course will focus on the use of SQL Server to accomplish these tasks.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
22 Lectures
04:01:09
+
Starting the Course, Loading Software and Data
3 Lectures 15:44

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

Preview 05:28

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.

Install Data
03:17

+
Overview of SQL
2 Lectures 30:47

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. 

Preview 12:25

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.   

Why SQL is Superior
18:22
+
SQL Data Types
5 Lectures 59:33
Numeric Data Types
15:50

Boolean operations
02:48

Character Operations
10:52

Date and Time Functions
12:05

Spatial Functions
17:58
+
Traditional SQL Statements
5 Lectures 01:03:34
Select Statement
12:05

Group By Statement
17:06


SQL Potpourri
17:10

Editing data in SQL Server
11:57
+
Spatial Functions for Vector Data
2 Lectures 28:16
Spatial Type Functions
17:47

Spatial Functions (mop up)
10:29
+
Geographic Models
3 Lectures 27:04
Nearest Neighbor Index
07:02


variogram of last spring frost data
05:53
+
Bonus: Real World Example
2 Lectures 16:11
flooding and emergency response
11:39

Course completion, and where to go next
04:32
About the Instructor
Dr. Arthur Lembo
4.3 Average rating
818 Reviews
4,521 Students
11 Courses
Professor

Dr. Arthur J. Lembo, Jr. is an educator with a passion for GIS and almost 30 years of GIS industry experience.

Currently, Dr. Lembo is an Associate Professor in the Department of Geography and Geosciences at Salisbury University, where he is also the Technical Director of the Eastern Shore Regional GIS Cooperative. Dr. Lembo has published numerous academic papers on GIS, authored a leading textbook on Statistical Problem Solving in Geography, and conducted sponsored research for organizations like the National Science Foundation, NASA, the United States Department of Agriculture, and the Kellogg Foundation.