SQL for Beginner

Hello guys, today I would like to share my knowledge and theory about how to manage data using Structure Query Language (SQL). This is the example and the theory of SQL.

What Does Query Mean?

A query is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs or complex results, e.g., trend analyses from data-mining tools. (Technopedia, 2011)

SQL is different from MySQL: SQL is the query language, whereas MySQL is the software that uses that language. SQL is indeed known as the most widely used database software. However, SQL is not the only software option. AQL, Datalog, and DMX are examples of database software that you can use.

Create Database
for the first step, make sure to install SQL or turn on the MySQL app on bundle applications such as XAMPP on your computer. After that, create a database in MySQL with the following query command:
CREATE DATABASE food;

If successful you can view the database with the following command:
SHOW DATABASES;

Delete table in database
To delete the table on database, we can using this following query command:
DROP TABLE transaksi;
DROP TABLE jadwal;
DROP TABLE kursi;
DROP TABLE teater;
DROP TABLE film;
DROP TABLE operator;

but if you want to delete your database in your MySQL app, you can use this query command :
DROP DATABASE bioskop;