• My early learning of programming (including database programming) used an iterative approach.

  • First you would be taught the very basics i.e. theory of syntax (at such a simple level that just says everything you type matters).
  • Next you would be shown a simple example of syntax; for programming something like output to console, for databases a SELECT statement.
  • Then you would do an exercise on it in order to demonstrate ones understanding.
  • Next you would be taught something further like the basics of relational theory and the associated syntax.
  • Then you would do an exercise on simple joins using foreign keys i.e. INNER JOIN.
  • Obviously, the lecturers gauged what they could group together in order to ensure that appropriate use of classrooms and labs were used.

    Unfortunately, most books are light on the theory as (to quote Koen) "it's boring". What the book purchasers like are the results on screen but they are unaware that they have been cheated from gaining true knowledge and understanding.

    Gaz

    -- Stop your grinnin' and drop your linen...they're everywhere!!!