• Overview
• Outline
• Schedule

About This Course

This one-day instructor-led course provides students with the knowledge and skills to create database solutions that use spatial data in Microsoft SQL Server 2008. The course introduces developers to spatial data concepts and the geography and geometry spatial data types in SQL Server 2008. It then describes how to use these data types to store geographic and location-based data and to perform spatial operations and queries. Finally, the course describes how to integrate spatial data in SQL Server 2008 with the Microsoft Virtual Earth map control in a Web application.

Audience Profile

This course is intended for developers who need to create applications that store and query geographic data.

Prerequites

Before attending this course, students must have:

• Experience of creating database solutions in SQL Server, including basic Transact-SQL programming.
• Familiarity with Web development in Microsoft Visual Studio (recommended but not essential).

At Course Completion

After completing this course, students will be able to:

• Store spatial data in a SQL Server 2008 database by using the geography and geometry data types.
• Perform spatial data operations and queries in Transact-SQL code.
• Create spatial indexes to optimize queries against spatial data types.
• Display spatial data from a SQL Server database on a Microsoft Virtual Earth map control in a Web page.