This Oracle Spatial and Graph Essentials training course 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, you will learn to render maps and view geospatial data managed by Oracle Spatial and Graph. You are also introduced to basics of geocoding and routing concepts. The focus of this course is more on introducing to basic analysis of spatial data. This course does not cover Graph analysis.
By attending Oracle Spatial and Graph Essentials workshop, delegates will learn to:
- 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
The Oracle Spatial and Graph Essentials class is ideal for:
- Database Administrators
- Developers
- Implementers