Latest Contributions by MichaelJeggle

This course teaches best practices to plan and implement geodatabase replication to support enterprise editing workflows and data-sharing initiatives. Learn how to protect the integrity and performance of your production database as data is collected and updated to reflect real-world conditions.   Resources Lesson 1 – Defining Geodatabase Replication Introduction to distributed data Distributed data scenarios Geodatabase replication fundamentals   Lesson 2 – Two-way Replication Geodatabase replication fundamentals Replication types Replication and versioning Prepare data for replication Create a two-way replica What is synchronization? A quick tour of replica synchronization Resolve synchronization conflicts manually   Lesson 3 – One-way Replication Replication types Replication and versioning Prepare data for replication Create a one-way replica What is synchronization? A quick tour of replica synchronization    Lesson 4 – Checkout/check-in Replication Replication types Replication and versioning Prepare data for replication Create a checkout replica What is synchronization? A quick tour of replica synchronization   Lesson 5 – Managing Schema Changes Geodatabase replication fundamentals   Lesson 6 – Implications of Replication Workflows A quick tour of replica management Work with replica logs Replication and geodatabase compatibility   Lesson 7 – Using replication within ArcGIS Enterprise Replication and geodata services What is ArcGIS Enterprise? Base ArcGIS Enterprise deployment ArcGIS Enterprise Functionality Matrix ArcGIS Enterprise deployment tools   Additional Web Based and Instructor-Led Training Deploying and Maintaining a Multiuser Geodatabase:  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. Implementing Versioned Workflows in a Multiuser Geodatabase:  Learn a sound versioning workflow that minimizes disruption to editors, ensures the integrity of your organization's GIS data, and integrates well with existing business workflows. This course explores a variety of versioned editing workflows and examines how versioning decisions impact data accuracy and database performance. Managing Geospatial Data in ArcGIS:  This course takes you on an in-depth exploration of the geodatabase, the native data storage format for ArcGIS software. Best practices to create a geodatabase to centrally store and efficiently manage your organization's authoritative geospatial data are covered. You will develop skills needed to configure unique geodatabase features that ensure data integrity and accuracy over time and a thorough understanding of file and enterprise geodatabase capabilities. Archiving Data in a Multiuser Geodatabase:  Archive your GIS data to preserve a record of feature-level changes. View data snapshots at specific points in time and examine how patterns have evolved over time. This course teaches basic geodatabase concepts to archive data stored in a versioned multiuser geodatabase. ... View more

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.   ... View more

Learn a sound versioning workflow that minimizes disruption to editors, ensures the integrity of your organization's GIS data, and integrates well with existing business workflows. This course explores a variety of versioned editing workflows and examines how versioning decisions impact data accuracy and database performance.   Resources Lesson 1 – Establishing the multiuser editing environment Overview of versioning Versioning Types   Lesson 2 – Organizing versions Create a traditional version Delete a traditional version Connect to a traditional version Manage traditional versions   Lesson 3 – Edit isolation using delta tables Register a dataset as traditional versioned The traditional versioning editing process   Lesson 4 – Exploring versioning repository tables System tables of a geodatabase in SQL Server System tables of a geodatabase in Oracle System tables of a geodatabase in PostgreSQL   Lesson 5 – Merging lineages through reconcile and post View traditional version changes The traditional versioning editing process Reconcile and post edits to a traditional version   Lesson 6 – Reviewing conflicts Manage traditional version conflicts   Lesson 7 – Migrating edits to the base tables Using Python scripting to batch reconcile and post traditional versions Recommended traditional version administration workflow   Lesson 8 – Creating two-way replicas Distributed data scenarios Geodatabase replication fundamentals Replication and versioning Prepare data for replication Create a two-way replica Connected replica synchronization Synchronization and versioning   Lesson 9 – Creating one-way replicas Create a one-way replica What is synchronization?   Lesson 10 – Creating check-out replicas Create a checkout replica   Lesson 11 – Versioned editing with third-party apps What is a versioned view? Reading versioned data using SQL in SQL Server A quick tour of editing versioned data using SQL   Additional Web Based and Instructor-Led Training Deploying and Maintaining a Multiuser Geodatabase:  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. Distributing Data Using Geodatabase Replication:  This course teaches best practices to plan and implement geodatabase replication to support enterprise editing workflows and data-sharing initiatives. Learn how to protect the integrity and performance of your production database as data is collected and updated to reflect real-world conditions. Managing Geospatial Data in ArcGIS:  This course takes you on an in-depth exploration of the geodatabase, the native data storage format for ArcGIS software. Best practices to create a geodatabase to centrally store and efficiently manage your organization's authoritative geospatial data are covered. You will develop skills needed to configure unique geodatabase features that ensure data integrity and accuracy over time and a thorough understanding of file and enterprise geodatabase capabilities. Archiving Data in a Multiuser Geodatabase:  Archive your GIS data to preserve a record of feature-level changes. View data snapshots at specific points in time and examine how patterns have evolved over time. This course teaches basic geodatabase concepts to archive data stored in a versioned multiuser geodatabase. ... View more