Training Course

MapInfo SQL

Download Course PDF

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Duration

1 Day

MapInfo SQL 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.

Included with this course

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

MapInfo SQL 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

 

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • 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

All of the course was extremally valuable

P.M. south Tyneside Council, Computers for Beginners and Getting Started with MS Office

The training session has been very helpful as I can apply this knowledge when using the various features and apps.

R.K. Watmos, Microsoft Office 365 Overview

Any other comments or recommendations I have obtained so much from this course, would recommend to anyone

A.M. PX Group, Word Advanced Features

Excellent training, excellent facilities

A. , Computers for Beginners and Getting Started with MS Office

Another very useful course that will help me in my job role, brilliant, thank you.

L.B. Greggs, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

What were the most useful aspects of the course Learning all aspects of communication and understanding much clearer how everyone has different thought processes

F.R. Cenergist Ltd, Personal Effectiveness and Communication Skills with Clarity 4D Personality Profile

Which part of the course did you find particularly valuable I found the whole course very valuable, I had no previous knowledge of sage and the trainer was very patient and explained the course in great detail

N.D. Newcastle GP Services, Sage Accounts Level 1

I will be putting the new skills I have learned into practice immediately

H.S. Durham County Council, Microsoft Power BI Desktop

+ View More Training Reviews

 

Private Training

Flexible dates, location and content. All prices exclude VAT.

Other Courses In This Training Series

MapInfo Expert - 32 Bit Course Course Overview: We offer MapInfo training on a private course basis only. This course is not available as a public scheduled event.The course is aimed at those who have good knowledge and experience in the use of MapInfo data and the software and are ready to further their knowledge through some advanced MapInfo tr MapInfo Expert - 64 Bit Course Course Overview: We offer Mapinfo training on a private course basis only. This course is not available as a public scheduled event.The course is aimed at those who have good knowledge and experience in the use of MapInfo data and the software and are ready to further their knowledge through some advanced MapInfo tr MapInfo RouteFinder Pro Course Course Overview: We offer MapInfo training on a private course basis only. This course is not available as a public scheduled event.The course is designed for users who need to use the networking, isochrones and drive time capabilities of RouteFinder Pro for MapInfo. This course is for either versions of V12.5 or a MapInfo Standard - 32 Bit Course Course Overview: We offer MapInfo training on a private course basis only. This course is not available as a public scheduled event.The course is aimed at those who are new to MapInfo™, or at those at a novice level. The aim is to give users confidence to use the power of GIS and MapInfo™ to disp MapInfo Standard - 64 Bit Course Course Overview: We offer MapInfo training on a private course basis only. This course is not available as a public scheduled event.The course is aimed at those who have gained some experience in the use of MapInfo data and the software and are ready to further their knowledge. The aim is to give the MapInfo traine

 

 

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 request 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:9/11/2024 10:19:49 AM