Ok in an SQL table can you name collums anything you want.

For example you have a table named Categories with a callum named ID.

Could one call the ID colum in the Categories table somthing else for example Cats2ID

this is not necessarily a dolphin question per se' . though dolphin uses a database, which is mysql, support and suggestions specific to RDMS's would be better answered on relative forums. 

a good jump off point for understanding mysql is something i refer to many:

SQL Course:

Welcome to SQLCourse.com!

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the interpreter will support everything covered in this course.

If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL 

http://www.sqlcourse.com/index.html