Database concepts and SQL

Validity Period: 90 Days

Learning Objectives:

  • To lay a strong foundation into the basic principles, theory and practice of using relational databases
  • To emphasize the need, role, importance and uses of databases in applications development
  • To distinguish between different models of organizing, storing and use of data
  • To lay the foundation for the study and use of relational databases
  • To perform E-R modeling in a given situation and provide the foundation for development of relational database structure
  • To develop relational tables and be able to normalize the tables as per specific normalization forms
  • To apply specific SQL statement on relational tables as per requirements
  • To sensitize the learner on issues of database security and the challenges involved