The following topics will be addressed:
- Overview of database design and management
- File Systems and Databases
- E-R Modelling Concepts
- E-R Modelling Methodology and Application
- The Structured Query Language (SQL)
- Transforming Conceptual Data Models to SQL
- Normalisation
- Database Management
- Database warehousing
- XML and Web Databases
For entry into this course, applicants must have at least an undergraduate degree, or five (5) years relevant work experience. Applicants may also be asked to provide an up-to-date Curriculum Vitae.
The teaching methods to be used in this course include the interactive lecture, in-class and online discussion (via eLearning), and practical exercises (lab sessions). Much emphasis will be placed on providing delegates with hands-on experience in applying concepts, principles, and techniques learned through participatory classroom demonstrations, practical exercises, and individual/group assignments. The use of various technological media such as PowerPoint and video illustrations of step-by-step procedures will also be incorporated in each session to aid in the teaching of complex concepts.