Databases 420-IS1-2BD
Course profile: General Academic
Form of study: Full-time studies
Course type: Obligatory
Year/semester of study: 2 / 3
Prerequisites (sequential system of courses and exams): Items introducing: Linear Algebra with Analytic Geometry, Introduction to Object-Oriented Programming,
Lecture: 30 Laboratory classes: 30
Teaching methods: Lectures, laboratory classes
ECTS credits: 5
Balance of student workload:
Class attendance:
- lecture 30h
- laboratory classes 30h
Course preparation:
- laboratory classes 15h
Literature study: 5h
Preparation for tests: 10h
Preparation for the exam: 10h
Exam duration: 2h
Projects carried out at home: 10h
Individual consultation with the teacher: 13h
Student workload:
Direct interaction with the teacher: 75, 3 ECTS
Without direct interaction with the teacher: 50, 2 ECTS
Type of course
Mode
(in Polish) w sali
(in Polish) zdalnie
Prerequisites
Prerequisites (description)
Course coordinators
Learning outcomes
knows the principles of operation of relational database systems, including indexes, transactions and query optimization. KA6_WG5
knows issues related to the design, analysis, creation and modification of databases and their objects. KA6_WG5
knows the issues related to the search, presentation and modification of information from databases. KA6_WG5
can design and create a database. KA6_UW11
can search for and present the required information from databases. KA6_UW11
can modify the structure and content of databases. KA6_UW11
Assessment criteria
Assessment: exam, test, project
Obtaining at least 51% of the maximum total number of points.
In the case of distance learning, the assesments will be taken using the tools available on the Eduportal / USOSMail platform.
Bibliography
Primary literature:
Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 2006
Joel Murach, Murach’s Oracle SQL & PL/SQL: works with all versions through 11g, 2008
Gupta S. B., Mittal A., Introduction to Database Management System, University Science Press, 2017 (e-book, Ebsco)
Oracle Academy training materials, 2022
Supplementary literature:
Kriegel A., Discovering SQL : A Hands-On Guide for Beginners, 2011 (e-book, Ebsco)
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: