Guidelines for laboratory works on the topic "Learning the basics of working with DBMS MySQL: Fundamental DDL and DML tools of SQL language"

Abstract

MySQL Database Management System (DBMS) is a freely distributed relational database developed and maintained by Oracle. From the very beginning, MySQL was developed by the Swedish company MySQL AB, which was later acquired by Sun Microsystems, which, in turn, was later acquired by Oracle. MySQL is distributed under both the GNU General Public License (GPL) and its commercial license. Under the terms of the GPL, software that uses MySQL libraries must also be distributed under the GPL license. For cases where developers do not want to open the source code of their software, a commercial license is provided. The advantage of a commercial license is quality service support. Contrary to Oracle’s MySQL licensing policy and to ensure free DBMS status, a fork of MySQL was created and called MariaDB. This database supports high compatibility with MySQL, ensuring the exact correspondence of the programming interface, the socalled API (Application Programming Interface), and MySQL commands. MySQL is a great solution for small, medium, and sometimes even large software systems. MySQL is also part of the WAMP (Windows, Apache, MySQL, PHP/Perl/Python) and LAMP (Linux, Apache, MySQL, PHP/Perl/Python) web application development stacks. This database is included in many ready-made assemblies of servers designed for web applications, such as XAMPP (which is proposed for use in this laboratory workshop), OpenServer, Denwer, and more. Recently, however, it is because of openness support, server builders and hosting providers are increasingly incorporating MariaDB into WAMP and LAMP stacks. Typically, MySQL is used as a server accessed by local or remote clients. However, the distribution also contains a library that provides the deployment of an internal server for standalone applications. In this laboratory workshop, we get acquainted with the main features of MySQL in the role of the client-server database.