Advanced Databases 420-IS2-1ZBD-22
Course profile: General Academic
Form of study: Full-time studies
Course type: Obligatory
Year/semester of study: 1 / 1
Prerequisites (sequential system of courses and exams): Items introducing:
knowledge of concepts related to relational databases, knowledge of SQL, knowledge of database design principles,
Lecture: 15 Laboratory classes: 30
Teaching methods: Lectures, multimedia presentations, laboratory classes
ECTS credits: 4
Balance of student workload:
Class attendance:
- lecture 15h
- laboratory classes 30h
Course preparation:
- laboratory classes 15h
Literature study: 5h
Preparation for tests: 10h
Preparation for the exam: 10h
Exam duration: 2h
Individual consultation with the teacher: 13h
Student workload:
Direct interaction with the teacher: 60, 2.4 ECTS
Without direct interaction with the teacher: 40, 1.6 ECTS
Type of course
Mode
Blended learning
(in Polish) w sali
Prerequisites (description)
Course coordinators
Learning outcomes
has a structured knowledge of the main principles and elements of the SQL procedural language on the example of PL/SQL language. KP7_WG5, KP7_WG10
has a structured knowledge of subroutines on the example of PL/SQL language. KP7_WG5, KP7_WG10
has a structured knowledge of dynamic SQL and objects on the example of PL/SQL language. KP7_WG5, KP7_WG10
can write anonymous blocks and stored programs in at least one SQL procedural language. KP7_UU1, KP7_UW5
can handle exceptionsin in at least one SQL procedural language. KP7_UU1, KP7_UW5
creatively solves problems. KP7_UO4, KP7_UO2, KP7_UU2
Assessment criteria
exam, test, project
Obtaining at least 51% of the maximum total number of points.
In the case of distance learning, the assesment will be taken using the tools available on the Eduportal / USOSMail platform.
Bibliography
Primary literature:
1. Oracle Academy training materials, 2022
2. Saurabh K. Gupta, Advanced Oracle PL/SQL Developer's Guide - Second Edition, Packt Publishing, 2017 (e-book, EBSCO)
3. Benjamin Rosenzweig, Elena Silvestrova Rakhimov, Oracle PL/SQL by example, 2009.
4. Steven Feuerstein, Oracle PL/SQL best practices, 2008.
Supplementary literature:
1. Benjamin Rosenzweig, Elena Silvestrova Rakhimov, Oracle PL/SQL by example, 2009.
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: