SQL Server Spatial Core Skills (1 day)


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 2017, 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, SQL Server 2014 and SQL Server 2016. Where there are differences between versions, the differences are clearly highlighted.

 CITY DATES COURSE PRICE EARLY BIRD PRICE
On-demand Please contact us

DAY 1 SP301 INTRODUCTION TO SQL SERVER SPATIAL DATA
Core Spatial Concepts
Spatial Reference Systems
OGC Specifications
OGC Shape Definitions
LAB: Introduction to SQL Server Spatial Data
DAY 1 SP302 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
DAY 1 SP303 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
DAY 1 SP304 INDEXING SQL SERVER SPATIAL DATA FOR PERFORMANCE
SQL Server Spatial Index Core Concepts
Indexing GEOMETRY Data
Testing Spatial Index Effectiveness
Spatial Index Restrictions
LAB: Indexing SQL Server Spatial Data for Performance