|
Lecturer(s)
|
-
Handlíř David, Ing.
-
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.
|
|
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 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.
KIT/IDAS1
|
|
Assessment methods and criteria
|
Written examination, Home assignment evaluation, Creative work analysis, Didactic test, Discussion
To obtain the credit, students must attend a required number of lessons and fulfil specified requirements (hand over the functional solutions of lesson assignments, hand over seminar work consisting of complex database design and completing tests during term). The exam consists of two parts, practice test and theoretical exam. The practice test means to realize functional solutions of given tasks in Oracle database system and the oral discussion about the designed solution.
|
|
Recommended literature
|
-
Groff, J.R., Weinberg, P.N. SQL - kompletní průvodce. Praha: Computer Press, 2005.
-
Lacko, L. Oracle, správa, programování a použití databázového systému. Praha: Computer Press, 2007.
-
Opel, A. Databáze bez předchozích znalostí. Praha: Computer Press, 2006.
-
Stephens, K.R., Plew, R.R. Naučte se SQL za 21 dní. Praha: Computer Press, 2004.
-
Urman, S., Hardman, R., McLaughlin, M. Oracle - programování v PL/SQL. Praha: Computer Press, 2008.
|