Schema and Table Setup
In a SQL database, a schema is a list of logical structures of data, such as tables. Tables are the basic database objects that behave as containers for the data, in which the data will be logically organized in rows and columns format.
To put it simply, a schema is similar to a folder on your computer, while a table is a file inside it. In order to store and manage data with SQL, you will need schemas and tables.
In this section, you will start by creating your first schema and table.
Prerequisites
Before attempting this section, make sure you have your MySQL and MySQL Workbench installed correctly.
If you haven’t done so, consult our MySQL Workbench Setup Guide.
Outcome
After finishing this section, you will be able to:
- Understand basic syntax of the SQL language,
- Understand basic data types of the SQL language,
- Write SQL queries to create a new schema, and
- Write SQL queries to create a new table.