SQL Server Spatial

Course Code: GN-332  Duration: 1 Day

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 geography 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.

Course Content

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.

« Back to last page