|
Lecturer(s)
|
-
Borkovcová Monika, Ing. Ph.D.
|
|
Course content
|
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.
|
|
Learning activities and teaching methods
|
|
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming), Demonstration, Projection, Skills training
|
|
Learning outcomes
|
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.
|
|
Prerequisites
|
The course is intended for students who have experience with relational databases and SQL language.
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Creative work analysis, Didactic test, Discussion
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"
|
|
Recommended literature
|
-
Oracle Academy. Lectures and Presentations.
|