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 conceptual and apply them to the DBMS, both individually and in teamwork
2. Explain the concepts of relational algebra, data manipulation language, and transaction management on database
3. Apply to make database and manipulate data in databases

Topics:

1. Exploring Advanced SQL
2. Overview of Transaction Management
3. Concurency Control
4. Introduction to Database System
5. Entity Relational Model
6. The Relational Database Constraints and SQL
7. Relational Algebra
8. Relational Calculus
9. Schema Refinement
10. Normal Forms
11. Physical Database Design And Tuning
12. Database Fundamentals and MySQL Basics
13. Basic MySQL Queries and Functions
14. Table Operations and Transactions
15. MySQL Operations
16. Simple MySQL Queries
17. Final Exam
18. Project Presentation
19. Exploring Intermediate SQL