Oracle Spatial: Essentials (D56709)

Oracle Spatial: Essentials (D56709)

Overview

Duration: 5 Days

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

N/A
  • 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
Course ID:
D56709


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.