|
Vyučující
|
-
Borkovcová Monika, Ing. Ph.D.
|
|
Obsah předmětu
|
Console applications sqlplus, iSQL*Plus. SQL developer. Security - accounts, system and objects rights, roles, profiles. Transactions, savepoints, automatic locks, consistent reading. Access to database from program languages. Security and SQL injection. PL/SQL language, variables, block syntax, operators. Program flow control - conditions, cycles, cursors, records, errors. System units DBMS_OUTPUT and DBMS_RANDOM. Procedures and Functions, Packages. Triggers. Export and import, usage of text files and XML documents. Relational algebra. Dependencies. Normal Forms, Decompositions, Normalisations. All study materials are part of the e-learning course. The subject is taught only in the form of e-learning.
|
|
Studijní aktivity a metody výuky
|
|
Monologická (výklad, přednáška, instruktáž), Dialogická (diskuze, rozhovor, brainstorming), Demonstrace, Projekce, Nácvik dovedností
|
|
Výstupy z učení
|
The aim of the subject is to learn the PL/SQL language in practical use. The subject is only for ERASMUS students.
Master of the elementary work with PL/SQL language in Oracle database system.
|
|
Předpoklady
|
The course is intended for students who have experience with relational databases and SQL language.
|
|
Hodnoticí metody a kritéria
|
Písemná zkouška, Posouzení zadané práce, Rozbor díla tvůrčího charakteru, Didaktický test, Rozhovor
To obtain the assessment and examination, the student must complete the requirements: 1) Pass all tests. 2) For tests, only the result of the first attempt is counted. 3) You will then be graded on the following scale: 100-90% - Grade "A" 89-80% - Grade "B" 79-70% - Grade "C" 69-60% - Grade "D" 59-50% - Grade "E"
|
|
Doporučená literatura
|
-
Oracle Academy. Lectures and Presentations.
|