Grade 10 Installation process of MySQL Workbench for DDL and DML Practice

 

How to Install MySQL Workbench for DDL and DML Practice

If you only want to learn and practice SQL commands such as DDL (CREATE, ALTER, DROP) and DML (INSERT, UPDATE, DELETE, SELECT), you only need MySQL Server and MySQL Workbench. XAMPP is optional.

Step 1: Download MySQL Installer

1. Visit the official MySQL website:
   https://dev.mysql.com/downloads/installer/
2. Select Windows (x86, 32-bit), MySQL Installer MSI.
3. Click Download.
4. Choose "No thanks, just start my download."

---

Step 2: Install MySQL Server and Workbench

1. Run the downloaded installer.
2. Choose Developer Default (recommended for students).
3. Click Next.
4. The installer will automatically select:
   • MySQL Server
   • MySQL Workbench
   • MySQL Shell
   • Other required components
5. Click Execute to install all components.
6. After installation, click Next.

---

Step 3: Configure MySQL Server

1. Keep the default port 3306.
2. Select Use Strong Password Encryption.
3. Create a password for the root user.
4. Remember this password.
5. Click Next and complete the configuration.

---

Step 4: Open MySQL Workbench

1. Launch MySQL Workbench from the Start Menu.
2. A default connection named Local Instance MySQL80 may already appear.
3. If not, create a new connection:
   • Connection Name: Local MySQL
   • Hostname: localhost
   • Port: 3306
   • Username: root
4. Click Test Connection.
5. Enter the root password.
6. Click OK.

---

Step 5: Start Practicing SQL

Create a Database (DDL)

CREATE DATABASE school;

Use the Database

USE school;

Create a Table (DDL)

CREATE TABLE student (
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

Insert Data (DML)

INSERT INTO student
VALUES (1, 'Ram');

View Data (DML)

SELECT * FROM student;

Update Data (DML)

UPDATE student
SET name = 'Shyam'
WHERE id = 1;

Delete Data (DML)

DELETE FROM student
WHERE id = 1;