Advanced Databases

General data

Course ID:	420-IS2-1ZBD-22
Erasmus code / ISCED:	11.304 The subject classification code consists of three to five digits, where the first three represent the classification of the discipline according to the Discipline code list applicable to the Socrates/Erasmus program, the fourth (usually 0) - possible further specification of discipline information, the fifth - the degree of subject determined based on the year of study for which the subject is intended. / (0612) Database and network design and administration The ISCED (International Standard Classification of Education) code has been designed by UNESCO.
Course title:	Advanced Databases
Name in Polish:	Zaawansowane bazy danych
Organizational unit:	Institute of Computer Science
Course groups:	(in Polish) 1 rok 2 st. sem. zimowy Informatyka (in Polish) 2L stac. II st. studia informatyki - przedmioty obowiązkowe
ECTS credit allocation (and other scores):	(not available) Basic information on ECTS credits allocation principles: the annual hourly workload of the student’s work required to achieve the expected learning outcomes for a given stage is 1500-1800h, corresponding to 60 ECTS; the student’s weekly hourly workload is 45 h; 1 ECTS point corresponds to 25-30 hours of student work needed to achieve the assumed learning outcomes; weekly student workload necessary to achieve the assumed learning outcomes allows to obtain 1.5 ECTS; work required to pass the course, which has been assigned 3 ECTS, constitutes 10% of the semester student load. view allocation of credits
Language:	Polish
Type of course:	obligatory courses
Prerequisites (description):	knowledge of concepts related to relational databases, knowledge of SQL, knowledge of database design principles
Mode:	(in Polish) w sali (in Polish) zdalnie Blended learning
Short description:	Introduction to PL/SQL. Language rules. Data types. Blocks. Variables and their scope. Conditional statements. Loops. SQL in PL/SQL. Records. Cursors. Collections. Exceptions. Create and use procedures, functions and packages. Triggers. Dynamic SQL: NDS and DBMS_SQL. Introduction to objects in PL/SQL.
Full description:	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
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.
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 methods and 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.

This course is not currently offered.

Course descriptions are protected by copyright.
Copyright by University of Bialystok.