Databases WM-MA-Z-BADA

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ę

mathematics

(in Polish) E-Learning

Term 2022/23_L:

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

Term 2020/21_L:

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

Term 2024/25_L:

(in Polish) E-Learning

Term 2021/22_L:

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

Term 2023/24_L:

(in Polish) E-Learning

Term 2019/20_L:

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

(in Polish) Grupa przedmiotów ogólnouczenianych

(in Polish) nie dotyczy

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

(in Polish) Szacunkowy nakład pracy studenta: - uczestnictwo w zajęciach: 40h, - przygotowanie do zajęć: 20h, - przygotowanie projektu semestralnego: 20h - przygotowanie do egzaminu: 30h, razem 110h

Subject level

elementary

Learning outcome code/codes

LECTURE MA1_W08, MA1_W09 LABORATORIES MA1_W08, MA1_W09, , MA1_U28, MA1_U35, MA1_U37, MA1_K01, MA1_K07

Type of subject

obligatory

Preliminary Requirements

structural programming course graduated

Course coordinators

Tomasz Eisenbardt

Bibliography

B. Johnston, J. Shan, M. Goldwasser U. Malik: SQL dla analityków danych. Opanuj możliwości SQL-a, aby wydobywać informacje z danych, Helion Gliwice 2023.
L. Ullman: MySQL. Szybki start. Wydanie II, Helion Gliwice 2007
V. M. Grippa, S. Kuzmichev: MySQL. Jak zaprojektować i wdrożyć wydajną bazę danych. Wydanie II, Helion Gliwice 2022

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:

Mathematics - part-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-MA-Z-BADA in USOSweb