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.

Download course outline

Course details

Price

960.00 SGD

Location

Singapore

Duration

2 days

Level

Intermediate

Category

Geodata Course

CPD points

Safety measures for training courses

While courses in our training facility have resumed, we want to assure you that the wellbeing of our trainees and staff remains Esri Singapore’s highest priority.

As the COVID-19 situation continues to develop, strict safety measures and guidelines as recommended by the Ministry of Health are being adhered to for all training conducted.

All computer equipment and desks are disinfected before class commences and during the lunch break, while seats are placed and marked at least 1-metre apart, in accordance with official Safe Distance Measures.

Masks are mandatory throughout training, and alcohol hand sanitisers and anti-bacterial wet wipes will be available.

Your temperature will be taken before commencement. For your safety, you will be asked to return home and see a doc if your temperature exceeds 37.5deg.

An isolation room has been prepared for trainees to rest in if they are feeling unwell and awaiting transportation.

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

Subscribe to
Esri Singapore news