(in Polish) Bazy danych

information and communication technology

intermediate

LECTURE

I1_W04, I1_W05, I1_W06, I1_W08

LABORATORIES

I1_U02, I1_U03, I1_U04, I1_U10

structural programming

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.

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.