| Course Unit Code | 460-2045/01 |
|---|
| Number of ECTS Credits Allocated | 2 ECTS credits |
|---|
| Type of Course Unit * | Optional |
|---|
| Level of Course Unit * | First Cycle |
|---|
| Year of Study * | Third Year |
|---|
| Semester when the Course Unit is delivered | Winter Semester |
|---|
| Mode of Delivery | Face-to-face |
|---|
| Language of Instruction | Czech |
|---|
| Prerequisites and Co-Requisites | Course succeeds to compulsory courses of previous semester |
|---|
| Name of Lecturer(s) | Personal ID | Name |
|---|
| FAS01 | Ing. Radoslav Fasuga, Ph.D. |
| Summary |
|---|
| Course target is to increase knowledge of database courses with English terminology and their practical use in range of Oracle company products. |
| Learning Outcomes of the Course Unit |
|---|
| The aim of the course is to increse knowledge of the subject DAIS, especially structural extension DBMS Oracle SQL - PL / SQL. For successful completion of the course must be completed with 1 sub and 1 final test and project. |
| Course Contents |
|---|
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.
|
| Recommended or Required Reading |
|---|
| Required Reading: |
|---|
E-learning course Oracle Academy Database Programmingwith PL/SQL - Student
http://academy.oracle.com
|
E-learningový kurz Oracle Academy Database Programmingwith PL/SQL - Student
http://academy.oracle.com
|
| Recommended Reading: |
|---|
List of Presentations, Sylabus, and Tasks for solving.
Available on MS Teams. |
Soubor prezentací, sylabů a úkolů k vypracování.
Dostupných na MS Teams. |
| Planned learning activities and teaching methods |
|---|
| Lectures, Project work |
| Assesment methods and criteria |
|---|
| Task Title | Task Type | Maximum Number of Points
(Act. for Subtasks) | Minimum Number of Points for Task Passing |
|---|
| Graded exercises evaluation | Graded credit | 100 (100) | 51 |
| PL/SQL Semestr 1 Mid Term Exam 1/2 | Written test | 5 | 5 |
| PL/SQL Semestr 1 Mid Term Exam 2/2 | Written test | 5 | 5 |
| PL/SQL Semestr 1 Final Exam | Written test | 10 | 10 |
| PL/SQL Semestr 2 Mid Term Exam | Written test | 10 | 10 |
| PL/SQL Semestr 2 Final Exam | Written test | 10 | 10 |
| Project | Project | 60 | 60 |