INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

SQL Full Course Playlist ?
https://www.youtube.com/playlist?list=PLdOKnrf8EcP17p05q13WXbHO5Z_JfXNpw

Timestamps:
00:00 Topics
00:04 Insert Into Concept
00:28 Insert Into Example
01:38 Update Table Concept
02:12 Update Table Example
02:55 Delete Values Concept
03:11 Delete Values Example
03:41 Alter Table Concept
04:37 Drop & Truncate Table Concept
05:01 Drop & Truncate Table Example

Like, Share, Subscribe :)

➖➖➖➖➖➖➖➖➖➖➖➖➖
Queries used:

? Customer Table
? Create table

CREATE TABLE customer
(
CustID int PRIMARY KEY,
CustName varchar(50) NOT NULL,
Age int NOT NULL,
City char(50),
Salary numeric );

? Insert values in table

INSERT INTO customer (CustID, CustName, Age, City, Salary)
VALUES
(1, 'sam', 26, 'Delhi', 9008),
(2, 'Ram', 19, 'Bangalore', 11000),
(3, 'Pam', 31, 'Mumbai', 6060),
(4, 'Sam', 42, 'Pune', 10000);

? Update values in table

UPDATE customer
SET CustName = 'Xam' , Age = 32
WHERE CustID = 4


? Classroom Table

CREATE TABLE classroom (
rollno int8 PRIMARY KEY,
name varchar(50) NOT NULL,
house char(12) NOT NULL,
grade char(1) );

INSERT INTO classroom (rollno, name, house, grade)
VALUES
(1, 'Sam', 'Akash', 'B'),
(2, 'Ram', 'Agni', 'A'),
(3, 'Shyam', 'Jal', 'B'),
(4, 'Sundar', 'Agni', 'A'),
(5, 'Ram', 'Yayu', 'B');
➖➖➖➖➖➖➖➖➖➖➖➖➖

Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi - 1
https://www.youtube.com/watch?v=yH1zCq-iaeU

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi - 2
https://www.youtube.com/watch?v=HmH-76_2Ak8

Create Table In SQL & Create Database | SQL Tutorial In Hindi - 3
https://www.youtube.com/watch?v=v-2cIUgx_jw

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

Instagram: https://www.instagram.com/rishabhnmishra/
LinkedIn: https://www.linkedin.com/in/rishabhnmishra/
Twitter: https://twitter.com/rishabhnmishra

➖➖➖➖➖➖➖➖➖➖➖➖➖

If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!