Working with SQLite database in Android with the help of Room library

Introduction Room is a library recommended by Google as one of the components of the so-called. “Android Architecture Components” approach. Room is a wrapper around the SQLite database and is an abstraction layer that facilitates working with the database. The Room library takes over most of the responsibilities so that now we can create tables … Read more

SQL basic statements (queries)

Introduction SQL (Structured Query Language) is a language used to manage relational databases. This language is designed to allow the user to store, retrieve, manage or manipulate data within a database management system (DBMS). This article will talk about the commands that are an integral part of the SQL language, which is used to work … Read more

SQL Database Management Systems (DBMS)

Introduction First of all, a distinction should be made between the terms: “database”, “database management system” (so-calledDBMS “Database Management System”) and the “SQL language” itself. “Relational database” is a digital database based on the relational data model and is a set of related data that replaces some aspect of the real world. “Relational Database Management … Read more