Databases (SE)
Type: Normative
Department: system design
Curriculum
Semester | Credits | Reporting |
3 | 4.5 | Exam |
Lectures
Semester | Amount of hours | Lecturer | Group(s) |
3 | 32 | Hera O. B. | ФеП-21 |
Laboratory works
Semester | Amount of hours | Group | Teacher(s) |
3 | 32 | ФеП-21 |
Опис навчальної дисципліни
The purpose of studying the discipline is to form a systematic basic understanding, primary knowledge, skills and abilities of students on the basics of database organization and knowledge as a scientific and applied discipline, sufficient for further education and self-education in the field of computer science, information systems for various purposes; to give an idea of the role and place of databases in automated information systems, the purpose and main characteristics of various database management systems, their functionality; to obtain a basic level of
The objectives of studying the discipline “Databases” are to study models of data structures; ways to store data at the physical level, types and methods of organizing file systems; relational data model and DBMS that implements this model, SQL query languages; capabilities of DBMS that support different models of data organization, advantages and disadvantages of these DBMS in the implementation of different data structures, by means of these DBMS; understanding of ways to classify DBMS depending on the implemented data models and ways to use them; problems and the main ways to solve them when collecting data.
Recommended Literature
Gaidarzhi V.I., Izvarin I.V. Databases in information systems. – K.; University “Ukraine”, 2018. – 418 p.
Timonin V.O. Lecture notes on the discipline “Fundamentals of database systems” for students in the field of study 6.050201 System Engineering: KhNADU, 2016. 88 p. (in electronic form).
Timonin V.O. Methodical instructions for conducting laboratory work in the discipline “Fundamentals of database systems” for students in the field of study 6.050201 Systems Engineering: KhNADU, 2016. 118 p. (in electronic form).
Materials
Інформаційні ресурси:
- http://www.znannya.org/
- Бази даних в проектуванні і реалізації інформаційних систем https://stud.com.ua/77194/informatika/bazi_danih_proektuvanni_realizatsiyi_in fo rmatsiynih_sistem
- Бази даних та інформаційні системи: https://wiki.cuspu.edu.ua/index.php
- SQL Server. https://www.microsoft.com/en-us/sql-server/sql-server-downloads
- https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
- Azure Data Studio. https://azure.microsoft.com/en-us/products/data-studio/
- Northwind database. https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql
- Pubs database. https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instpubs.sql
- StackOverflow2010 database. https://www.brentozar.com/archive/2021/03/download-the-current-stack-overflow-database-for-free-2021-02/
- https://docs.microsoft.com/sql/ssdt/download-sql-server-data-tools-ssdt
- https://code.visualstudio.com/
- https://dbfiddle.uk/