D56709 - Oracle Spatial: Essentials

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

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

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

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d83527

D83527 - Java SE 8 Fundamentals

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop
Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy