Creating the Database
The first thing that we need to learn is to create a database.
A database is a collection of related tables, queries and views etc.
You can think of it as being similar to an Excel workbook. An Excel workbook contains related worksheets and charts while a database contains related tables, queries and other objects (such as views and stored routines).
To create a database in MySQL, we use the CREATE DATABASE keywords. A keyword is a word that has a predefined meaning in SQL. In other words, if you want to create a database, you have to type CREATE DATABASE, you cannot be creative and type other words like MAKE DATABASE or CREATE COLLECTION etc.
Keywords are generally not case sensitive in SQL. Hence, you can also write create database or CREATE database. However, the common practice is to use uppercase for keywords. That’s the convention that we’ll be following in this book. For all the syntaxes presented...