Module 1: Introduction to Spatial Data

This module introduces some basic spatial data concepts, and discusses the kinds of software applications that can be developed with spatial data. It then describes the spatial data types in SQL Server 2008, and explains how to use them to store spatial data in a column or Transact-SQL variable.

Lessons

• Spatial Data Overview
• SQL Server Spatial Data Types
• Storing and Querying Spatial Objects

Lab: Using Spatial Data Types

• Working with Points
• Working with Lines
• Working with Polygons

After completing this module, students will be able to:

• Describe the difference between geodetic and planar data.
• Choose when to use the geography and geometry data types.
• Store and query spatial points, lines, and polygons in a SQL Server database.

Module 2: Spatial Data Operations

This module explains how to write Transact-SQL statements that use the methods of the geography and geometry data types to perform spatial operations that measure, modify, and find relationships between spatial data instances.

Lessons

• Overview of Spatial Data Operations
• Querying Properties of Spatial Instances
• Manipulating Spatial Data Instances
• Finding Relationships Between Spatial Instances

Lab: Performing Operations on Spatial Data

• Querying Spatial Data Properties
• Manipulating Spatial Data Instances
• Finding Relationships Between Spatial Data Instances

After completing this module, students will be able to:

• Describe the operations that can be performed on geography and geometry instances.
• Query spatial data instance properties.
• Manipulate spatial data instances.
• Find relationships between spatial data instances.

Module 3: Spatial Data Indexes

This module describes spatial data indexing supporting SQL Server 2008, and explains how to create spatial indexes for geometry and geography columns.

Lessons

• Overview of Spatial Indexing
• Working with Spatial Indexes

Lab: Working with Spatial Indexes

• Creating a Default Spatial Index
• Using Custom Tessellation Parameters

After completing this module, students will be able to:

• Describe how spatial indexing works in SQL Server 2008.
• Create, modify, and drop spatial indexes.

Module 4: Spatial Data and Bing Maps

This module describes how to combine spatial data in a SQL Server database with the Microsoft Bing (formerly Virtual Earth) map control to visualize spatial data on a Web page.

Lessons

• Introduction to Microsoft Bing Maps
• Visualizing Spatial Data on a Web Page

Lab: Integrating Spatial Data with Bing Maps

• Creating a GeoRSS Feed Handler
• Programming the Map Control

After completing this module, students will be able to:

• Use the Bing map control.
• Display spatial data from a SQL Server database on the Bing map control.