Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
SQL Server Spatial for Developers and DBAs
Module 0: Getting started
Who is this course for? (0:51)
Who is Greg? (1:10)
What will I learn in this course? (0:53)
Configuring your lab environment (9:50)
Module 1: Core spatial concepts
Target applications (1:12)
Types of spatial data (1:38)
Flat earth vs round earth (2:19)
Viewing spatial data in SSMS (2:52)
Projections (1:44)
Using Spatial Data in Other Applications (3:12)
Units of measurement (1:09)
Spatial reference systems (4:48)
Longitude and latitude (1:45)
Degree measurements (1:24)
Movement is a challenge (1:12)
Lab 1: Core spatial concepts
Lab 1 Answers
Quiz 1: Core spatial concepts
Module 2: Defining spatial objects
Open Geospatial Consortium (OGC) (1:44)
Regions (1:24)
Boundary definitions (1:05)
Point defined (2:02)
LineString defined (2:06)
CircularString defined (2:10)
CompoundCurve defined (1:05)
Polygon and CurvePolygon defined (1:57)
Object collections defined (1:02)
Empty geometries (0:56)
Full globe (0:42)
Lab 2: Defining spatial objects
Lab 2 Answers
Quiz 2: Defining spatial objects
Module 3: SQL Server spatial data types
Geometry (1:54)
Geography (2:03)
System CLR types (5:24)
Internal data formats (2:55)
Spatial data in tables (1:22)
Converting to and from text (5:06)
Simplified construction methods (0:53)
Geography methods (0:55)
XML-based formats (8:37)
Using persisted computed columns (1:20)
Full globe support (1:56)
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 (1:31)
Sources of spatial data (2:14)
Checking spatial data validity (4:59)
SqlBuilder classes (2:21)
Using geocoding services (2:33)
Lab 4: Importing spatial data
Lab 4 Answers
Quiz 4: Importing spatial data
Module 5: Querying spatial data
Querying common properties (3:12)
Calling spatial methods (1:01)
Descriptive methods (0:48)
Shape methods (4:17)
Collection and array methods (1:09)
Region methods (4:12)
Boundary methods (1:08)
Angle methods (1:05)
Curve methods (1:30)
Position methods (2:33)
Distance methods (1:05)
Lab 5: Querying spatial data
Lab 5 Answers
Quiz 5: Querying spatial data
Module 6: Aggregations and accuracy
Combining shapes (1:42)
Spatial aggregates (2:20)
Using 3rd Party Extensions (1:45)
Spatial data accuracy (2:07)
Lab 6: Aggregations and accuracy
Lab 6 Answers
Quiz 6: Aggregations and accuracy
Module 7: Indexing spatial data
Spatial indexing concepts (3:52)
Index grids (0:53)
Indexing geometry (4:32)
Indexing geography (1:10)
Testing index effectiveness with Filter (3:00)
Query support for spatial indexes (2:00)
Nearest neighbor query optimization (1:48)
Spatial index restrictions (1:19)
Compressing spatial indexes (0:50)
Lab 7: Indexing spatial data
Lab 7 Answers
Quiz 7: Indexing spatial data
Module 8: Next steps
Summary and further steps (0:53)
System CLR types
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock