Advanced Databases 510-IS2-1ZBD-23-ENG
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
Rodzaj przedmiotu
Tryb prowadzenia przedmiotu
w sali
zdalnie
Założenia (opisowo)
Koordynatorzy przedmiotu
Efekty kształcenia
has a structured knowledge of the main elements and principles of the SQL extension language on the example of PL/SQL language. KP7_WG5, KP7_WG10
has a structured knowledge of stored SQL programs 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 PL/SQL (or another extension of SQL). KP7_UW5
can handle exceptionsin in PL/SQL (or another extension of SQL). KP7_UW5
creatively solves problems. KP7_UO4, KP7_UO2
Kryteria oceniania
exam, test, project
Obtaining at least 51% of the maximum number of points from each activity.
An unexcused absence from more than 20% of laboratory classes constitutes grounds for failing the course.
In the case of distance learning, the assesment will be taken using the tools available on the Eduportal / USOSMail platform.
Literatura
Primary literature:
1. Oracle Academy training materials, 2025
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.
Więcej informacji
Dodatkowe informacje (np. o kalendarzu rejestracji, prowadzących zajęcia, lokalizacji i terminach zajęć) mogą być dostępne w serwisie USOSweb: