View in EDS

SQL mokymosi sistema / ; SQL learning system.

Saved in:
Bibliographic Details
Title: SQL mokymosi sistema / ; SQL learning system.
Authors: Čebanauskas, Saulius
Contributors: Drąsutis, Sigitas
Publisher Information: Institutional Repository of Kaunas University of Technology
Publication Year: 2010
Collection: KTU ePubl (Kaunas University of Technology / Kauno Technologijos Universitetas)
Subject Terms: SQL query, SQL learning system, algorythm of SQL query executing
Description: Nowadays, when “paper” data practically from all the scopes is on the edge of extinction, big part of IT society is made of one or another type of databases. SQL queries are used to work with database information. SQL (Structured Query Language) is designed for database information processing. For fast systems, related with databases operation, it is necessary to correctly write and optimize SQL queries. To learn write SQL queries correctly and optimize them, only the theoretical knowledge is not enough, it is necessary to do a lot of practical tasks. When learning to write SQL queries, basic problem is poor choice of practical tasks, and non-existence of good testing system, which allows writing SQL queries easily. On the job the existent SQL learning systems and learning materials analysis were performed, all found systems has its own problems, full freedom to write SQL queries for user is not granted. During designing, methods allowing for learner easily write various types of queries, view executed queries results and get the result if a written query is correct, were designed. Designed methods were used in remote SQL queries learning system design and implementation. Aim: The algorithms which are developed and implemented allows to test sql queries based on simple syntax and allows to execute queries of the different types. The object of research: Execution of various SQL queries.
Document Type: master thesis
File Description: application/pdf
Language: Lithuanian
Relation: https://epubl.ktu.edu/object/elaba:1761462/1761462.pdf; https://vb.ktu.edu/KTU:ELABAETD1761462&prefLang=en_US
Availability: https://vb.ktu.edu/KTU:ELABAETD1761462&prefLang=en_US
Rights: info:eu-repo/semantics/openAccess
Accession Number: edsbas.7C03A7F9
Database: BASE
Description
Abstract:Nowadays, when “paper” data practically from all the scopes is on the edge of extinction, big part of IT society is made of one or another type of databases. SQL queries are used to work with database information. SQL (Structured Query Language) is designed for database information processing. For fast systems, related with databases operation, it is necessary to correctly write and optimize SQL queries. To learn write SQL queries correctly and optimize them, only the theoretical knowledge is not enough, it is necessary to do a lot of practical tasks. When learning to write SQL queries, basic problem is poor choice of practical tasks, and non-existence of good testing system, which allows writing SQL queries easily. On the job the existent SQL learning systems and learning materials analysis were performed, all found systems has its own problems, full freedom to write SQL queries for user is not granted. During designing, methods allowing for learner easily write various types of queries, view executed queries results and get the result if a written query is correct, were designed. Designed methods were used in remote SQL queries learning system design and implementation. Aim: The algorithms which are developed and implemented allows to test sql queries based on simple syntax and allows to execute queries of the different types. The object of research: Execution of various SQL queries.