(in Polish) Bazy danych WM-FI-S1-E4-BDA

The purpose of the course is to provide knowledge and skills in databases and the basics of information modeling, storage and retrieval. In this class, students will be introduced to the basic methods of designing relational databases, the mechanisms used in such databases, and the basics of the SQL language, including the differences in the dialects of this query language. They will acquire skills: creating tables and relationships between them, loading data into the database, creating queries to retrieve information, and internal database programming - creating stored procedures and functions. They also become familiar with alternatives: distributed databases and NoSQL databases.

(in Polish) Dyscyplina naukowa, do której odnoszą się efekty uczenia się

information and communication technology

(in Polish) E-Learning

Term 2022/23_L:

(in Polish) E-Learning (pełny kurs) z podziałem na grupy

Term 2023/24_L:

(in Polish) E-Learning

Term 2024/25_L:

(in Polish) E-Learning

(in Polish) Grupa przedmiotów ogólnouczenianych

(in Polish) nie dotyczy

(in Polish) Opis nakładu pracy studenta w ECTS

(in Polish) WYKŁAD Szacunkowy nakład pracy studenta: - uczestnictwo w zajęciach: 30h, - uczestnictwo w egzaminie: 3h, - konsultacje z prowadzącym: 3h, - przygotowanie do zajęć: 5h, - przygotowanie do egzaminu: 35h, razem 76h, co odpowiada 3 ECTS. LABORATORIA: Szacunkowy nakład pracy studenta: - uczestnictwo w zajęciach: 30h, - uczestnictwo w 3 kolokwiach: 6h, - konsultacje z prowadzącym: 3h, - przygotowanie do zajęć: 7h, - przygotowanie do weryfikacji: 30h, razem 76h, co odpowiada 3 ECTS.

Subject level

intermediate

Learning outcome code/codes

LECTURE I1_W04, I1_W05, I1_W06, I1_W08 LABORATORIES I1_U02, I1_U03, I1_U04, I1_U10

Type of subject

obligatory

Preliminary Requirements

structural programming

Course coordinators

Term 2022/23_L:

Robert Kłopotek

Term 2024/25_L:

Tomasz Eisenbardt

Term 2023/24_L:

Robert Kłopotek

Assessment criteria

For all learning outcomes, the following assessment criteria are adopted for all forms of verification:
grade 5: fully achieved (no obvious shortcomings),
grade 4.5: achieved almost fully and criteria for awarding a higher grade are not met,grade 4: largely achieved and the criteria for a higher grade are not met,
grade 3.5: largely achieved -with a clear majority of positives -and the criteria for granting a higher grade are not met,
grade 3: achieved for most of the cases covered by the verification and criteria for a higher grade are not met,
grade 2: not achieved for most of the cases covered by the verification.

Additional information

Information on level of this course, year of study and semester when the course unit is delivered, types and amount of class hours - can be found in course structure diagrams of apropriate study programmes. This course is related to the following study programmes:

Physics - full-time first-cycle studies

Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system:

Description of WM-FI-S1-E4-BDA in USOSweb