Terminated in academic year 2020/2021
Technology Database Systems I
| Type of study | Bachelor |
|---|---|
| Language of instruction | English |
| Code | 460-2044/02 |
| Abbreviation | TDS I |
| Course title | Technology Database Systems I |
| Credits | 2 |
| Coordinating department | Department of Computer Science |
| Course coordinator | Ing. Radoslav Fasuga, Ph.D. |
Subject syllabus
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.
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.
E-learning
Study in LMS Oracle.
Literature
E-learnig Course - OracleAcademy Database Design - Student
E-learnig Course - OracleAcademyDatabaseProgrammingwith SQL - Student
http://academy.oracle.com
E-learnig Course - OracleAcademyDatabaseProgrammingwith SQL - Student
http://academy.oracle.com
Advised literature
List of Presentations, Sylabus, and Tasks for solving.
Available on MS Teams.
Available on MS Teams.