Training
Oracle
Oracle Database
Oracle Spatial and Graph Essentials Ed 1

7619 Reviews star_rate star_rate star_rate star_rate star_half

Oracle Spatial and Graph Essentials Ed 1

By Request

$5,000 USD

Course Code D84586GC10

Duration 5 days

Available Formats Classroom

Enter your Email to Download Full Course Details

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.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

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

Prerequisites

Good working knowledge of the SQL and PL/SQL
Familiarity with Object relational data model
Familiarity with Oracle SQL Developer and SQL*Plus
Familiarity with mathematical geometry concepts

Course Details

Introduction

Oracle Location Technologies
Oracle Spatial: Spatial Data Management for Enterprise Applications
Oracle Spatial and Graph and Oracle Locator: Implementation
Oracle Spatial and Graph Object-Relational Model
Using Varying Arrays
Geometries Along Axis

Overview of Oracle Spatial and Graph Concepts

Types of Location Data
Geometric Primitive Types
Spatial and Graph Data Model
Coordinate Systems: Concepts
Spatial and Graph Query
Spatial and Graph Indexing
R-Tree: Generating Minimum Bounding Rectangles (MBR)
Linear Referencing System (LRS)

Creating Spatial Layers

MDSYS Schema
Spatial and Graph Native Data Type: SDO_GEOMETRY
Geometry Objects
Constructing Geometries
Rules for Inserting Geometries in Spatial Layers
Spatial and Graph Metadata

Defining Collection Geometries

Collection
Oriented Point
SDO_ELEM_INFO Triplet Values
Rules for an Oriented Point
SDO_GEOMETRY Constructors
Constructors for SDO_GEOMETRY with the WKT exampl

Associating Spatial Layers with Coordinate Systems

Coordinate Systems
Geodesic for Antipodal Points
Polygons in a Geodetic Coordinate System
Geodetic Optimized Rectangles
Coordinate Systems in Oracle Spatial
CS_SRS Table
Common Coordinate Systems
Whole Earth Geometry Model

Loading Spatial and Graph Data

Loading Spatial Data
Bulk-Loading Data with SQL*Loader
Data Pump Export and Import Utilities
Using Transportable Tablespaces
Transactional Inserts
Limitations of Using the SDO_GEOMETRY Constructor in the INSERT statement
Shapefile Converter
Log Output from Java Shapefile Converter

Validating and Debugging Geometries

Validating Geometries and Functions
VALIDATE_GEOMETRY_WITH_CONTEXT Function with an Example
VALIDATE_LAYER_WITH_CONTEXT Procedure
Geometry Debugging Functions
Modifying Geometries in PL/SQL

Using Oracle Spatial and Graph Map Visualization Component

Introduction to MapViewer
Architecture of Oracle Spatial and Graph Map Visualization Component
Installation of Oracle Spatial and Graph Map Visualization Component
MapVisualizer Demos
Debugging

Indexing Spatial Data

R-Tree Indexing
How Geometries Are Indexed with R-Trees
Analyzing Spatial and Graph Tables
Spatial Index Dictionary Views
R-Tree Index Sizing: Usage Notes and WORK_TABLESPACE

Querying Spatial Data

Primary and Secondary Filters
Spatial and Graph Query Model
Spatial and Graph Operators
Spatial and Graph Procedures and Functions
Spatial and Graph Topological Relationships
Using the ORDERED Optimizer Hint
Relationship Operators
Implicit Coordinate System Transformations

Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators

Spatial and Graph Operators
Describe the SDO_WITHIN_DISTANCE operator
Describe the SDO_NN operator
Spatial join by using the SDO_JOIN operator
Parallel with Spatial and Graph Operators and CREATE TABLE AS SELECT
Spatial Vector Acceleration

Analyzing Geometries by Using Spatial Operators and Functions

Calculating the Area and Length
Calculating the Distance Between Geometries
Arc Densification
Spatial and Graph Boolean Functions
Explicit Transformation with Spatial Functions

Using Spatial Analysis, MBR, Utility, and Aggregate Functions

SDO_GEOM.SDO_MBR Function
SDO_UTIL Functions
Spatial Aggregate Functions
GeoJSON and JSON
Geography Markup Language (GML)
Using the DETERMINISTIC Keyword
Java: Converting Geometries to and from GML
Functions that Return SDO_GEOMETRY and CREATE TABLE AS SELECT

Defining Maps by Using the Map Builder Tool

MapVisualizer
USER_SDO_STYLES
USER_SDO_THEMES
USER_SDO_MAPS
MapVisualizer APIs
MapVisualizer Caches Style, Theme, and Map Definitions
OGC Web Map Service (WMS) Support
Oracle Workspace Manager Support

Leveraging Oracle Maps: The Map Cache and JavaScript API

Oracle Maps
Map Cache
Oracle Maps interactive demos

Implementing a Linear Referencing System

Linear Referencing System Concepts
Associating Measure Values Along a Geometry
Linear Referencing System: Transportation Application
Creating an LRS Geometry
LRS Terms and Concepts
LRS Support for Collections
Defining LRS Structures
Overview of LRS Functions

Managing Spatial Indexes

Oracle Table Partitioning and Oracle Spatial
Spatial Index Partitioning Parameters
Oracle Spatial Index Partitioning
Spatial Partition Pruning
Combining Nonspatial and Spatial Partitioning
Function-Based Indexes
Transportable-Tablespace Support for Spatial Indexes
Embedded Spatial Geometry

Geocoding Address Data

Geocoding Concepts
Oracle Spatial Geocoding Functions
SDO_KEYWORDARRAY, SDO_GEO_ADDR, and SDO_ADDR_ARRAY types
Geocoding service

Using the Spatial Routing Engine

Oracle Spatial Routing Architecture
Route request and response
Routing Engine Request
Sample RouteServer JSP

Read Less

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Request Other Date Request On-site Course

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How to request a W9 for ExitCertified LLC?

View our filing status and how to request a W9.

The technical data in the AWS Solutions Architect course was very thorough.

Caleb Kelly

ExitCertified

Good Course. We covered a lot of material in a short amount of time. This course had useful labs that built upon each other.

Brian Brinkley

ExitCertified

ExitCertified gave a great course on AWS that covered all of the basics in depth with good lab materials.

ExitCertified Student

ExitCertified

The instructor was thorough and they also provided hands-on demonstrations with labs.

ExitCertified Student

ExitCertified

They are very good and made sure we had all the appropriate materials for class.

ExitCertified Student

ExitCertified