SQL tutorial web application

Author: oliko marghishvili
Co-authors: mariam philauri
Keywords: – SQL databases, web application, tutorial, learning databases;
Annotation:

Abstract – Nowadays, almost every single enterprise and not only enterprise application uses databases. It’s impossible for application to not need store and fetch some kind of information, maybe exception would be some one-page static web application. Therefore, it is vital for back-end developers to know how to work with databases. Mostly, applications use No-SQL databases. Unfortunately, we have lack of learning resources in Georgian language. We have decided to create some kind of web application which will allow people to learn SQL basics on the example of the most famous and widely-used databases Oracle and PostgreSQL and analyze their similarities and differences. We will have a predefined example database for visualization. Learning process will be based on problems and their solutions. Navigation on website will be user-friendly. Our developed application will be consisted of three parts: Oracle database, which will store all the information needed for application, for example problems and solutions, Java (middleware) – which will provide communication between front-end and database, and front-end, which will be responsible for client and web-services interaction.