SQL Spatial

The Graphics Network

Training and Development for Windows, Linux and the Web

01285 713297 info@tgn.co.uk

SQL Server Spatial

This one day course can be taken on its own for those with existing SQL experience, or as an additional day for our 1 and 3 day SQL courses. It covers the geograpy and geometry types and how these can be used for applications such as mapping. It includes many practical exercises which can be tailored to your particular requirements.

The 1 day course costs £640 in total for up to 6 students, plus VAT and the instructor's reasonable expenses. Each student beyond 6 would cost £20 for the additional course materials. If you are interested in this course, please contact us by email at enquiries@tgn.co.uk or by phone on +44 (0)1285 713297.

Course Outline:

Introducing Spatial

Spatial support in SQL Server. Geography and geometry types. Coordinate systems. Spatial references and IDs. Well Known Text and Well Known Binary. Standard methods. Points, line strings, rings and polygons. Circular and additional types. Mapping.

Spatial Calculations

Static and instance methods. Variables, methods and properties. Extracting points. Calculating distances. Areas. Intersections and combinations. Centroids and centres. Envelopes and convex hulls. Point reduction. Spatial aggregates.

Spatial Indexes

The importance of spatial indexes. How spatial indexes work. Levels. Creation and configuration. Selecting indexes.