Technology Database Systems I

Course content:
1. database design, ERD.
2. ERD.
3. Convert from conceptual to database model.
4. Introduction into SQL, SELECT.
5. Function, relationships.
6. Construction of GROUP BY, subquery, proprietary relationships in DBMS Oracle.
7. DML (Data Manipulatin Language).
8. DDL (Data Definition Languade).
9. Creating and working with view.
10. Creating and managing Constraints.
11. Introduction into database security.
12. Transactions.
13. Query quality evaluation.