2.1.05b. SQL command syntax

  • Where follows here is a brief summary
    • Oracle syntax
    • Similar but not identical to MySQL/MSSQL
  • General familiarity
  • Query writing best learnt by doing it
  • Lecture live-example
  • Coursework 1 will be SQL
  • Oracle (9i) SQL reference
  • MySQL (5.0) SQL reference