CREATE DATABASE Statement 🏗️

Mentor's Note: Before you can build a table, you need a house for it. The Database is that house. Creating it is the very first step in any project. 💡

---

🌟 The Scenario: The Empty Plot 🗺️

Imagine you just bought a piece of land.

• Currently, it's just "System Space".
• You need to officially mark it as "My Office" or "My Home".
• Once marked, you can start building rooms (tables) inside it.

---

💻 1. The Basic Syntax

CREATE DATABASE database_name;

Example: Creating a School Database

CREATE DATABASE school_db;

---

💻 2. Advanced Creation (With Checks)

It's good practice to check if a database already exists before trying to create it, to avoid errors.

MySQL / PostgreSQL

-- ✅ Safe Creation
CREATE DATABASE IF NOT EXISTS school_db;

SQL Server

-- ⚠️ T-SQL Logic
IF NOT EXISTS(SELECT * FROM sys.databases WHERE name = 'school_db')
BEGIN
    CREATE DATABASE school_db;
END

---

💻 3. Selecting the Database (USE)

Once created, you must "enter" the house to start working.

USE school_db;

(Note: PostgreSQL uses \c school_db in the command line tool, but USE is standard for most GUI clients).

---

💡 Best Practices for Naming

1. Lowercase: school_db (Avoids OS case-sensitivity issues).
2. Underscores: my_app_db (Easier to read than myappdb).
3. Descriptive: ecommerce_prod vs db1.

---

📈 Learning Path

• ← Back: SQL Intro
• Next: DROP DATABASE →