Features of studying the language of SQL queries in the profile course of informatics of institutions of general secondary education
Keywords:
study methodology, relational databases, SQL query language, database integrity, inter-table relationships
Abstract
The material of the article contains explanations and methodological recommendations for the study of the topic "SQL query language" in the profile course of informatics of institutions of general secondary education. The paper describes in detail the concept of data integrity in a relational database, analyzes the risks of data integrity breach when adding, updating, and deleting records in a multi-table database, and the principles for constructing and performing SQL queries for fetching data.
References
Informatyka. Profilnyy riven. Navchalni programi dlya 10-11 klasiv [Elektronnyy resurs]. URL: https://mon.gov.ua/ua/osvita/zagalna-serednya-osvita/navchalni-programi/navchalni-programi-dlya-10-11-klasiv (in Ukrainian)
Informatyka. Riven standartu. Navchalni programi dlya 10-11 klasiv [Elektronnyy resurs]. URL: https://mon.gov.ua/ua/osvita/zagalna-serednya-osvita/navchalni-programi/navchalni-programi-dlya-10-11-klasiv (in Ukrainian)
Zavadsky I.O. Fundamentals of the databases: textbook. К. : Publ. І.О. Zavadsky, 2011. 192 p. (in Ukrainian)
Shamshina N. Methodical Features Of Studying Relationships And Types Of Joins In Databases Microsoft Access. Physical and Mathematical Education. 2018. Issue 1(15). Р. 339¬–343. (in Ukrainian)
Dunaev V.V. Database. SQL language. St. Petersburg: BHV- Petersburg, 2006. 288 p. (in Russian)
Informatyka. Riven standartu. Navchalni programi dlya 10-11 klasiv [Elektronnyy resurs]. URL: https://mon.gov.ua/ua/osvita/zagalna-serednya-osvita/navchalni-programi/navchalni-programi-dlya-10-11-klasiv (in Ukrainian)
Zavadsky I.O. Fundamentals of the databases: textbook. К. : Publ. І.О. Zavadsky, 2011. 192 p. (in Ukrainian)
Shamshina N. Methodical Features Of Studying Relationships And Types Of Joins In Databases Microsoft Access. Physical and Mathematical Education. 2018. Issue 1(15). Р. 339¬–343. (in Ukrainian)
Dunaev V.V. Database. SQL language. St. Petersburg: BHV- Petersburg, 2006. 288 p. (in Russian)
Abstract views: 0 PDF Downloads: 0
Published
2020-05-17
How to Cite
Bulatetska, L., & Bulatetsky, V. (2020). Features of studying the language of SQL queries in the profile course of informatics of institutions of general secondary education. COMPUTER-INTEGRATED TECHNOLOGIES: EDUCATION, SCIENCE, PRODUCTION, (39), 5-10. https://doi.org/10.36910/6775-2524-0560-2020-39-01
Section
Automation and Control
