Northern Ireland based Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors.

  Public Courses
General Training

  On-Site Courses
Tailored Training

  ILM Qualifications
Level 4 & 5 Awards

  Beck-Bites
Articles & Reviews

  Team Building
Activities & Events

  Why Choose Us?
Our Clients
Our Services
Quality and Expertise
Financial Support
Course Tailoring
Our Support Team
Talk To Us

Join Mailing List

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

© Beckinridge Ltd.

Privacy Policy | Quality Policy

Site by redrhino

Beckinridge specialises in Technology, IT, Sales and Management training for the ICT, Corporate, SME and Government Sectors in Northern Ireland.
Privacy Policy | Capability, Improvement, Through Training & Development