Deploying and Maintaining a Multiuser Geodatabase

[#1]

This course prepares you to successfully create a multiuser geodatabase that stores and manages your organization's authoritative geographic data. Learn about the multiuser geodatabase architecture and apply techniques to efficiently load data, assign user privileges, and maintain performance over time.

Resources

Lesson 1 – What is a multiuser geodatabase?

• Geodatabase management
• Create a geodatabase in Oracle
• Configure extproc to access ST_Geometry in Oracle
• Geodatabases in PostgreSQL
• Create a geodatabase in PostgreSQL on Windows
• Create a geodatabase in PostgreSQL on Linux
• Create a geodatabase in a PostgreSQL cloud-based database service
• Geodatabases in Microsoft SQL Server
• Create a geodatabase in SQL Server

Lesson 2 - Connecting to the geodatabase

• Connections to relational databases in ArcGIS Pro
• Connect to Oracle from ArcGIS
• Connect to PostgreSQL from ArcGIS
• Connect to Microsoft SQL Server from ArcGIS
• Rename a geodatabase
• Client and geodatabase compatibility
• Manage connections to enterprise geodatabases in SQL Server
• Prevent geodatabase connections

Lesson 3 – Loading data into the geodatabase

• Copying a geodatabase using geodatabase XML workspaces
• Copy feature datasets, feature classes, and tables to a geodatabase
• Extract data from a geodatabase
• Load data
• Import data
• Export data
• Truncate Table (Data Management)
• Append (Data Management)

Lesson 4 – Configuring privileges

• SQL Server

• Add logins and users to SQL Server
• Privileges for geodatabases in SQL Server

• Oracle

• Add users to Oracle
• Privileges for geodatabases in Oracle

• PostgreSQL
• Add login roles to PostgreSQL
• Privileges for geodatabases in PostgreSQL

• Create Database User (Data Management)
• Create Role (Data Management)
• Change Privileges (Data Management)

Lesson 5 – Managing storage

• Configuration keywords
• Configuration keywords
• Configuration keywords for enterprise geodatabases
• Export Geodatabase Configuration Keywords (Data Management)
• Import Geodatabase Configuration Keywords (Data Management)

• DBTUNE table

• Oracle
• Oracle configuration parameters
• Alter configuration keywords
• PostgreSQL
• PostgreSQL configuration parameters
• Alter configuration keywords
• SQL Server
  • SQL Server configuration parameters
  • Alter configuration keywords

• Spatial data types

• Spatial types in databases
• Add the ST_Geometry type to an Oracle database
• Upgrade the ST_Geometry type in an Oracle database
• Add the ST_Geometry type to a PostgreSQL database
• Upgrade the ST_Geometry type in a PostgreSQL database

Lesson 6 – Maintaining the geodatabase

• Oracle
  • Enterprise geodatabase maintenance tasks
  • Update database statistics
  • Rebuild system table indexes
•  PostgreSQL
  • Enterprise geodatabase maintenance tasks
  • Update database statistics
  • Rebuild system table indexes
• SQL Server
  • Enterprise geodatabase maintenance tasks
  • Update database statistics
  • Rebuild system table indexes

• Rebuild Indexes (Data Management)
• Analyze Datasets (Data Management)
• Compress (Data Management)
• Enterprise geodatabase locks
• Manage geodatabase locks

Lesson 7 – Associating data

• Oracle
  • Views in an enterprise geodatabase
• PostgreSQL
  • Views in an enterprise geodatabase
• SQL Server
  • Views in an enterprise geodatabase

• Create Database View (Data Management)
• Query layers
• Create a query layer for data in a relational database
• Make Query Layer (Data Management)

Additional Web Based and Instructor-Led Training

• Implementing Versioned Workflows in a Multiuser Geodatabase:  This course explores a variety of traditional versioned editing workflows and examines how versioning decisions impact data accuracy and database performance.
  
  
• Configuring Branch Versioning in ArcGIS:  This course prepares GIS professionals and database administrators to implement branch versioning in an enterprise geodatabase using ArcGIS Pro.

[DataScienceCenter]

First of all, thank you so much for such organized information! I have a question. All the hyperlinks in the resource lead to the ArcMap documentation page. However, ArcGIS Desktop is in mature support and will be retired March 1, 2026. After March 1 2026, will the links still available? Will the content still be there? Or will the content be transferred or updated to a ArcGIS Pro documentation?  Thank you!

[MichaelJeggle]

Thank you very much for your interest in the geodatabase documentation.  All of the links have now been updated to reference ArcGIS Pro documentation.