Training
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 2014, 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.

City
Dates
Course Price
Early Bird Price
Melbourne
15 Oct 2014
$700+GST
$595+GST if paid by Oct 1
Day
Code
Module
1
SP301
Introduction to SQL Server Spatial Data
- Core Spatial Concepts
- Spatial Reference Systems
- SQL Server GEOMETRY Data Type
- SQL Server GEOGRAPHY Data Type
- LAB: Introduction to SQL Server Spatial Data
1
SP302
Loading and Querying SQL Server Spatial Data
- Declaring Spatial Data Types and Setting Values
- Importing Spatial Data into SQL Server
- Geocoding Locations
- Calling Spatial Methods
- LAB: Loading and Querying SQL Server Spatial Data
1
SP303
SQL Server 2012 Spatial Enhancements
- Implementing Full Globe Support
- Implementing Large Area Support
- Implementing Curved Arc Support
- Working with Enhanced Methods
- Working with Enhanced Precision
- Working with Spatial Aggregates
- LAB: SQL Server 2012 Spatial Enhancements
1
SP304
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 2014 by SQL Down Under | Terms Of Use | Privacy Statement | Client login