Database Concepts (RDBMS & SQL)


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 emphasize the need, role, importance and uses of databases in applications development
  • To apply specific SQL statement on relational tables as per requirements
  • To sensitize the learner on issues of database security and the challenges involved

List of Lessons:


  1. Introduction to Databases & Database Management Systems
  2. Basics of Database Modeling & Entity-Relationship Diagrams
  3. Applications of E-R Modeling I
  4. Applications of E-R Modeling II
  5. Introduction to Database Normalization - Why, What, How
  6. The First & Second Normal Forms
  7. The Third Normal Form
  8. The Boyce-Cood Normal Form
  9. Introduction to Structured Query Language (SQL)
  10. Using SQL - I
  11. Using SQL - II
  12. Elements of using JOIN
  13. Managing Database Objects
  14. Data Dictionary & Database Security
  15. A Peek at What Lies Ahead in RDBMS