Course
MapInfo SQL
Course Duration
1 Day
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.
Private Courses
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.
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
What's included
-
- Lunch and refreshments when training is delivered at our training venues
- Comprehensive course materials and exercises
Course Content
-
The SQL Select dialogue boxOverview, 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 -
OperatorsMathematical
Logical
Spatial -
AggregatesWhat they do and how they work
Count(*), SIGMA and calculating statistics
SUM(), AVG(), MIN(), MAX() and weighting -
FunctionsWhat they do and how do they work
Maths functions
Date and time functions
String functions
Geographic functions -
Joining DataWhy join data?
Spatial operators and geographic joins
Text based joins – inner or outer joins
Using data from joins -
Saving queries: Pros and consSaving query templates
Saving via a workspace
Saving queries as tables
Working with queries
Explanation of error messages
Other Courses In This Series
MapInfo Expert - 32 Bit 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 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 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 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 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
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 class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. Course materials available online using your personal training account.
You can master MapInfo, please contact us to book a place or request a quote.
-
Course Options
Please contact us to discuss options for this courseBespokeBespokeBespoke 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.PrivatePrivateFlexible content, flexible date, flexible location, variable 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
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/27/2024 1:00:04 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:4/27/2024 1:00:04 AM