SQL Server Spatial Core Skills
SQL Server is easy to start working with but there can be a lot to learn before you can build the most useful applications on it.

One of the most important additions to SQL Server has been the introduction of the spatial data types. This course is one of our most favourite courses and covers SQL Server spatial data, how to load it, index it, and work with it.

The course is targeted at application developers that are creating systems that work with spatial data, and also to existing SQL Server developers and DBAs.

While our courses are based on SQL Server 2016, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.

Course Price
Early Bird Price
There isn't a public offering for this course scheduled at present but please contact us to register your interest or to request a quote for private training.
Introduction to SQL Server Spatial Data
- Core Spatial Concepts
- Spatial Reference Systems
- OGC Specifications
- OGC Shape Definitions
- LAB: Introduction to SQL Server Spatial Data
Loading SQL Server Spatial Data
- Working with GEOMETRY and GEOGRAPHY Data Types
- Importing Spatial Data into SQL Server
- Geocoding Locations
- LAB: Loading SQL Server Spatial Data
Querying SQL Server Spatial Data
- Querying Spatial Properties
- Calling Spatial Methods
- Working with Spatial Aggregates
- Working with Enhanced Precision
- LAB: Querying SQL Server Spatial Data
Indexing SQL Server Spatial Data for Performance
- SQL Server Spatial Index Core Concepts
- Indexing GEOMETRY Data
- Indexing GEOGRAPHY Data
- Testing Spatial Index Effectiveness
- Spatial Index Restrictions
- LAB: Indexing SQL Server Spatial Data for Performance
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2017 by SQL Down Under | Terms Of Use | Privacy Statement