Create Table In SQL & Create Database

Описание: 💻 SQL Tutorial for Beginners | Create Database & Table in SQL Step-by-Step
In this video, you’ll learn how to Create a Database, Create a Table, and perform essential SQL operations like SELECT, ALTER, and DROP — all with easy explanations and examples.

📚 SQL Concepts Covered

1️⃣ DATABASE → TABLE → DATA → ROW & COLUMN
2️⃣ DATA SELECT
3️⃣ ALTER COMMAND
4️⃣ DROP COMMAND

🧩 SQL Commands Used in This Video

🗄 DATABASE CREATION

CREATE DATABASE testDB;


🗑 DATABASE DROP

DROP DATABASE testDB;


📋 CREATE TABLE

CREATE TABLE DEMONEW (
NAME VARCHAR(40),
GENDER VARCHAR(10),
AGE INT(4)
);


❌ REMOVE TABLE / DROP TABLE

DROP TABLE DEMONEW;


📌 COLUMN OPERATIONS

Add Column:

ALTER TABLE table_name ADD column_name datatype;


Change Column Datatype:

ALTER TABLE table_name ALTER COLUMN column_name datatype;


Add New Column:

ALTER TABLE DEMONEW ADD ADDRESS VARCHAR(40);


Delete Column:

ALTER TABLE table_name DROP COLUMN column_name;


Rename Column:

ALTER TABLE table_name RENAME COLUMN old_name TO new_name;


🧠 INSERT DATA

Insert particular value:

INSERT INTO DEMONEW (NAME) VALUES ('ASISH');


Insert full row:

INSERT INTO DEMONEW VALUES ('SACHIN','MALE',20);


🔍 SELECT DATA

Fetch all records:

SELECT * FROM DEMONEW;


Fetch specific column:

SELECT NAME FROM DEMONEW;

🏠 Today’s Task for You (Practice at Home)

1️⃣ Create a Database
2️⃣ Create Table Employee
3️⃣ Select Data from Employee Database
4️⃣ Share Screenshot in Comment Box 📸

📢 #Tags

#SQL #SQLTutorial #SQLForBeginners #LearnSQL #Database #CreateTable #SQLCommands #CodingForBeginners #DataScience #Programming #TechLearning #YouTubeLearning #SQLTraining #DataEngineer #SQLDeveloper #StepByStepSQL #MySQL #PostgreSQL #DatabaseManagement