Database systems 2100-CB-M-D2SYBD
1. Introduction to databases - properties and functions of databases. Data models.
2. Relational databases - elements and properties of a relational model.
3. Basics of relational database design - creating tables, relations, schema modification.
4. Normal forms of databases.
5. SQL language basics - SQL syntax, data definition, data types.
6. Searching for data - SELECT.
7. Functions and operations on data types.
8. Data grouping and aggregation functions.
9. Subqueries and nested statements.
10. Construction of compound queries - combining statements.
11. Data manipulation based on INSERT, UPDATE, DELETE statements.
Mode
Prerequisites (description)
Course coordinators
Type of course
Learning outcomes
KNOWLEDGE, the student knows and understands:
- principles of database development (K_W06),
- relational model of databases (K_W06),
- purpose and basic statements of SQL language (K_W06).
SKILLS, the student is able to:
- independently search and study database documentation and apply the elements of SQL language syntax contained in the documentation (K_U03),
- write and execute SQL language instructions (K_U03),
- use the relational model and search for information contained in tables (K_U03).
SOCIAL COMPETENCES, the student is ready to:
- disseminate the importance of knowledge concerning the functionality of database systems in reference to IT security problems (K_K01).
Assessment criteria
test - practical SQL
No possibility to improve positive grades. Attendance compulsory, two unjustified absences possible.
Practical placement
n/a
Bibliography
1. Elmasri R., Shamkant B. N., Wprowadzenie do systemów baz danych, Helion 2019.
2. Rogulski M., Bazy danych dla studentów: podstawy projektowania i języka SQL, Warszawa, WITKOM (Salma Press), 2012.
3. Itzik Ben-Gan, Microsoft SQL Server 2012. Podstawy języka T-SQL, APN Promise, 2012.
4. Harrison G., NoSQL, NewSQL i BigData. Bazy danych następnej generacji, Helion 2018.
5. MySQL 8.0 Reference Manual, https://dev.mysql.com/doc/refman/8.0/en/.
6. MS SQL Server technical documentation, https://learn.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver16.
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: