> > > D56709

Oracle Spatial: Essentials (D56709)

Kursbeschreibung Kurstermine Detaillierter Kursinhalt
 

Kursüberblick

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

Zielgruppe

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

Voraussetzungen

Required 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

Kursziele

  • 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

Kursinhalt

  • 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
Classroom Training
Modality: G

Dauer 5 Tage

Preis (exkl. MwSt.)
  • Deutschland: 4.025,- €
  • Schweiz: Fr. 5.000,-
Termine und Buchen
Online Training
Modality: U

Dauer 5 Tage

Preis (exkl. MwSt.)
  • Deutschland: 3.785,- €
Termine und Buchen
 
Kurstermine

Derzeit gibt es keine Trainingstermine für diesen Kurs.  Termin anfragen

 

Cookies verbessern unsere Services. Durch die Benutzung unserer Website erklären Sie sich mit unserer Verwendung von Cookies einverstanden.   Verstanden.