Databases (SE)

Type: Normative

Department: system design

Curriculum

SemesterCreditsReporting
34.5Exam

Lectures

SemesterAmount of hoursLecturerGroup(s)
332Hera O. B.ФеП-21

Laboratory works

SemesterAmount of hoursGroupTeacher(s)
332ФеП-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

Інформаційні ресурси:

  1. http://www.znannya.org/
  2. Бази даних в проектуванні і реалізації інформаційних систем https://stud.com.ua/77194/informatika/bazi_danih_proektuvanni_realizatsiyi_in fo rmatsiynih_sistem
  3. Бази даних та інформаційні системи: https://wiki.cuspu.edu.ua/index.php
  4. SQL Server. https://www.microsoft.com/en-us/sql-server/sql-server-downloads
  5. https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver16
  6. Azure Data Studio. https://azure.microsoft.com/en-us/products/data-studio/
  7. Northwind database. https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql
  8. Pubs database. https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instpubs.sql
  9. StackOverflow2010 database. https://www.brentozar.com/archive/2021/03/download-the-current-stack-overflow-database-for-free-2021-02/
  10. https://docs.microsoft.com/sql/ssdt/download-sql-server-data-tools-ssdt
  11. https://code.visualstudio.com/
  12. https://dbfiddle.uk/

Curriculum

Download curriculum