A Seminar on Using and optimising SQL Server Spatial Data Types
| aangeboden door |
Twice IT |
meer informatie »
|
| laatst bijgewerkt |
15-07-2010 |
|
| prijsindicatie |
€ 149,00 |
| cursusduur |
1 dag |
|
| |
|
After attending this seminar, participants will have:
o A good understanding of the way SQL Server implements Spatial Data Types;
o A good understanding of how to use Spatial Data Types;
o An understanding of ways to visualise Spatial Data;
o In-depth understanding of the way Spatial Indexes work, can be used, and can be monitored;
o In-depth understanding of designing, creating and maintaining CLR object that use Spatial Data
Doelgroep
Database developers or administrators who wish to explore the possibilities and consequences of using SQL Server 2008 Spatial Data Types. The seminar is also useful for software developers who are expected to build CLR objects that will use the SqlGeography and SqlGeometry data types.
Voorkennis
Participant should have SQL Server knowledge at the MCTS level; some experience with regard to CLR Integration is preferable.
Opzet
This one-day seminar will be conducted using some slides and many demos. Participants will be encouraged to discuss the subjects presented. They will be provided with Alastair Aitchison's book "Beginning Spatial with SQL Server 2008".
Programma
Module 1: Course Introduction
Module 2: Spatial Data Introduction
This module provides an overview of the need and use of Spatial Data, the way SQL Server implements OGC-compliance, and the Type hierarchy
o What are spatial data
o Where are spatial data
o SQL Server support
o Type hierarchy
Module 3: Using Spatial Data
This module describes how Spatial Objects can be initialized from text, binary data and XML. Participant will learn about the role of the SRID. The module also provides an overview of OGC-compliant and Microsoft specific methods, and whether they are implemented by Geometry, Geography or both.
o Initialisation
o Behaviour
Module 4: Spatial Data Methods
This module visually shows the behaviour of the methods introduced in the previous module.
Module 5: Visualising Spatial Data
In this module, participants will learn how to visualize Spatial Data using a variety of tools.
o Management Studio
o Report Builder 3.0 (R2)
o Microsoft MapPoint
o Bing Maps
o Google Maps
Module 6: Spatial Indexes
Spatial Indexes are covered in depth in this module. After studying this module, participants will be able to discuss the need of Spatial Indexes, have seen a simulation of the workings of Spatial Indexes, know about Tesselation techniques and be able to gather diagnostic data.
o Index overview
o Index simulation
o Tesselation
o Index creation
o Index diagnostics
Module 7: CLR integration
This module provides a concise overview of CLR Integration possibilities, pitfalls and consideration. Using the Bing Maps Web Services, participants will see how stored procedures, user defined functions and user defined aggregates can retrieve Spatial Data. A discussion of whether or not to use .NET 3.x is provided as well.
o CLR Integration revisited
o Bing Maps as an example
o SQL Server and .NET 3.x
Module 8: Where to go from here
At the end of the day participants will be provided with some advice on designing issues and several links to sources of additional information.
o Design considerations
o Sources of information
o Sources of data
|
| |
|
« Terug naar vorige pagina
|
|