Completion of ArcGIS 2 – Essentials of ArcGIS 10.x for Desktop or equivalent knowledge, and experience managing a relational database management system are required.
Deploying and Maintaining a Multiuser Geodatabase
Support your organisation’s data management workflows.
Prepare to successfully create a multiuser geodatabase to store and manage your organisation’s geographic data. Learn about the multiuser geodatabase architecture, configuration options, and techniques to efficiently load data, assign user privileges, and maintain performance over time.
Note: Course concepts apply to ArcGIS 10.4, 10.5, 10.6 and 10.7.
ArcGIS Enterprise 10.6 (Standard or Advanced)
ArcGIS Desktop 10.6 (Standard or Advanced)
Microsoft SQL Server Standard 2014
What is a multiuser geodatabase? Multi-tier architecture, Identifying the appropriate software tier, Multiuser geodatabase components
Hierarchy of users, Comparing tools for making a multiuser geodatabase, Create an enterprise geodatabase, Explore the repository
Connecting to the geodatabase RDBMS client software, Create a connection, Software version compatibility, Authentication methods, Connection files
Loading data into the geodatabase Data owner account, Create the data owner account, RDBMS considerations, Geoprocessing environment settings, Choosing a data-loading tool, Updating datasets, Automation, Use ModelBuilder
Configuring privileges Data users, Creating data users, Roles, Manage users, Defining roles, Designing roles, Securing credentials
Managing storage Configuration parameters, Configuration keywords
Maintaining the geodatabase Attribute indexes, Statistics, Manage attribute indexes and statistics, Spatial indexes, Maintaining geodatabase performance for versioned data, Scheduling tasks, Manage performance tasks with Python, Schema locks, View and clear locks
Associating data Query layers, Create query layers, Database views, Create database views, Choosing between query layers and database views, Determining whether to create query layers or database views
Applying the geodatabase workflow Geodatabase workflow, Geodatabase responsibilities, Geodatabase tasks