Skip Navigation LinksHome > Vendors > Oracle > D51020

D56709 - Oracle Spatial: Essentials

Overview

The course extensively covers the concepts and usage of the native data types, functions and operators available in Oracle Spatial for implementing geospatial applications and location-based services.

Using the Oracle Application Server MapViewer, students learn how to render maps and view geospatial data managed by Oracle Spatial or Locator. Students also get introduced to basics of geocoding and routing concepts.
Demonstrations and hands-on practice reinforce the fundamental concepts.

The Oracle Spatial: Essentials course is applicable to both 10g and 11g audiences.

Learn to:

  • Load geometries into spatial layers
  • Create spatial layers by using the SDO_GEOMETRY data type
  • Employ spatial operators and functions to generate and access 2D geometries
  • Setup and demonstrate Oracle Maps
  • Run spatial queries to perform spatial analysis
  • Use MapViewer and the Map Builder tool to render maps

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Create spatial layers by using the SDO_GEOMETRY data type
  • Load geometries into spatial layers
  • Employ spatial operators and functions to generate and access 2D geometries
  • Describe the various types of coordinate systems
  • Run spatial queries to perform spatial analysis
  • Enhance and tune spatial indexes for better performance
  • Describe the linear referencing system
  • Describe Oracle Spatial geocoding and routing concepts
  • Setup and demonstrate Oracle Maps
  • Use MapViewer and the Map Builder tool to render maps
  • Describe the Oracle Spatial data and query models

Content

Module 1: Introduction
Module 2: Overview of Oracle Spatial Concepts
Module 3: Creating Spatial Layers
Module 4: Defining Collection Geometries
Module 5: Associating Spatial Layers with Coordinate Systems
Module 6: Loading Spatial Data
Module 7: Validating and Debugging Geometries
Module 8: Using the Oracle Application Server MapViewer
Module 9: Indexing Spatial Data
Module 10: Querying Spatial Data
Module 11: Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators
Module 12: Analyzing Geometries by Using Spatial Operators and Functions
Module 13: Using Spatial Analysis, MBR, Utility, and Aggregate Functions
Module 14: Defining Maps by Using the Map Builder Tool
Module 15: Leveraging Oracle Maps: The Map Cache and JavaScript API
Module 16: Creating a User-Defined Coordinate System
Module 17: Implementing a Linear Referencing System
Module 18: Managing Spatial Indexes
Module 19: Geocoding Address Data
Module 20: Using the Spatial Routing Engine

Audience

  • Application Developers
  • Technical Consultant
  • Technical Administrator
  • PL/SQL Developer

Prerequisites

  • Familiarity with SQL (recommended OU course: Introduction to SQL)
  • Familiarity with PL/SQL (recommended OU course: Program with PL/SQL)

Suggested Prerequisites:

  • Familiarity with Object-relational data model
  • Familiarity with mathematical geometry concepts

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: