|
Lecturer(s)
|
-
Dokoupil Tomáš, Ing.
-
Majerík Filip, Ing. Ph.D.
-
Borkovcová Monika, Ing. Ph.D.
|
|
Course content
|
1. Data Dictionary. 2. Data security and protection - user accounts, system and object permissions, roles, profiles. 3. Transactions, return points, automatic locking, consistent reads. 4. Database access from a higher programming language. 5. Security and SQL injection. 6. PL/SQL language - variables, constants, parameters, block syntax, operators. 7. Program flow control - conditions, loops, cursors, records, error handling. 8. Procedures and functions. 9. DBMS_OUTPUT and DBMS_RANDOM packages and system units. 10. DML triggers and their use. 11. Advanced SQL query constructs. 12. Hierarchical queries 13. Exporting and importing data.
|
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Projection, Skills training
- Contact teaching
- 52 hours per semester
- Term paper
- 56 hours per semester
- Home preparation for classes
- 13 hours per semester
- Preparation for an exam
- 30 hours per semester
|
|
Learning outcomes
|
The aim of the subject is to learn the base of PL/SQL language and to extend knowledge of SQL language in practical use.
Master the basic work with PL/SQL language - e.g. creating of functions, procedures and triggers in Oracle database system. The ability to design and to implement complex database structure with application of basic security rules.
|
|
Prerequisites
|
The precondition of this course is to pass lessons of Database systems 1 and student's ability to write a simple program in any of the programming languages.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Creative work analysis, Didactic test, Discussion
To obtain the credit, students must successful defense and proper completion of the credit project (min. 70%). The exam is written and tests the student's practical and theoretical knowledge and understanding of the material covered (min. 70%). For successful completion of the course, student participation and preparation for exercises is recommended.
|
|
Recommended literature
|
-
Alex Nordeen. Learn PL/SQL in 24 Hours. 2020.
-
Benjamin Rosenzweig, Elena Rakhimov. Oracle PL/SQL by Example. 2023. ISBN 9780138062835.
-
Madhavi Vaidya. RDBMS In-Depth. Indie, 2021. ISBN 9788194837701.
|