460-2045/03 – Technology Database Systems II (TDS II)
| 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 | 3 | Semester | winter |
| | 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 knowledge of the subject DAIS, especially structural extension DBMS Oracle SQL - PL / SQL. For successful completion of the course must be completed with 1 sub and 1 final test and project.
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-learning course Oracle Academy Database Programmingwith PL/SQL - Student
http://academy.oracle.com
Recommended literature:
List of Presentations, Sylabus, and Tasks for solving.
Available on MS Teams.
Additional study materials
Way of continuous check of knowledge in the course of semester
On-line testing.
E-learning
Study materials on LSM Oracle.
Other requirements
Complete all tests and submit 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. Programming introduciton into PL/SQL, define attributes and data types.
2. Použití SQL v PL/SQL.
3. Programm structures for program flow.
4. Cursors.
5. Composite data types, work with exceptions.
6. Managing and using procedures and functions.
7. Managing and using procedures and functions.
8. Managing and using packages.
9. Increasing performance PL/SQL.
10. Triggers.
11. Triggers.
12. Identifiing and managing dependecies.
13. Using PL/SQL with compiler.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction