The syllabus below outlines the kind of subjects we cover in the course, although it's worth emphasising that every Lightenna Training course is tailored to the needs of the group. Some subjects are therefore covered in greater depth than others.

• Database Models
  • Language
  • Entity-relationship model
  • Mini-world, left-hand:right-hand divide
  • UML diagrams
  • The relational model
  • Table fragmentation
  • Table joins
  • ER to relational mapping
  • Type Inheritance
  • Objects
  • Inheritance
  • EER
  • UML revisted
  • EER to relation mapping (revisited)
  • Database Systems
    • 3 Users
      • Naive
      • Power-user
      • DBA
    • 3 Levels
      • Views
      • View equivalence
    • Conceptual layer
      • Query design
      • Query-By-Example
    • Internal layer
      • Buffers, caches and optimisation
    • The SQL language
      • SQL92 (1992), SQL3 (1999), SQL2003
      • Implementations
        • Oracle
        • MySQL
      • SQL concurrency control levels
    • Database Design
    • Functional dependency
    • Normal Forms
    • Normalisation to Boyce-Codd Normal Form and 3rd normal form
    • Object orientation
    • Type inheritance
    • Database Transactions
    • Desirable properties of transactions
    • Commit and rollback
    • Concurrency control methods
    • Serializability
    • Locking and time-stamping.
    • Distributed Databases
    • The principles of the design and implementation of distributed databases.
    • Client-server database systems.
    • Real World Databases
    • Implementation/Programming
    • Databases on the Web
    • Heterogenous formats, format translation
    • Requirements of Multimedia Databases
    • System Design (analysis)
    up