Study materials on LSM Oracle. https://academy.oracle.com
Materials are available within the MS Teams learning group.
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.
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
Literature
E-learning course Oracle Academy Database Programmingwith PL/SQL - Student
http://academy.oracle.com
http://academy.oracle.com
Advised literature
List of Presentations, Sylabus, and Tasks for solving.
Available on MS Teams.
Available on MS Teams.