-
Module 1: Core spatial concepts
14 Lessons-
StartTarget applications
-
StartTypes of spatial data
-
StartFlat earth vs round earth
-
PreviewViewing spatial data in SSMS
-
PreviewProjections
-
PreviewUsing Spatial Data in Other Applications
-
StartUnits of measurement
-
StartSpatial reference systems
-
StartLongitude and latitude
-
StartDegree measurements
-
StartMovement is a challenge
-
StartLab 1: Core spatial concepts
-
StartLab 1 Answers
-
StartQuiz 1: Core spatial concepts
-
-
Module 2: Defining spatial objects
14 Lessons-
StartOpen Geospatial Consortium (OGC)
-
StartRegions
-
StartBoundary definitions
-
StartPoint defined
-
StartLineString defined
-
StartCircularString defined
-
StartCompoundCurve defined
-
StartPolygon and CurvePolygon defined
-
StartObject collections defined
-
StartEmpty geometries
-
StartFull globe
-
StartLab 2: Defining spatial objects
-
StartLab 2 Answers
-
StartQuiz 2: Defining spatial objects
-
-
Module 3: SQL Server spatial data types
14 Lessons-
StartGeometry
-
StartGeography
-
StartSystem CLR types
-
StartInternal data formats
-
StartSpatial data in tables
-
StartConverting to and from text
-
StartSimplified construction methods
-
StartGeography methods
-
StartXML-based formats
-
StartUsing persisted computed columns
-
StartFull globe support
-
StartLab 3: SQL Server spatial data types
-
StartLab 3 Answers
-
StartQuiz 3: SQL Server spatial data types
-
-
Module 5: Querying spatial data
14 Lessons-
StartQuerying common properties
-
StartCalling spatial methods
-
StartDescriptive methods
-
StartShape methods
-
StartCollection and array methods
-
StartRegion methods
-
StartBoundary methods
-
StartAngle methods
-
StartCurve methods
-
StartPosition methods
-
StartDistance methods
-
StartLab 5: Querying spatial data
-
StartLab 5 Answers
-
StartQuiz 5: Querying spatial data
-
-
Module 7: Indexing spatial data
12 Lessons-
StartSpatial indexing concepts
-
StartIndex grids
-
StartIndexing geometry
-
StartIndexing geography
-
StartTesting index effectiveness with Filter
-
StartQuery support for spatial indexes
-
StartNearest neighbor query optimization
-
StartSpatial index restrictions
-
StartCompressing spatial indexes
-
StartLab 7: Indexing spatial data
-
StartLab 7 Answers
-
StartQuiz 7: Indexing spatial data
-
SQL Server Spatial for Developers and DBAs
Don't show just boring tables and charts. Bring your information to life by adding spatial data.
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.
Dr Greg Low is an international consultant, developer and trainer. He has been working in development since 1978, holds a PhD in Computer Science and a host of Microsoft certifications. Greg was the first certified master for SQL Server world-wide. He is the Managing Director for SQL Down Under, a Data Platform (SQL Server) MVP, host of the popular SQL Down Under podcast series, and a member of the Microsoft Regional Director program.
Course Curriculum
Course Pricing
-
$295 USD
Enroll Now