DATABASE (2/2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: describe concepts, terminologies, environment, and relational model in database system; construct query of SQL that suitable with the problem; design database using structured data model; apply user role and right access to increase security in database system.

Topics:

1. Database Systems Development Lifecycle;
2. Database Environment;
3. SQL: Data Definition Language (2);
4. Final Quiz & Review;
5. Introduction to Databases;
6. The Relational Model;
7. Database Environment;
8. SQL – Data Definition Language (1);
9. SQL – Data Definition Language (2);
10. SQL – Data Manipulation Language (1);
11. SQL – Data Manipulation Language (2);
12. Normalization;
13. Entity Relationship (ER) Modelling;
14. Enhanced Entity-Relationship Modelling;
15. Security and Administration;
16. SQL: Data Definition Language (1);
17. SQL: Data Definition Language (3);
18. SQL: Data Manipulation Language (1);
19. SQL: Data Manipulation Language (2);
20. SQL: Data Manipulation Language (3);
21. SQL: Data Manipulation Language (4);
22. Security and Administration;
23. Normalization & ER Modelling.