Novinka v nabídce
Kód kurzu: D84584« Krok zpět

Oracle Spatial and Graph Essentials

This course extensively covers the concepts and usage of the native data types, functions, and operators available in Oracle Database for spatial data. Using the Map visualization component, students learn how to render maps and view geospatial data managed by Oracle Spatial and Graph. Students are also introduced to basics of geocoding and routing concepts. The focus of this course is more on introducing the students to basic analysis of spatial data. This course does not cover Graph analysis. Demonstrations and hands-on practice reinforce the fundamental concepts.

 DatumDnůCena kurzuCena materiálůJazyk výukyLokalita 
15.6.2020 5 73 175 CZK - Český jazyk GOPAS Praha_GTT (info o GTT)
 
15.6.2020 5 73 175 CZK - Český jazyk GOPAS Brno_GTT (info o GTT)
 
15.6.2020 5 2 705,00 EUR - Český jazyk GOPAS Bratislava_GTT (info o GTT)
 

PobočkaDnůCena kurzuCena materiálůITB*
Praha5 73 175 CZK v ceně kurzu 75
Brno5 73 175 CZK v ceně kurzu 75
Bratislava5 2 705,00 EUR v ceně kurzu 75

*Body se vztahují pouze na kurzy realizované v prostorách Gopasu.

Nové kurzy ve skupině

Audience

  • Database Administrator
  • Developer
  • Implementer

Objectives

  • Geocode and reverse geocode addresses with the Oracle Spatial and Graph Geocoder
  • Describe the various types of coordinate systems to associate with geometries
  • Perform bulk or incremental load of the spatial and graph data
  • Run spatial and graph queries in SQL to perform spatial and graph analysis
  • Enhance and tune spatial and graph indexes for better performance
  • Identify the general geometric and spatial concepts and terminologies
  • Describe the Oracle Spatial and Graph data and query models
  • Create spatial layers using the SDO_GEOMETRY native data type
  • Employ spatial and graph operators and functions to generate and access 2D geometries
  • Describe the Oracle Spatial and Graph Router and it’s architecture
  • Use the Oracle Spatial and Graph Map Visualization component to render maps
  • Describe the Linear Referencing System (LRS) feature
  • Describe user-defined coordinate systems
  • Use the Map Builder tool to apply styles and themes to rendered maps

Topics

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

Předchozí kurzy

žádný předchozí kurz

Navazující kurzy

žádný navazující kurz
Oracle University eKit

Cena:
v ceně kurzu
Uvedené ceny jsou bez DPH.