Data Management in the Multiuser Geodatabase

AU$2,696.76 / person

Level: Advanced

Limited seats available - Melbourne 29-31 May

Esri Australia's advanced training course for Data Management in the Multiuser Geodatabase. Designed for database administrators who need to implement a workgroup or enterpise ArcSDE geodatabase.

Course Details

Duration - 3 days

City / Dates

@ Melbourne

29-31 May 2012

@ Perth

23-25 October 2012

I'm interested, but I can't make these dates

What is the course about?

Organisations using ArcGIS Server can deploy a multiuser ArcSDE geodatabase to centrally manage their GIS data, improve its security and integrity, and deliver access and editing capabilities to many users. This course teaches database administrators how to successfully load and manage data in preparation for a multiuser geodatabase implementation.

You will learn best practices for designing, interacting with, and maintaining the performance of a multiuser geodatabase and explore multiuser editing workflows and options, including versioning. While this course focuses primarily on the enterprise ArcSDE geodatabase, course concepts apply to both workgroup and enterprise geodatabase.

Am I ready for this course?

This course is designed for GIS and database administrators who need to implement a workgroup or enterprise ArcSDE geodatabase.

Note: Database administrators who need to install and configure ArcSDE should also enroll in ArcGIS Server Enterprise Configuration and Tuning for Oracle or ArcGIS Server Enterprise Configuration and Tuning for SQL Server, which complement this course.

What skills will I learn?

Understand the architecture of a multiuser geodatabase.
Create connections to an ArcSDE geodatabase.
Set and manage user permissions.
Create an efficient data storage design to support a multiuser editing workflow.
Load and manage vector and raster data.
Apply client optimisation techniques.

Are there any prerequisites?

Completion of ArcGIS Desktop II: Tools and Functionality or equivalent knowledge is required. Familiarity with basic RDBMS concepts is also required.

What can I expect?

Exploring the geodatabase
- Geodatabase types, behaviors, and options
- Classifying geodatabase data
- Elements of a workgroup and enterprise installation
Geodatabase architecture
- Multitier architecture
- Enterprise ArcSDE geodatabase installation
- Management tools
Creating geodatabase connections
- Connection types, files, and information
- Authentication
Users and permissions
- Access levels
- User roles and data permissions
Loading data
- Geodatabase environment settings
- Methods of creating data
- Configuration keywords
- Deleting geodatabase data
Managing vector data
- Feature class and spatial reference properties
- Upgrading data
- Z- and m-values
- Geometry storage
- DBMS spatial column type
- Table registry
- Query layers and Layers table
Indexes
- Query filters
- Attribute and ArcSDE indexes
- Spatial index types
- Multiple grid sizes
- Modifying the spatial grid index
Managing raster data
- Schema overview
- Compression options
- NoData storage
- Color maps
- Raster tiles and statistics
- Raster geodatabase settings
Organising multiple raster datasets
- Mosaic datasets
- Raster catalogs and raster datasets
- Tips for loading multiple rasters
- Raster attributes
Multiuser editing
- Transaction models
- No versioned editing and versioned editing
- Geodatabase archiving
- Geodatabase replication
Versioning
- Registering objects as versioned
- Storing versioned edits
- Viewing versions and version differences
- Merging changes and resolving conflicts
- Version permissions
Associating data
- Database normalisation and cardinality
- Geodatabase relationship classes
- ArcSDE spatial views
- Data associations processed by client or by server
Maintaining performance
- Performance bottlenecks
- Compressing the geodatabase
- Maintaining statistics and rebuilding indexes
- Generalising data
- Best practices for ArcMap users and data managers

AU$2,696.76 / person