NUS Extension

Professional & Management



This course is design for persons who wish to learn current database technologies and skills in database design and development. No prior programming experience is assumed. However, participants who have programming knowledge should find the course useful in understanding database design and development for large-scale, multi-users application.




2 Days


Click on the selected date to apply now or download registration form to apply later.

Intake 01
30 - 31 Jul 09

Intake 02
20 - 21 Aug 09

Intake 03
28 - 29 Sep 09




S$700 (Inclusive of GST)


NUS Extension (#12-01 Park Mall)

 


Database Systems: A Practical Approach to Design, Development & Management

This course provides foundation to understand database technology supporting enterprise computing and electronic commerce applications, which are widely used in organisations and the Internet. It aims to provide practical and proven approach to designing, developing and managing relational database systems. Participants who wish to expand their knowledge in programming will benefit from learning the practical skills in database design for the development of enterprise wide application.


Foundation of Relational Databases

  • Introduction to Database Management System
  • The Relational Model
  • Basic SQL Commands


Database Development

  • Understanding Entity Relationship Data Modeling
  • Developing ER Data Model for Business Application
  • Normalisation of Relational Tables
  • Physical Database Design Consideration
  • Advanced SQL Commands
  • Transaction Management
  • Stored Procedures and Triggers


Managing Database Systems

  • Data Security
  • Database Administration
  • Data Warehouse Technology and Management
  • Client-Server Database Systems

top