Deploying and Maintaining a Multiuser Geodatabase
Strictly by pre-registration only
What is this course about?
This course prepares you to successfully create a multiuser geodatabase to store and manage your organisation's geographic data. This course prepares you to successfully create a multi-user geodatabase to store and manage your organisation's geographic data. You will learn about the multi-user geodatabase architecture, configuration options, and techniques to efficiently load data, assign user privileges, and maintain performance over time. Course concepts apply to both enterprise and workgroup geodatabases. During course exercises, you may work with the RDBMS product that is relevant for your organisation (Oracle, Microsoft SQL Server, or PostgreSQL).
This course is for: Spatial database administrators and GIS data managers who need to create, configure, and manage a multiuser ArcSDE geodatabase.
Course details
Location
Singapore
Duration
2 days
Level
Intermediate
Category
Geodatabase Management
Are there any prerequisites?
- Completion of ArcGIS 2: Essential Workflows or equivalent knowledge is required
- Experience managing a relational database management system is required
What skills will I learn?
After completing this course, you will be able to:
- Configure the multi-user geodatabase for your relational database management system
- Create a multi-user geodatabase and configure connections to it
- Efficiently load data into a multi-user geodatabase
- Configure storage settings to support your organisation's data management workflows
- Set up user roles and privileges to provide secure data access
- Apply best practices to maintain high geodatabase performance
What can I expect?
- Course topics
What is a multiuser geodatabase?
- Multiuser geodatabase components
- Create an enterprise geodatabase
- Explore the repository
Connecting to the geodatabase
- RDBMS client software
- Create a connection
- Software version compatibility
- Authentication methods
Loading data into the geodatabase
- Data owner account
- RDBMS considerations
- Geoprocessing environment settings
- Updating datasets
Connecting to the geodatabase
- RDBMS client software
- Create a connection
- Software version compatibility
- Authentication methods
Configuring privileges
- Data users
- Roles
- Securing credentials
Managing storage
- Configuration parameters
- Supported spatial types
- DBTUNE table
Maintaining the geodatabase
- Statistics
- Manage attribute indexes and statistics
- Spatial indexes
- The compress tool
- Manage performance tasks with Python
Associating Data
- Query layers
- Database views
Applying the geodatabase workflows
- Geodatabase workflow
- Geodatabase responsibilities
- Geodatabase tasks