INTRODUCTION TO DATABASE SYSTEMS (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; Apply user role and right access to increase security in database system; Construct query of SQL that suitable with the problem; Design database using structured data model; Recognize database technology concept.

Topics:

1. Normalization & ER Modeling;
2. SQL – Data Definition;
3. SQL – Data Manipulation (Basic Queries 1);
4. SQL – Data Manipulation (Basic Queries 2);
5. Quiz; SQL – Data Manipulation (Multi Table Queries);
6. SQL – Data Manipulation (Basic Queries 3);
7. SQL – Data Manipulation (Sub Queries);
8. View;
9. Security and Administration;
10. Database Environment;
11. Project;
12. Introduction to Databases & The Relational Model;
13. Normalization;
14. Entity Relationship (ER) Modeling;
15. Enhanced Entity Relationship (ER) Modeling;
16. SQL – Data Definition;
17. SQL – Data Manipulation (Basic Queries 1);
18. SQL – Data Manipulation (Basic Queries 2);
19. SQL – Data Manipulation (Multi table Queries);
20. Security and Administration;
21. SQL – Data Manipulation (Sub Queries) & View;
22. SQL – Data Manipulation & View Exercise;
23. Database Environment & Architectures;
24. Data Warehousing Concepts.