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 £690 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 firstname.lastname@example.org or by phone on +44 (0)1285 713297.
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.
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.
The importance of spatial indexes. How spatial indexes work. Levels. Creation and configuration. Selecting indexes.