Technology Database Systems II

Type of study	Bachelor
Language of instruction	Czech
Code	460-2045/03
Abbreviation	TDS II
Course title	Technology Database Systems II
Credits	2
Coordinating department	Department of Computer Science
Course coordinator	Ing. Radoslav Fasuga, Ph.D.

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.

E-learning

Study materials on LSM Oracle. https://academy.oracle.com
Materials are available within the MS Teams learning group.

Literature

E-learning course Oracle Academy Database Programmingwith PL/SQL - Student
http://academy.oracle.com

Advised literature

List of Presentations, Sylabus, and Tasks for solving.

Available on MS Teams.

back to search page