DATABASE TECHNOLOGY (2/1 SCU)

Learning Outcomes:

On successful completion of this course, students will be able to: LO1 – define model data and information in the form of conceptual and apply them to the DBMS, both individually and in teamwork; LO2 – explain the concepts of relational algebra, data manipulation language, and transaction management on database; LO3 – apply to make database and manipulate data in databases.

Topics:

1. SQL : Queries, Programming and Triggers;
2. SQL : Queries, Programming and Triggers (2);
3. Database Application Development;
4. Overview of Transaction Management;
5. Concurrency Control;
6. Introduction to Database System;
7. Entity Relational Model;
8. The Relational Database Constraints and SQL;
9. Relational Algebra;
10. Relational Calculus;
11. Schema Refinement;
12. Normal Forms;
13. Physical Database Design And Tuning;
14. Database Fundamentals and MySQL Basics;
15. Basic MySQL Queries and Functions;
16. Table Operations and Transactions;
17. MySQL Operations;
18. Simple MySQL Queries;
19. Final Exam.