ArcGIS GeoDatabases and Ms Access/SQL Server

Course Outline

2 WEEKS | Kshs 80,000 / US$ 1200

Spatial data comes in a variety of formats that can be managed in Arc Catalog and added as layers to Arc Map. The geodatabase is a new spatial data format, designed specifically for ArcGIS. Many common formats, such as shapefiles, coverages, CAD files, and geodatabases, organize spatial data into feature classes. A feature class is a group of points, lines, or polygons representing similar geographic objects. A group of lines representing rivers is a feature class. A group of polygons representing buildings is a feature class. A group of points representing hospitals is a feature class. A feature class may contain many features or few, but all its features have the same geometry – points, lines, or polygons. A shapefile consists of a single feature class. Geodatabases, coverages, and CAD files may contain several feature classes.

Geodatabases offer advantages over other spatial data formats. Many of the advantages enable coordinated relationships among feature classes. For instance, feature classes that are spatially dependent on each other can be organized into larger units called feature data sets. Water valves and water lines are physically attached and therefore spatially dependent. By making a feature data set of these two feature classes, you can ensure that if you move a water line, its water valves move with it automatically.

Microsoft Access/SQL Server

This course provides students with the knowledge and skills required to install, configure administer, and troubleshoot the client-server database management system of Microsoft SQL Server.

Objectives
  • Describe SQL Server architecture.
  • Plan for a SQL Server installation, and then install an instance of SQL Server.
  • Manage files and databases, including determining resource requirements.
  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
  • Perform and automate administrative tasks and create custom administrative tools.
  • Back up databases and implement a backup strategy.
  • Restore databases.
  • Monitor and optimize SQL Server performance.
  • Transfer and migrate data into databases.
  • Maintain the high availability of SQL Server.
  • Describe how to replicate data from one SQL Server to another.
Course Outline
  • ArcGIS GeoDatabases
    – Using Arc Catalog to create geodatabase
    – Import features into geodatabase
    – Creating Feature classes
    – Adding Fields and Domains
    – Define snapping tolerance
  • Ms Access/SQL Server
    – Describe SQL Server architecture.
    – Plan for a SQL Server installation, and then install an instance of SQL Server.
    – Manage files and databases, including determining resource requirements.
    – Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
    – Perform and automate administrative tasks and create custom administrative tools.
    – Back up databases and implement a backup strategy.
    – Restore databases.
    – Monitor and optimize SQL Server performance.
    – Transfer and migrate data into databases.
    – Maintain the high availability of SQL Server.
    – Describe how to replicate data from one SQL Server to another.
Prerequisites

Experience using the Microsoft Windows operating system.