Опис навчальної дисципліни

Contents of the discipline.

In the course “Data and knowledge bases ” the work with modern relational databases is considered. The main provisions of the SQL query language for database servers are outlined. Famous databases Microsoft Access, MySQL, PostgreSQL are considered. Theoretical information is fixed by laboratory work. The development of typical databases is considered. Methods of constructing the interface for access to databases are considered. The main attention is paid to the acquisition of knowledge and skills corresponding to the current situation in the field of data and knowledge management systems, the ability to apply the knowledge gained practically.

The object of teaching the subject

The purpose of the training course is to study the basic concepts and methods of database management systems, to master the necessary minimum knowledge for the creation of modern databases data.

Objectives of teaching the subject

In result of studying this discipline, the student should know:

• the basic notions of databases;
• forms of information representation in a formalized form;
• the SQL queries language;
• methods for developing a database structure;
• the interface of the MS Access; MySQL administration system;
• tools for building interfaces to the MySQL database;
• structure and functional entities of web content management systems (CMS).

student should be able to:

• develop database structures;
• develop databases and design interfaces in the MS Access environment;
• develop relational databases data, develop interface for the MySQL database, administer the MySQL databases;
• place in the structural-logical scheme of the specialty.

To study the discipline, knowledge is required on the following subjects:

higher mathematics, discrete mathematics, algorithm theory, algorithmization and programming, object-oriented programming.