Databases 2 Field of study: Computer Science
Programme code: W4-S1IN19.2024

Module name: Databases 2
Module code: W4-IN-S1-24-6-BD2
Programme code: W4-S1IN19.2024
Semester: winter semester 2026/2027
Language of instruction: Polish
Form of verification: course work
ECTS credits: 3
Purpose and description of the content of education:
The objective of the course is to familiarize students with the principles of programming in PL-SQL and the guidelines for creating non-relational NoSQL databases. Students will acquire the knowledge and skills necessary for efficient data processing using SQL and will learn to design data structures and operate on data according to NoSQL principles.
List of modules that must be completed before starting this module (if necessary): not applicable
Learning outcome of the module Codes of the learning outcomes of the programme to which the learning outcome of the module is related [level of competence: scale 1-5]
The student understands the need to constantly enrich his knowledge and develop his skills in working with modern technologies and database management systems. [K01]
 IN_K03 [3/5] IN_K04 [3/5]
The student is aware of the needs for data analysis, processing, and storage and the role of database systems due to digital and social transformation. [K02]
 IN_K01 [2/5] IN_K02 [2/5] IN_K04 [3/5]
The student can determine the application of the appropriate type of database systems in specific domains. [K03]
 IN_K01 [3/5] IN_K03 [3/5] IN_K04 [3/5]
The student can create, modify and manage databases using the query language appropriate for a given database. [U01]
 IN_U04 [3/5] IN_U05 [2/5]
The student can design and implement a data model for a given problem. He/she can also identify alternative solutions and their properties. [U02]
 IN_U01 [2/5] IN_U02 [2/5] IN_U03 [2/5] IN_U04 [2/5]
The student is able to analyze the problem and determine the appropriate type and structure of the database. [U03]
 IN_U01 [2/5] IN_U03 [3/5] IN_U04 [3/5]
The student knows and understands different types of databases, basic concepts in the area of databases, and relationships among data. [W01]
 IN_W01 [2/5] IN_W02 [3/5] IN_W04 [2/5] IN_W05 [3/5]
The student knows the principles of designing different types of databases according to the application's specific requirements. [W02]
 IN_W02 [3/5] IN_W03 [3/5] IN_W04 [3/5] IN_W05 [2/5]
The student knows the principles of performing CRUD operations (Create, Read, Update, Delete) in various databases and understands the discrepancies in implementing requests sent to the DBMS. [W03]
 IN_W03 [4/5] IN_W04 [3/5] IN_W05 [2/5]
Form of teaching Number of hours Methods of conducting classes Assessment of the learning outcomes Learning outcomes
laboratory classes [01] 30 Activating methods: a case study [b07] 
Activating method – peer learning [b08] 
Video show [c02] 
Demonstration-imitation [c06] 
Screen presentation [c07] 
Working with a computer [d01] 
Working with another teaching tool [d03] 
Laboratory exercise / experiment [e01] 
Project scheduling [e04] 
Practice-as-research [e08] 
Self-education [f01] 
Individual work with a text [f02] 
Conceptual work [f03]  		course work K01 K02 K03 U01 U02 U03 W01 W02 W03
The student's work, apart from participation in classes, includes in particular:
Name Category Description
Search for materials and review activities necessary for class participation [a01] Preparation for classes
reviewing literature, documentation, tools and materials as well as the specifics of the syllabus and the range of activities indicated in it as required for full participation in classes
Literature reading / analysis of source materials [a02] Preparation for classes
reading the literature indicated in the syllabus; reviewing, organizing, analyzing and selecting source materials to be used in class
Developing practical skills [a03] Preparation for classes
activities involving the repetition, refinement and consolidation of practical skills, including those developed during previous classes or new skills necessary for the implementation of subsequent elements of the curriculum (as preparation for class participation)
Production/preparation of tools, materials or documentation necessary for class participation [a05] Preparation for classes
developing, preparing and assessing the usefulness of tools and materials (e.g. aids, scenarios, research tools, equipment, etc.) to be employed in class or as an aid when preparing for classes
Getting acquainted with the syllabus content [b01] Consulting the curriculum and the organization of classes
reading through the syllabus and getting acquainted with its content
Determining the stages of task implementation contributing to the verification of learning outcomes [c01] Preparation for verification of learning outcomes
devising a task implementation strategy embracing the division of content, the range of activities, implementation time and/or the method(s) of obtaining the necessary materials and tools, etc.
Implementation of an individual or group assignment necessary for course/phase/examination completion [c03] Preparation for verification of learning outcomes
a set of activities aimed at performing an assigned task, to be executed out of class, as an obligatory phase/element of the verification of the learning outcomes assigned to the course
Publication of a work/presentation of an activity, also beyond the walls of the University [e02] Activities complementary to the classes
a set of activities carried out to disseminate (out of class) the effects of scholarly research, artistic, creative, project, construction, experimental work, etc., in the form of a classic presentation, exhibition, concert, projection, poster presentation, media mediated publication, in the digital form and as part of other activities; dissemination using various forms and tools
Attachments
Module description (PDF)
Information concerning module syllabuses might be changed during studies.
Syllabuses (USOSweb)
Semester Module Language of instruction
(no information given)