SQL Spatial Course

This course is designed to provide GIS or Database Administrators with an additional skill set that will further enhance their analysis skills within a spatial context.

 

With the advent of SQL2008 it is now possible to store object geometry within the SQLSERVER database. This provides greater possibilities with regards to spatial operations within a database environment.  This course is designed to show how to use the SQL spatial commands to their full extent, create spatial queries and explore the possibilities of using the SQL geometry data type.

 

We recommend users that sign up for this course have a prior understanding of SQL, databases and basic GIS functionality. 

Book Now  Ask Us A Question

Course Outline

Overview of the SQL server

Spatial data types and tables

Geometry Vs geography

Uploading, maintaining, deleting and restoring spatial data

Spatial indexing

Views (thematic, complex joins)

Stored procedures

SQL spatial commands

Well known text

Well known binary

SRID

Intersections

Buffers

Extracting coordinates

Union and aggregate unions

Minimum bounding rectangle

Distance

Nearest calculations

Book Now   Ask Us A Question

Training Booking Form

To book a course please fill out the form below and send it back to us.

Download Training Booking Form PDF