Lecturer(s)
|
-
Prokýšek Miloš, PhDr. Ph.D.
|
Course content
|
Content of lectures: PL/SQL programming concepts PL/ SQL block structure Variables Procedures Functions Packages Cursors Exceptions and exception handling Content of practicals: Practicals covers similar topic areas as lectures.
|
Learning activities and teaching methods
|
Blended learning
- Class attendance
- 28 hours per semester
- Preparation for classes
- 28 hours per semester
- Preparation for exam
- 10 hours per semester
|
Learning outcomes
|
This course covers PL/SQL, a procedural language extension to SQL.Students will learn procedural logic constructs such as variables, constraints, conditional statements and iterative controls.
Student is able to pass official Oracle Academy course and exam ""Database programming with PL/SQL"
|
Prerequisites
|
Knowledge of English at least at CEFR level B1.
|
Assessment methods and criteria
|
Test
Successful passing of Oracle Academy Final Test "Database programming with PL/SQL"
|
Recommended literature
|
-
Literatura dostupná v Oracle Academy / Oracle Academy official literature.
|