Spatial Data Solution Development

Developing Spatial Data Solutions with Microsoft SQL Server 2008

Course Code: 50350

Course Duration: 1 Day

Course Cost: $675.00 ex. GST

Overview

This one-day instructor-led course provides participants 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 Bing map control in a Web application.

Book SQL Server Training __CNAME__ Enquire

Who Should Attend

Developers who need to create applications that store and query geographic data.

Course Objectives

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 Bing map control in a Web page

Course Prerequisites

Before attending this course, participants should 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)