| Course Unit Code | 460-2044/03 |
|---|
| Number of ECTS Credits Allocated | 2 ECTS credits |
|---|
| Type of Course Unit * | Optional |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Second Year |
|---|
| Semester when the Course Unit is delivered | Summer Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FAS01 | Ing. Radoslav Fasuga, Ph.D. |
| Summary |
|---|
| Course target is to increase knowledge of database courses with English terminology and their practical use in range of Oracle company products. |
| Learning Outcomes of the Course Unit |
|---|
| 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. |
| Course Contents |
|---|
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.
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
E-learnig Course - OracleAcademy Database Design - Student
E-learnig Course - OracleAcademyDatabaseProgrammingwith SQL - Student
http://academy.oracle.com
|
E-learningový kurz OracleAcademy Database Design - Student
E-learningový kurz OracleAcademyDatabaseProgrammingwith SQL - Student
http://academy.oracle.com
|
| Recommended Reading: |
|---|
List of Presentations, Sylabus, and Tasks for solving.
Available on MS Teams. |
Soubor prezentací, sylabů a úkolů k vypracování.
Dostupných v MS Teams.
|
| Planned learning activities and teaching methods |
|---|
| Lectures, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded credit | Graded credit | 100 (100) | 51 |
| Test Midterm 1 | Written test | 10 | 6 |
| Test Final 1 | Written test | 10 | 6 |
| Test Midterm 2 | Written test | 10 | 6 |
| Test Final 2 | Written test | 10 | 6 |
| Project | Project | 60 | 27 |