ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Spatial: Essentials

Format: Formation virtuelle avec formateur
Autres formats:
 
 

The course extensively covers the concepts and usage of the native data types, functions and operators available in Oracle Spatial for implementing geospatial applications and location-based services.

Using the Oracle Application Server MapViewer, students learn how to render maps and view geospatial data managed by Oracle Spatial or Locator. Students also get introduced to basics of geocoding and routing concepts.
Demonstrations and hands-on practice reinforce the fundamental concepts.

The Oracle Spatial: Essentials course is applicable to both 10g and 11g audiences.

Learn to:
  • Load geometries into spatial layers
  • Create spatial layers by using the SDO_GEOMETRY data type
  • Employ spatial operators and functions to generate and access 2D geometries
  • Setup and demonstrate Oracle Maps
  • Run spatial queries to perform spatial analysis
  • Use MapViewer and the Map Builder tool to render maps

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.
 
 

Compétences acquises
 

  • Create spatial layers by using the SDO_GEOMETRY data type

  • Load geometries into spatial layers

  • Employ spatial operators and functions to generate and access 2D geometries

  • Describe the various types of coordinate systems

  • Run spatial queries to perform spatial analysis

  • Enhance and tune spatial indexes for better performance

 

  • Describe the linear referencing system

  • Describe Oracle Spatial geocoding and routing concepts

  • Setup and demonstrate Oracle Maps

  • Use MapViewer and the Map Builder tool to render maps

  • Describe the Oracle Spatial data and query models

Qui peut en profiter
 

  • Application Developers

  • PL/SQL Developer

 

  • Technical Administrator

  • Technical Consultant

Préalables
 

  • Familiarity with SQL (recommended OU course: Introduction to SQL)

  • Familiarity with Object relational data model

 

  • Familiarity with PL/SQL (recommended OU course: Program with PL/SQL)

  • Familiarity with mathematical geometry concepts
 
Enroll For This Class
Enroll For This Class
Oracle DB PeopleSoft Hyperion Ce cours est donné par des formateurs certifiés Oracle.

Oracle University a nommé ExitCertified Partenaire de l’année 2011

Il y a une différence....découvrez-la.
Training Class Enrollment Ask A Question About This Training
Code: D59338GC10
Format: Formation virtuelle avec formateur
Durée: 5
Certifié par: Oracle
Frais d’inscription (CAD): 5,150$
Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
Recherchez des cours semblables
Cours connexes

Trier l'horaire par: 
Live Virtual Class  Jun.25 - Jun.29.2012 course register
Live Virtual Class  Jul.30 - Aug.3.2012 course register
Live Virtual Class  Aug.27 - Aug.31.2012 course register
Live Virtual Class  Oct.29 - Nov.2.2012 course register
Live Virtual Class  Dec.17 - Dec.21.2012 course register
5 Dates Offered      
   
demander une autre date/un autre emplacement demander de la formation sur place
 

Oracle Spatial: Essentials Contenu détaillé
 
 
Introduction
  • Oracle Database: Location Features
  • Oracle Spatial: Spatial Data Management for Enterprise Applications
  • Oracle Spatial Development History
  • Oracle Spatial and Locator: art of the Oracle DBMS Kernel
  • Oracle Spatial Object-Relational Model
  • Review: Oracle’s Object-Relational Model
  • Common Geographical Terms Used in the Course
  • Oracle Spatial Documentation and Resources
Overview of Oracle Spatial Concepts
  • Define Oracle Spatial
  • Describe Geometric Primitive Types
  • Describe the Spatial Data Model
  • Coordinate Systems: Concepts
  • Explain Spatial Indexing
  • Describe the Optimized Query Model
  • Define Linear Referencing System
  • Define Geocoding and Routing
Creating Spatial Layers
  • Describe the MDSYS Schema
  • Spatial Native Data Type: SDO_GEOMETRY
  • Define different types of geometry elements
  • Construction of geometries by using the INSERT statement
  • Manage Spatial metadata
Defining Collection Geometries
  • Define Collection geometries: Multipoint, Multiline string, and Multipolygon
  • Describe Oriented point
  • SDO_GEOMETRY constructors and member methods
Associating Spatial Layers with Coordinate Systems
  • Define Coordinate systems and their different types
  • Geodetic coordinate system concepts
  • Whole earth geometry model and tolerance
  • Coordinate system transformations
  • Units supported by Oracle Spatial
Loading Spatial Data
  • Different ways of loading spatial data
  • Loading of spatial data by using SQL*Loader
  • Export and import utilities of the Data Pump technology
  • Load data using transportable tablespace
  • Load data using transactional insert
  • Use the Java shapefile converter
