Support

Microsoft SQL Server 2008 Training Course in Developing Spatial Data Solutions

5 sessions available starting from $680.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 50350
Course Duration: 1 days

This one-day instructor-led (Level 300) 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.

Skills Gained

After completing this course, students will be able to:

* Store spatial data in a SQL Server 2008 database by using the geography and geometry...

see more

Course Code: 50350
Course Duration: 1 days

This one-day instructor-led (Level 300) 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.

Skills Gained

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

Course Modules

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.

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.

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.

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.

Who Should Attend

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

Prerequisites

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)

see less

Choose from 5 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $680.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

Microsoft SharePoint 2010 Training Course | Configuring and Administering
Microsoft SharePoint 2010 Training Course | Configuring and Administering
4 sessions available starting from $3,400.00
Microsoft Desktop Optimization Pack Course (MDOP)
Microsoft Desktop Optimization Pack Course (MDOP)
3 sessions available starting from $650.00
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Training Course
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services Training Course
8 sessions available starting from $2,040.00

see all listings »


Found In