DATABASE FUNDAMENTAL (4/2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to: LO1 – describe terminologies, concepts, and environment of relational model in database systems; LO2 – recognize database objects, the privileges in database security, and database transactions; LO3 – apply Structured Query Language that is suitable for the problem.

Topics:

1. Database Systems and Data Models;
2. The Relational Database Model and The Entity-Relationship Diagram;
3. Data Definition Language;
4. Constraints;
5. Database Security, Privileges, and Transaction Control Language;
6. Data Manipulation Language;
7. Basic SELECT Queries;
8. Single Row Functions;
9. JOINs, Sequences, Synonyms, and Regular Expressions;
10. Group Functions;
11. Subqueries;
12. Sequences and Synonyms, and Regular Expressions;
13. Views.