Validating and Debugging Geometries
  • Validation functions: SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT and SDO_GEOM.VALIDATE_LAYER_WITH_CONTEXT
  • Geometry debugging functions: SDO_UTIL.GETVERTICES, SDO_UTIL.RECTIFY_GEOMETRY, and SDO_UTIL.EXTRACT
  • Strategy for Geometry Validation
Using the Oracle Application Server MapViewer
  • Introduction to MapViewer
  • Architecture of Oracle Application Server MapViewer
  • Installation of Oracle Application Server MapViewer
  • Use MapViewer demos
  • Edit MapViewer Configuration File
Indexing Spatial Data
  • Concepts of R-tree indexing
  • CREATE INDEX and the R-tree parameters
  • Analyze, drop, and alter operations on the spatial index
  • Use the Spatial index dictionary views
  • Estimate R-tree index size and the resources required
Querying Spatial Data
  • Overview of the Spatial query model
  • Overview of spatial operators, procedures, and functions
  • Use the SDO_FILTER operator
  • Define Spatial topological relationships
  • Use the SDO_RELATE operator
  • Use the SDO_GEOM.RELATE function
 
Using SDO_WITHIN_DISTANCE, SDO_NN, and SDO_JOIN Operators
  • Spatial queries and operators
  • Describe the SDO_WITHIN_DISTANCE operator
  • Describe the SDO_NN operator
  • Spatial join by using the SDO_JOIN operator
Analyzing Geometries by Using Spatial Operators and Functions
  • Calculation of the area, length, and distance between geometries
  • Describe Arc densification and buffering
  • Use the Spatial Boolean functions
  • Explicit transformations with spatial functions
Using Spatial Analysis, MBR, Utility, and Aggregate Functions
  • Describe some of the Spatial analysis functions
  • Describe some of the Spatial MBR functions
  • Describe some of the Spatial utility functions
  • Describe some of the Spatial aggregate functions
  • Conversion between SDO_GEOMETRY and Geography Markup Language (GML)
Defining Maps by Using the Map Builder Tool
  • Introduction to Map Builder
  • Export and import styles
  • Use of Map Builder to administer style, theme, and map definitions
  • Use the Sample mapclient.jsp
  • Define a Sample XML request with elements
  • Open Geospatial Consortium (OGC) Web Map Service (WMS) and Oracle Workspace Manager support
Leveraging Oracle Maps: The Map Cache and JavaScript API
  • Oracle Maps concepts
  • Oracle Maps demo setup
  • Maps and Faces demo
  • More Oracle Maps demos
Creating a User-Defined Coordinate System
  • Coordinate systems concepts: Ellipsoids, Datums, and projections
  • Geodetic or projected coordinate systems
  • Define OGC WKT schema and EPSG
  • Creation of a user-defined coordinate system
  • Local coordinate system
Implementing a Linear Referencing System
  • Linear Referencing System (LRS) concepts
  • Define LRS geometries
  • Overview of LRS functions
  • Implementation of an LRS
Managing Spatial Indexes
  • Oracle Spatial index partitioning
  • Partition spatial data based on location
  • Define function-based indexes
  • Use transportable tablespaces
  • Embedded spatial geometry
Geocoding Address Data
  • Geocoding concepts
  • Oracle Spatial geocoding functions
  • SDO_KEYWORDARRAY, SDO_GEO_ADDR, and SDO_ADDR_ARRAY types
  • Examples using geocoding functions
  • Geocoding service
Using the Spatial Routing Engine
  • Oracle Spatial Routing architecture
  • Route request and response
  • Sample RouteServer JSP


  ExitCertified is your Authorized IT Training Partner  
  Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

Il y a une différence. Apprenez directement de la source.		  
Training Contacts  
   
Canada United States

Formation à Montréal :: 514.876.1666
Formation à Ville de Québec :: 514.876.1666
Formation à Ottawa :: 613.232.3948
Formation à Toronto :: 416.487.3948

Formation à Vancouver :: 604.633.3948
Formation à Victoria :: 1.866.328.3948
Formation à Calgary :: 403.291.2855
Formation à Edmonton :: 780.441.3948
Formation à Regina :: 1.866.328.3948

 Formation à Sacramento :: 916.669.3970
Formation à San Francisco :: 415.975.3948
Formation à San Jose :: 408.288.3948
Formation à Las Vegas :: 1.800.803.3948
Formation à Phoenix :: 602.889.9350
À travers le monde - 613.232.3948 Des questions?
Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
   



(c) 2012 ExitCertified Corp. Tous droits réservés.


ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
 
Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
         
Formation MySQL Formation Apple Formation en gestion de projet    
Base de données MySQL Cours Apple, Formation Leopard Formation du PMI