Skip to main content


Informatique
GIS (geographic information system): creating and managing relational databases

5  days intra
Dates to be agreed
Location to be agreed
available remotely
Training costs

Contact us to receive a personalised quote

Objectives
  • Master the design of relational databases.
  • Master the techniques of interfacing between relational databases and GIS applications.
Pedagogical programme

available remotely

The relational model

  • Notions of tables, keys and relationships.
  • Data models (CDM, LDM, relational model).
  • Queries, forms, reports.
  • Setting up method.

available remotely

Designing a relational database

  • Designing a simple database.
  • Excel implementation in Access.
  • Creating tables, keys, links, and forms, and entering data.
  • Defining SQL queries in Access.
  • Table creation queries, calculated fields.

available remotely

Links between the database and the GIS

  • Creating instant forms.
  • Linking GIS and databases: joins.
  • Cartographic representation of data taken from Access.
  • Procedures to connect to a remote database, such as ACCESS with QGIS.
  • Mapping the indicators of an ACCESS table or queries.
Target audience

Prerequisites:

  • This training session is intended for people who have already mastered the basic features of GIS. If not the training course : "GIS: data acquisition and processing" is strongly recommended to be delivered first.
Good to know
  • This training session will be mainly organised around practical computer work.
  • Exemple de programme réalisable en 5 jours
Prerequisites

Have held or currently hold a position related to the training theme

Quote request

You wish to train a group of persons

The course
Country
City
Would you like a laptop to be included in each trainee's course package?

Our in-house training courses are offered for a minimum of 5 trainees.

If you wish to train less than 5 people, we invite you to browse through our public training offer by clicking here.

You wish to train more than 20 persons ?

Training a group exceeding 20 personnes implies a detailed study by our teams : click here to express your need

Who are you ?
name
How to reach you ?
Professionnal Addresse
Is your organisation liable for VAT?