SQL Server Spatial for Developers and DBAs

Don’t show just boring tables and charts. Bring your information to life by adding spatial data.

Enroll now for $295 USD !

Course Summary

  • Have you heard that SQL Server has spatial capabilities but don’t know how to use them?
  • Do you still think that spatial data is all just about maps? (Hint: It’s not)
  • Does your data include addresses or locations of people or things?
  • Have you wondered if adding spatial options into your application would bring your data or analytics to life?
  • Have you started to try to use SQL Server spatial but aren’t confident at working with it?

If any of these apply, this course is for you! And as well as detailed instruction, the course also offers optional practical exercises and quizzes to reinforce your learning.


Enroll now for $295 USD !

Modules and Lessons

Module 0: Getting started

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

Module 1: Core spatial concepts

Target applications
Types of spatial data
Flat earth vs round earth
Viewing spatial data in SSMS
Projections
Using Spatial Data in Other Applications
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

Module 2: Defining spatial objects

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

Module 3: SQL Server spatial data types

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

Module 4: Importing spatial data

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

Module 5: Querying 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

Module 6: Aggregations and accuracy

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

Module 7: Indexing spatial data

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

Module 8: Next steps

Summary and further steps


Enroll now for $295 USD !