Advanced Databases 420-IS2-1ZBD-22-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

mieszany: w sali i zdalnie
w sali
zdalnie

knowledge of concepts related to relational databases, knowledge of SQL, knowledge of database design principles

has a structured knowledge of the main principles and elements of the SQL procedural language on the example of PL/SQL . KP7_WG5, KP7_WG10

has a structured knowledge of PL/SQL subroutines. KP7_WG5, KP7_WG10

has a structured knowledge of dynamic SQL and PL/SQL objects. 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

exam, test, project
Obtaining at least 51% of the maximum total number of points.

1. Oracle Academy training materials

2. Benjamin Rosenzweig, Elena Silvestrova Rakhimov, Oracle PL/SQL by example, 2009.

3. Steven Feuerstein, Oracle PL/SQL best practices, 2008.

Dodatkowe informacje (np. o kalendarzu rejestracji, prowadzących zajęcia, lokalizacji i terminach zajęć) mogą być dostępne w serwisie USOSweb: