This course teaches students how to model and create tables with spatial data, index spatial data, and discusses how to spatially enable applications. Students learn about Oracle's native data type for spatial data (SDO_GEOMETRY) and the geometric primitives it supports. Additionally, students learn how to load spatial data into Oracle database with various Oracle utilities, how to appropriately create spatial indexes for optimal performance, and how to query spatial data and perform spatial analysis with spatial operators, functions, and procedures. Additional topics include Oracle Spatial's Geocoder, Oracle Spatial's Linear Referencing System (LRS), coordinate systems support in Oracle Spatial and publishing maps to the web with Oracle Application Server MapViewer. (3 day class)

• Model and load data into Oracle Spatial
• Implement spatial queries
• Index and tune spatial data
• Perform spatial analysis
• Validate spatial data

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.

The Oracle Spatial 10g: Fundamentals is taught at either the customer site or at one of Leica’s training centers. Contact Leica’s Customer Education department to schedule this training and set up dates and location.

Leica Customer Education : training@gi.leica-geosystems.com (1 800 373-2713)