Platform for starters in the geo sector

200 courses, 20 online supports, 60 moocs,

10 work to work trajectories,

30 trainees

Course: Oracle Spatial Basics

  • Description
  • Schedule and Registration
The Oracle Spatial Basis course lasts 4 days and costs € 1795. Group discount: If you register several students for this course, a discount of 25% on the 2nd student, 50% on the 3rd student and 75% on the 4th, 5th, 6th, 7th and 8th student. This course covers the storage, syntax and semantics of geometric data types in Oracle. Oracle Database is a database management system and the flagship of Oracle. It is also possible to store spatial data in this database. Then we also speak of Oracle Spatial. Some prior knowledge with SQL is desirable. For example, you can follow the SQL basic course.

Course content

Participants learn to work with Oracle's native data type for spatial data, SDO_GEOMETRY, and the geometric primitives it supports. The mechanism of spatial indexing is also discussed. Operators and functions related to spatial queries, overlays and spatial analyzes are also discussed. Participants learn geometric primitives supported by modeling SDO_GEOMETRY and loading geo data into the database. Spatial queries are then released on a filled database. Spatial operators are used for this. The participants learn to do spatial analyzes with spatial functions and procedures. The following topics are also discussed: indexing spatial data, linear referencing, describing the Oracle Spatial models and the available coordinate systems.

Learning objectives of this course

  • The student has an idea of what a relational database entails and knows its advantages and disadvantages
  • You can work independently with Oracle Spatial to load and change spatial data
  • You can independently manage and query data