Introduction:

Creating a database is a fundamental step in SQL, allowing you to manage and organize your data efficiently. The CREATE DATABASE statement is used to create a new database.

Syntax:

The basic syntax for creating a database is straightforward:

CREATE DATABASE database_name;

Example:

Let's create a database named EmployeeDB:

CREATE DATABASE EmployeeDB;

Checking Existing Databases:

To see the list of all databases, use the following command:

SHOW DATABASES;

Selecting a Database:

After creating a database, you need to select it to start working with it:

USE EmployeeDB;

Dropping a Database:

To delete a database, use the DROP DATABASE statement. Be cautious, as this will remove all data within the database:

DROP DATABASE EmployeeDB;

Conclusion:

Creating, selecting, and managing databases are essential skills in SQL. Understanding these commands helps in organizing and maintaining data effectively.