Spatial Databases - Oracle Spatial

Introduction

During this Oracle Spatial and Graph course, individuals will learn about the principles of Oracle spatial and graph.

Candidates will be equipped with the correct understanding of creating spatial layers by using the SDO_GEOMETRY data type.

Pre-Requisites

• There are no pre-requisites needed prior to attending this course.

Who Should Attend

This course is suitable for the following individuals:

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

Course Outline

• Introduction
• Overview of Oracle Spatial Concepts
• Creating Spatial Layers
• Defining Collection Geometries
• Associating Spatial Layers with Coordinate Systems
• Loading Spatial Data
• Validating and Debugging Geometries
• Using the Oracle Application Server MapViewer
• Indexing Spatial Data
• Querying Spatial Data
• Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators
• Analyzing Geometries by Using Spatial Operators and Functions
• Using Spatial Analysis, MBR, Utility, and Aggregate Functions
• Defining Maps by Using the Map Builder Tool
• Leveraging Oracle Maps: The Map Cache and JavaScript API
• Creating a User-Defined Coordinate System
• Implementing a Linear Referencing System
• Managing Spatial Indexes
• Geocoding Address Data
• Using the Spatial Routing Engine