Deploying and Maintaining a Multiuser Geodatabase (Online)

20% OFF (Coupon Code: nocovid19)

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 suitable for Spatial database administrators and GIS data managers who need to create, configure, and manage a multiuser ArcSDE geodatabase.

Course details

Location

Online

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 Indonesia’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. Acrylic partitions have also been installed between each desk.

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.

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