Oracle Spatial and Graph Essentials - Fudgelearn

Oracle Spatial and Graph Essentials

Date
Time
Price
9-Mar-2020
4:00 PM GMT - 12:00 AM GMT
£ 3015
Date
Time
Price
Location
Date
Start time
Price
Location
Version title
Price

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.

  • Database Administrator
  • Developer
  • Implementer
  • 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
  • Introduction
  • Overview of Oracle Spatial and Graph Concepts
  • Creating Spatial Layers
  • Defining Collection Geometries
  • Associating Spatial Layers with Coordinate Systems
  • Loading Spatial and Graph Data
  • Validating and Debugging Geometries
  • Using Oracle Spatial and Graph Map Visualization Component
  • 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
  • Implementing a Linear Referencing System
  • Managing Spatial Indexes
  • Geocoding Address Data
  • Using the Spatial Routing Engine
Need help finding the right course

Having problem finding the course you’re looking for? Get in touch.

£ 3015
5 Days
Online
1 Event available
Share this Course
Get in touch
If you would like to find out how we can help you, please get in touch
Book a meeting
We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Print
Use the links below to print the details.
Convince your boss

Oracle Spatial and Graph Essentials

Course Overview

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.

Virtual Class
5 Days
Date
Start time
Price
Location
9-Mar-2020
4:00 PM GMT
£ 3015
Online
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
  • Overview of Oracle Spatial and Graph Concepts
  • Creating Spatial Layers
  • Defining Collection Geometries
  • Associating Spatial Layers with Coordinate Systems
  • Loading Spatial and Graph Data
  • Validating and Debugging Geometries
  • Using Oracle Spatial and Graph Map Visualization Component
  • 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
  • Implementing a Linear Referencing System
  • Managing Spatial Indexes
  • Geocoding Address Data
  • Using the Spatial Routing Engine