Кафедри

Зараз показуємо 1 - 2 з 2

Guidelines for laboratory works on the topic "Learning the basics of working with DBMS MySQL: Fundamental DDL and DML tools of SQL language"
(2021) Orlovskyi, D. L.; Kopp, A. M.
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.
Guidelines for laboratory works on the topic "Learning the basics of working with DBMS Microsoft Access: Database creation and fundamentals of work with DML tools of SQL"
(2021) Orlovskyi, D. L.; Kopp, A. M.
Experience in using computers in the building of applied data processing systems shows that universal programming languages are not the most effective tool in contrast with the specific languages of data management systems. Such tools are commonly included in the Database Management Systems (DBMS) but also might be stand-alone. DBMS provides users with the ability to manage data directly, as well as rapid application development tools used by programmers to develop the data processing software. These guidelines consider problems related to database development, work with data, and the basics of programming in the Microsoft Access DBMS environment. Today Microsoft Access DBMS is extremely popular, first of all, because it is provided as part of the Microsoft Office package. As well as the text processor Word and Excel spreadsheets, Access DBMS is widely used for business workflow automation. User-friendly and simple interface, advanced help system, and various in-built tools (so-called wizards) simplify the users’ training process and make Access DBMS very attractive especially for users without enough experience in database management systems. The set of tasks includes the complete list of problems – from database development to user interface design. During the study, students will learn various tools used to automate data storage and processing tasks. There are tools used to design forms, queries, reports, etc. It is recommended to use Microsoft Access 2007 or newer. Efficient learning of the Microsoft Access DBMS features is possible only by practical implementation of the proposed tasks on the computer.

Кафедри

Переглянути

Фільтри

Налаштування

Сортувати за

Результатів на сторінку

Результати пошуку