Support

Microsoft SQL Server 2008 Training Course in Developing Spatial Data Solutions

Developing Spatial Data Solutions With Microsoft SQL Server 2008

Parramatta, NSW

Subject: Microsoft Sql Server

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...

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

When

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

Where

5/159-175 Church St
Parramatta, NSW 2150

Type

  • Class / Group Sessions

Price: $680.00

 

The teachers

MIS Global Technologies (MGT) is a Microsoft Gold Certified Partner for Learning Solutions (CPLS) and all training is...

see more

MIS Global Technologies (MGT) is a Microsoft Gold Certified Partner for Learning Solutions (CPLS) and all training is delivered by Microsoft Certified Trainers (MCTs) using Microsoft Official Curriculum (MOC) training manuals and materials. View our modern Facilities. View our unmatched Room Hire rates.

Our extensive range of instructor-led computer training includes Microsoft technical training, Microsoft Desktop Application training, Cisco, CompTIA, VMware, CISSP, ITIL, Prince2, IT Security, Linux, and Web Site Design, and we are an authorized Prometric and Pearson VUE Testing Centre.

» To view all certification paths, course numbers, exam numbers and course details click here.

» To view all Specials and Promotions with up to 50% off Microsoft and Cisco courses click here.

» To register and redeem your Microsoft Software Assurance Training Vouchers (SATV) click here.

MGT customers receive the highest level of professional development and our training will help you sit and pass your certification exams including MCTS, MCITP, MCSE, MCSA, MCDST, MCPD, MCAD, MCSD, Windows 7, Vista, XP, Exchange Server, SQL Server, SharePoint, Visual Studio and many more.

see less