460-2044/03 – Technology Database Systems I (TDS I)
| Gurantor department | Department of Computer Science | Credits | 2 |
| Subject guarantor | Ing. Radoslav Fasuga, Ph.D. | Subject version guarantor | Ing. Radoslav Fasuga, Ph.D. |
| Study level | undergraduate or graduate | Requirement | Optional |
| Year | 2 | Semester | summer |
| | Study language | Czech |
| Year of introduction | 2019/2020 | Year of cancellation | |
| Intended for the faculties | FEI | Intended for study types | Bachelor |
Subject aims expressed by acquired skills and competences
The aim of the course is to increse students' knowledge for the course UDBS in conceptual modeling, database design and query language SQL. The course is focused on the Oracle DBMS. For successful completion of the course students must to complete two partial and two final tests and submit semestral project on a selected topic which incluzdes a conceptual model, relationship, the SQL commands for creating and working with this model over the full course.
Teaching methods
Lectures
Project work
Summary
Course target is to increase knowledge of database courses with English terminology and their practical use in range of Oracle company products.
Compulsory literature:
E-learnig Course - OracleAcademy Database Design - Student
E-learnig Course - OracleAcademyDatabaseProgrammingwith SQL - Student
http://academy.oracle.com
Recommended literature:
List of Presentations, Sylabus, and Tasks for solving.
Available on:
http://dbedu.cs.vsb.cz/SubPages/Courses/Course.aspx?course=academy
Way of continuous check of knowledge in the course of semester
On-line testing.
E-learning
Study in LMS Oracle.
Other requirements
Complete all tests and semestral project.
Complete all tests for 60% minimal score, and success defense of semester project.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
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.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction