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 administration Geodatabase administration terminology Migrate from ArcSDE administration commands to ArcGIS Desktop Geodatabase storage in a relational database How are geodatabases stored in a DBMS? Geodatabases in SQL Server Setting up a geodatabase in SQL Server A comparison of geodatabase owners in SQL Server System tables of a geodatabase in SQL Server The geodatabase administrator in SQL Server Geodatabases in Oracle Setting up a geodatabase in Oracle System tables of a geodatabase in Oracle The geodatabase administrator in Oracle Geodatabases in PostgreSQL Setting up a geodatabase in PostgreSQL in Windows or Linux System tables of a geodatabase in PostgreSQL An overview of the Geodatabase Administration toolset Create Enterprise Geodatabase Enable Enterprise Geodatabase   Lesson 2 - Connecting to the geodatabase Connect to SQL Server Connect to SQL Server from ArcGIS Connecting to Oracle Connect to Oracle from ArcGIS Connecting to PostgreSQL Connect to PostgreSQL from ArcGIS   Lesson 3 – Loading data into the geodatabase Create Database Users (Data Management) Truncate Table (Data Management) Append (Data Management) Adding datasets and other geodatabase elements Loading data An overview of the Conversion toolbox Loading data in the Catalog tree Loading data in ArcMap Append (Data Management) What is a geoprocessing environment setting? A quick tour of creating custom tools   Lesson 4 – Configuring privileges SQL Server Add logins and users to SQL Server Privileges for geodatabases in SQL Server Granting and revoking privileges on datasets Managing connections in SQL Server Oracle Add logins and users to Oracle Privileges for geodatabases in Oracle Granting and revoking privileges on datasets Managing connections in Oracle PostgreSQL Add login roles to PostgreSQL Privileges for geodatabases in PostgreSQL Granting and revoking privileges on datasets Managing connections in PostgreSQL Create Role (Data Management) Create Database User (Data Management) Change Privileges (Data Management)   Lesson 5 – Managing storage Configuration keywords What are configuration keywords? Configuration keywords for enterprise geodatabases DBTUNE table SQL Server SQL Server DBTUNE configuration parameters Altering the contents of the SDE_dbtune table Oracle Oracle DBTUNE configuration parameters Altering the contents of the SDE_dbtune table PostgreSQL PostgreSQL DBTUNE configuration parameters Altering configuration keywords Spatial data types Spatial types in databases Geodatabases in Microsoft SQL Server  SQL Server data types supported in ArcGIS SQL Server spatial types and ArcGIS Geodatabases in Oracle  Oracle data types supported in ArcGIS What is the ST_GEOMETRY storage type? ST_GEOMETRY storage in Oracle SDO_GEOMETRY and ArcGIS Geodatabases in PostgreSQL  PostgreSQL data types supported in ArcGIS What is the ST_GEOMETRY storage type? ST_GEOMETRY storage in PostgreSQL   Lesson 6 – Maintaining the geodatabase Geodatabase maintenance (RDBMS specific links) Maintenance overview: Sql Server | Oracle | PostgreSQL Update database statistics: Sql Server | Oracle | PostgreSQL Rebuild system table indexes: Sql Server | Oracle | PostgreSQL Versioning administration (reconcile, post, compress): Sql Server | Oracle | PostgreSQL Upgrade geodatabase: Sql Server | Oracle | PostgreSQL Attribute indexes Creating attribute indexes Managing indexes and statistics (Data Management tools) Analyze Datasets Analyze Add Attribute Index Remove Attribute Index Add Spatial Index Remove Spatial Index Rebuild Indexes Spatial Indexes An overview of spatial indexes in the geodatabase ArcGIS and Microsoft spatial types Spatial indexes and ST_Geometry Compress The compress operation and geodatabases Compress a versioned geodatabase Geodatabase compression: Sql Server | Oracle | PostgreSQL Compress (Data management) Locks Schema locking Manage connections : Sql Server | Oracle | PostgreSQL Prevent geodatabase connections : Sql Server | Oracle | PostgreSQL Geodatabase locks : Sql Server | Oracle | PostgreSQL Managing geodatabase locks : Sql Server | Oracle | PostgreSQL Concurrency and locking   Lesson 7 – Associating data Database views Create a database view in ArcGIS for Desktop Views in an enterprise geodatabase: Sql Server | Oracle | PostgreSQL Create Database View (Data Management) Make Table View (Data Management) Query layers What is a query layer? (folder) Creating a query layer Make Query Layer (Data Management) Make Query Table (Data Management) SQL Joins (SQL) SQL JOIN and different types of JOINs W3schools SQL tutorial   Additional Web Based and Instructor-Led Training Implementing Versioned Workflows in a Multiuser Geodatabase:  This course explores a variety of versioned editing workflows and examines how versioning decisions impact data accuracy and database performance. 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. Explore our Courses:  Search for and enroll in a variety of Esri Training learning formats such as Instructor Led, Web Learning, Seminars, MOOC's and more. Learn ArcGIS:  Guided lessons based on real-world problems. ... 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