FORMING THE CONTENTS OF THE COURSE "DATABASES AND INFORMATION SYSTEMS" FOR FUTURE INFORMATIC TEACHERS

Abstract

The article is devoted to the problems of content formation and software selection for the implementation of the course "Databases and Information Systems" as a necessary component of professional training of bachelors in the specialty 014 Secondary Education (Informatics). The current needs of the country in qualified IT specialists require the formation of computer science teachers' ability to work with popular programming environments and information and communication technologies. In particular, mastering the knowledge of such an important section of ICT as databases will allow pupils to implement the tasks of automating data processing and prepare them for future professional activities. Training of bachelors in the specialty 014 Secondary Education (Informatics) at the Volodymyr Vynnychenko Central Ukrainian State Pedagogical University is carried out on the basis of an educational and professional program, a mandatory component of which includes the discipline "Databases and Information Systems" as a necessary component of training in informatics. The discipline consists of the following thematic sections. Section 1. Basic concepts and architecture of databases and database management systems. Database design. Section 2. Creating and managing a relational database. Section 3. Use of CASE-tools and work in the database management systems terminal. Procedural SQL. Section 4. Database administration. Modern directions of database development. Theoretical and practical provisions of the course from sections 1 and 2, related to the issues of architecture, design and creation of databases, it is proposed to consider the example of Microsoft Office Access. Topics from sections 3 and 4 are offered to be considered on examples of "non-educational" database management systems. Thus, the study of system aspects of SQL, user security and authorization, data protection mechanisms, data backup and recovery, and database administration, it is proposed to carry out using the CASE-tool MySQL Workbench and the client terminal of the MySQL server This program was successfully tested in 2019-2020 academic year, when teaching 3rd year students majoring in 014 Secondary Education (Mathematics), educational program: Secondary Education (Mathematics, Informatics and Economics).