Course Descriptions

Essential Geoprocessing and Data Management Tools

Geoprocessing with Python

This intensive 3-day course extends the skills of experienced GIS users by giving them the knowledge and confidence to use Python to gain access to more advanced functionality within ArcGIS software in order to accomplish their everyday tasks more efficiently.  Some of the key topics covered include:

  • Variables
  • Data Types and Structures
  • Logic & Looping
  • Geoprocessing and Scripting
  • Geometry access & creation
  • Classes
  • Code Design

MS Access and SQL Training

This course introduces students to the power of databases by teaching them how to input, query, and extract information from an Access database.  Students receive an overview of database structures and design and hands-on practice building and using both simple and complex SQL queries, as well as learning how to visualize tabular data in a map environment.  Some of the key topics covered include:

  • Introduction to MS Access and SQL
  • Basic SQL Select-"The Heart of SQL"
  • Creating a Database
  • Managing the Database-Insert, Update, Delete, Create
  • Beyond Select...From...Where
  • Utilizing Access in ArcGIS

Essential Geoprocessing and Data Management

Knowing how to properly and efficiently manage your data and making the most of the tools available means higher data quality and the elimination of repetitive data processing tasks. This course guides users on how to implement proper data management techniques and how to use the available tools to ensure they implement consistent, efficient data processing proceedures. This course is essential for all users, from map makers to data managers alike.  Some of the key topics covered include:

  • Using ModelBuilder to build your own geoprocessing tools
  • Maintain data quality by ensuring all users adhere to proper data management principals
  • Use batch processes to eliminate repetitive tasks
  • Optimizing Performance
  • Considerations when working with large datasets
  • Document and share processes and tools to ensure consistent data quality
  • Tips for managing large datasets and working with conversions from CAD

GIS Essentials

GIS for the Oil and Gas Industry

This course is taught at an introductory level and examines the concepts behind spatial data and use of GIS software in the Oil and Gas industry. This course provides students with an excellent overview of general spatial data concepts and software, as well as providing hands-on experience working with the components, functions and applications of ArcGIS. Some of the key topics covered include:

  • Coordinate Systems, Map Projections, and Datums
  • Map Design and Presentation
  • Labeling, Annotation and Map Graphics
  • Geoprocessing Techniques
  • Attribute and Spatial Data Queries  

Working with Coordinate Systems

This course is designed for novice users of ArcGIS that need to learn how to properly work with and understand coordinate systems and projections. The course provides an overview of how to work with projections and coordinate systems in ArcGIS. Using a hands on approach students focus on common projections used in the western Canadian oil and gas industry. Students will become comfortable handling data with varying projections and understanding how proper use of coordinate systems can influence the decisions that they make. Some of the key topics covered include:

  • Choosing the Appropriate Coordinate System
  • Projection Families
  • Datum Transformation
  • Working with Coordinate Systems in ArcMap

Spatial Analysis using Raster Techniques

This course offers GIS users an opportunity to learn about the power behind the ESRI Spatial Analyst extension for ArcGIS. This extension offers a broad range of spatial modeling and analysis tools that are particularly suited for Oil and Gas analysis and decision support. Students will be given a broad overview of the Spatial Analyst extension as well as a deep understanding of relevant Oil and Gas applications. Hands-on sessions are used to explore:

  • Raster Datasets - Types and Properties 
  • Raster Analysis and Analysis Environment
  • File Format Support and Data Conversions
  • Generating and Managing Digital Elevation Models
  • Choosing Interpolation Techniques
  • Raster Calculator Capabilities
  • Automation Using Model Builder

Where's My Data?

Businesses make a significant investment into the development of their data resouces. As important as the investment into the data itself is ensuring that the business users are aware of the resources that are available to them. This course is a 100% customized course that introduces students to the data resources available for them to incorporate into their workflow.

  • Data Resoures
  • Templates
  • Data Management Approach
  • Data Standards (Naming Convention, Symbology)
  • Metadata Standards
  • Querying and Selecting Events

Editing and Georeferencing

This course covers important aspects of Editing and Georeferencing. This includes how to create new datasets as well as edit existing data including attributes using a variety of editing tools and commands. Shortcuts and good practice approaches are presented to develop efficient workflows. A variety of techniques are introduced that can be used to georeference datasets to real world coordinates. Methods for working with CAD, raster and vector data formats will be explored in a hands on environment. Some of the key topics covered include:

  • Feature Structure
  • Field Calculator
  • Spatial Adjustment
  • Transformations
  • Rectifying an Image

Label Management

This course covers the many approaches that can be taken when using text in your mapping projects. The course starts with basic labeling techniques including a discussion of best practices and advances through more advanced labeling methods. Students will learn efficient labeling techniques that can be incorporated directly into their workflows. Some of the key topics covered include:

  • Maplex
  • Label Classes
  • Basic Annotation
  • Advanced Expressions
  • Flow of Control Expressions
  • Conditional Logic Expressions
(403) 870-8926
#2 1204 3rd St SE
Calgary, AB T2G 2S9
  Brain Candiii is a division of
Integrated Informatics Inc.