Technology Database Systems II

Type of study	Bachelor
Language of instruction	Czech
Code	460-2045/05
Abbreviation	TDS II
Course title	Technology Database Systems II
Credits	4
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 packages.
8. Increasing performance PL/SQL.
9. Triggers. Identifiing and managing dependecies.
10. 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