Description
This hands-on (2 DAY) training course is designed to equip Spatial, IT or Database Administration professionals with basic skills for managing and processing spatial data in a SQL Server database.
This course allows for the use of data specific to the group being trained. Contact me to be provided with details on what is required.
This course’s unit charge is for 1 student with a minimum quantity of 5 students (minimum) to a maximum of 10.
Topics Covered
- Geometry and geography types
- Spatial Reference Identifiers (SRID) for your data
- Point, line and polygon objects storage
- Create, validate and visualise geometry objects using well-known text (WKT)
- Spatial constructors and methods for each geometry type
- Inspect a geometry object’s structure using the relevant methods
- Load data from spreadsheets and external GIS formats
- Create spatial indexes for geometries
- Conduct spatial querying using spatial indexes
- GIS software configuration to access SQL Server Spatial data
Prerequisites
- Familiarity with SQL SELECT statements
- Knowledge of relational database models and structures
- Familiarity with spatial data and concepts
- Familiarity with SQL Server Management Studio
Further Study
- Successful completion of this course provides direct entry to the Spatial Database: SQL
Server Spatial (Intermediate) course
Reviews
There are no reviews yet.