Create Database
Discover how to create and manage databases in SQL by using the CREATE statement. Understand the role of databases and tables, how to avoid errors with IF NOT EXISTS, and how to list or drop databases through practical command examples.
We'll cover the following...
Create Database
A database is a container that holds all your tables. A table is a container for a subset of your data. A table holds data organized in rows and columns. Consider a column to be a piece of data that is an attribute of an entity. A row is a set of columns that define attributes of an entity.
The relationships are conceptually shown below:
In this lesson, we’ll learn how to use the CREATE statement. We can use the CREATE statement to create a database.
Connect to the terminal below by clicking in the widget. Once connected, the command line ...