SQL commands

Most of the popular relational database management systems, such as MySQL, MariaDB, Oracle SQL, Microsoft SQL, and so on, use a type of declarative language called SQL (Structured Query Language) to interact with the database. SQL was initially developed by IBM engineers in the 1970s, but later on, it was further enhanced by Oracle Corporation and other emerging tech companies of that era.

Today, SQL has become a standard of the American National Standards Institute (ANSI) and of the International Organization for Standardization (ISO). SQL language has since been adopted by many different database systems and has become one of the most popular database languages in the modern era.

In this section, we will learn what some of the basic SQL commands you can use to interact with your MariaDB database are, specifically for obtaining, saving, modifying, and deleting your data from/to the database. These basic commands can be used in other types of SQL-based database systems as well as under the ANSI and ISO standards. Only, some of the more advanced/customized features could be different across different systems, so make sure that you read the system manual before using these advanced features.

Alright, let's get started!