SQL Server Spatial for Developers and DBAs

Zenler Player

Your course is loading. Hang tight.

Who is this course for? Preview
Who is Greg? Preview
What will I learn in this course? Preview
Configuring your lab environment

Target applications
Types of spatial data
Flat earth vs round earth
Viewing spatial data in SSMS Preview
Projections Preview
Using Spatial Data in Other Applications Preview
Units of measurement
Spatial reference systems
Longitude and latitude
Degree measurements
Movement is a challenge
Lab 1: Core spatial concepts
Lab 1 Answers
Quiz 1: Core spatial concepts

Open Geospatial Consortium (OGC)
Regions
Boundary definitions
Point defined
LineString defined
CircularString defined
CompoundCurve defined
Polygon and CurvePolygon defined
Object collections defined
Empty geometries
Full globe
Lab 2: Defining spatial objects
Lab 2 Answers
Quiz 2: Defining spatial objects

Geometry
Geography
System CLR types
Internal data formats
Spatial data in tables
Converting to and from text
Simplified construction methods
Geography methods
XML-based formats
Using persisted computed columns
Full globe support
Lab 3: SQL Server spatial data types
Lab 3 Answers
Quiz 3: SQL Server spatial data types

Spatial data formats
Sources of spatial data
Checking spatial data validity
SqlBuilder classes
Using geocoding services
Lab 4: Importing spatial data
Lab 4 Answers
Quiz 4: Importing spatial data

Querying common properties
Calling spatial methods
Descriptive methods
Shape methods
Collection and array methods
Region methods
Boundary methods
Angle methods
Curve methods
Position methods
Distance methods
Lab 5: Querying spatial data
Lab 5 Answers
Quiz 5: Querying spatial data

Combining shapes
Spatial aggregates
Using 3rd Party Extensions
Spatial data accuracy
Lab 6: Aggregations and accuracy
Lab 6 Answers
Quiz 6: Aggregations and accuracy

Spatial indexing concepts
Index grids
Indexing geometry
Indexing geography
Testing index effectiveness with Filter
Query support for spatial indexes
Nearest neighbor query optimization
Spatial index restrictions
Compressing spatial indexes
Lab 7: Indexing spatial data
Lab 7 Answers
Quiz 7: Indexing spatial data

Summary and further steps