DATABASE TECHNOLOGY (2/1 Credits)

Learning Outcomes:

On this course, students will be able to learn about how to

1. Define model data and information in the form of concept diagrams and physical diagrams and apply them to the database in a DBMS, both individually and in teamwork.
2. Explain the concepts of relational algebra, DDL, DML, transaction management on database and concurrency control
3. Apply to make database applications to manipulate data in databases

Topics:

1. Introduction to database system
2. Entity Relational Model
3. The Relational Model
4. Schema Refinement And Normal Forms
5. Schema Refinement And Normal Forms (2)
6. Physical Database Design And Tuning
7. Relational Algebra and Calculus
8. SQL : Queries, Programming and Triggers
9. SQL : Queries, Programming and Triggers (2)
10. SQL : Queries, Programming and Triggers (3)
11. Database Application Development
12. Overview of Transaction Management
13. Concurency Control
14. 1. Introduction MySQL
15. 2. MySQl – Create, Drop, Select Database, Data types
16. 3. My SQL – Create, Drop, Insert Tables, Select Query, Where Clause
17. 4. My SQL – Select Update, Delete Query, Like Clause
18. 5. MySQL – Sorting, Join Query
19. 6. Null Values, Transactions, Alter Command, Indexes
20. 7. Temporary Tables, Database Import, Database Export