Training Course

MapInfo SQL

PDF
Course Duration: 1 Day

Course Overview

We offer MapInfo training on a private course basis only. This course is not available as a public scheduled event.

The one-day SQL course is designed for users with a good knowledge of MapInfo, but who have difficulty getting to grips with query building and the management and use of queries.

It’s for those using any version of MapInfo Pro and is run as a hands-on session. Training notes are provided for back-up and revision purposes.

The course’s aim is to give the user the ability to use SQL within MapInfo and allow them to textually and spatially analyse data.

Course Content

  • The SQL Select dialogue box

    Overview, with explanations of drop-downs and boxes What data goes in which box Grouping data by column Sorting data by column Selecting columns and formatting an answer Browser shortcuts for all the above

  • Operators

    Mathematical Logical Spatial

  • Aggregates

    What they do and how they work Count(*), SIGMA and calculating statistics SUM(), AVG(), MIN(), MAX() and weighting

  • Functions

    What they do and how do they work Maths functions Date and time functions String functions Geographic functions

  • Joining Data

    Why join data? Spatial operators and geographic joins Text based joins – inner or outer joins Using data from joins

  • Saving queries: Pros and cons

    Saving query templates Saving via a workspace Saving queries as tables Working with queries Explanation of error messages

Included with this course

    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises

 

Private Training

Private course
Flexible date and location
Please quote for prices

  • Course Options

    Private courses:
    Private course
    Flexible date and location
    Please quote for prices
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask a Question
  • MapInfo SQL Course Options
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
  • Virtual Training

 

Course Reviews
Following this training what are you going to do differently Will be leading the effort to replace a large number of reports currently done in Excel with Power BI variants to better present the data, and make reproduction far faster.

T.W. Network Rail, Microsoft Power BI Desktop

Very patient and understanding trainer

M.R. Gsk, Excel Level 2

Following this training what are you going to do differently I am going to be incorporating the standards I have learned and produce more comprehensive content packs.

J.I. Nhs Bsa, Microsoft Power BI Desktop

The trainer unveiled a lot of well hid little sneak cheats on making life a lot easier whilst working in Word. Really enjoyed the training, I work mainly in Excel, so it was great to learn about Word, and I39m no longer afraid to work in it.

D.I. Houghton International, Word Essentials

Course was really detailed and informative.

N.F. , Excel Level 3

Which part of the course did you find particularly valuable All of the course. A lot of these are tips that I will use every now and then, and some i.e. quick paths are ones I will begin using regularly.

C. Gachet, Managing your Inbox using Microsoft Outlook

Which part of the course did you find particularly valuable Knowledge on different scenarios. Knowledge from the trainer. Ability to be more confident at work.

T.W. Cirrus Environmental Solutions Ltd, HR Essentials

Which part of the course did you find particularly valuable DAX language, manipulating the data, creating visuals, how to export data into PowerPoint

L.B. Nepo, Microsoft Power BI Desktop

 

 

Please contact us to discuss your MapInfo SQL course, we have many solutions available to ensure you receive the best training possible.
 You can choose your learning path and delivery style.  Courses can be delivered at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible MapInfo SQL course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master MapInfo, please contact us to book a place or get a quote for your MapInfo SQL course.
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:8/23/2026 10:55:12 PM