Laserfiche WebLink
managing Arclnfo geodatabases on an ArcSDE system is covered in detail . The course <br /> focuses on understanding how ArcSDE software interacts with SQL Server and proposes solid <br /> strategies for maintaining an enterprise GIS database . <br /> Audience <br /> This course is for experienced SQL Server database administrators who need to manage <br /> ArcSDE databases and clients . Participants should have at least six months prior experience <br /> working with Microsoft SQL Server . <br /> Goals <br /> • Configure SQL Server to support ArcSDE <br /> • Install and configure ArcSDE <br /> • Create vector feature classes and raster datasets <br /> • Configure , create, and monitor application server, direct , and OLE DB connections <br /> • Customize storage for ArcSDE vector and raster data <br /> • Monitor and optimize query access <br /> • Manage a multiversioned geodatabase <br /> Topics covered <br /> • ArcSDE installation : Evaluating the SQL Server configuration; Preparing SQL Server to <br /> use ArcSDE; Installing ArcSDE; Starting and stopping the ArcSDE server; Exploring <br /> ArcSDE system tables; Configuring ArcSDE and SQL Server on separate hosts <br /> • Data loading : Creating storage space; Creating users and assigning privileges; <br /> Calculating a spatial domain ; Creating vector feature classes from coverages and <br /> ` shapefiles ; Creating raster datasets from image files; Building raster catalogs and <br /> mosaics ; Estimating storage needs ; Examining feature class components : Customizing <br /> storage with the DBTUNE table <br /> - Monitoring data access : Creating application server, direct, and OLE DB <br /> connections ; Monitoring connections with ArcSDE and SQL Server tools ; Tracing client <br /> queries ; Reporting system 1 /0 <br /> • Optimizing data access : Analyzing spatial index performance ; Creating a group <br /> layer; Creating a spatial view; Working with overview and magnify windows, raster <br /> wire frames , scale-dependent layers, and thumbnails <br /> • Managing a multiversioned geodatabase : Registering feature classes as versioned ; <br /> Choosing version privileges ; Reconciling and posting changes between versions ; <br /> Compressing the state tree; Monitoring changes to the adds, deletes , and system <br /> tables <br /> Prerequisites and recommendations <br /> Participants in this course should have experience with the following : <br /> • SQL Server database administration or application development <br /> • Administering a Windows operating system <br /> • Managing database storage <br /> • Creating SQL Server users and assigning their privileges <br /> • Designing tables, indexes , constraints , and triggers <br /> • Using spatial and tabular data from a GIS application <br /> • SQL <br /> Price : 12, 250 per person Reduced rates may apply for onsite training ( ESRI currently charges <br /> $ 17 ,500 for on-site training ' ESRI authorized instructors may charge less ) <br /> 8 -7 <br /> GIS Needs Assessment and Implementation Plan Chapter 8 - GIS Training and Education <br />