Ukončeno v akademickém roce 2020/2021
Technology Database Systems II
| Type of study | Bachelor |
|---|---|
| Language of instruction | English |
| Code | 460-2045/02 |
| Abbreviation | TDS II |
| Course title | Technology Database Systems II |
| Credits | 2 |
| Coordinating department | Department of Computer Science |
| Course coordinator | Ing. Radoslav Fasuga, Ph.D. |
Osnova předmětu
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
Study materials on LSM Oracle.
Povinná literatura
E-learning course Oracle Academy Database Programmingwith PL/SQL - Student
http://academy.oracle.com
http://academy.oracle.com
Doporučená literatura
List of Presentations, Sylabus, and Tasks for solving.
Available on MS Teams.
Available on MS Teams.