SQL in MapInfo Training Courses

SQL Dialogue Box

1. field descriptions and explanations
   
2. grouping data
   
3. sorting data
   
4. selecting columns

Aggregates

1. when to use count(*)
   
2. sum, min and max
   
3. weighted averages
   

Functions

1. maths funtions
   
2. date/time functions
   
3. string functions
   
4. geographic functions
5. deriving data
   
   

Joining Data

1. objects
   
2. geographic joins
   
3. text based joins
   
4. deriving data from joins
   
5. other MapInfo joins

Saving Queries

1. saving templates
2. saving workspace based queries
3. saving queries as tables
4. working with queries