Скачать или смотреть SQL | Join | Update & Alter Explained (ఎలా Work అవుతుంది) | (Postmortem Analysis) In telugu

In this video, we dive deep into Update & Delete keywords in SQL with a clear and practical explanation. You’ll learn:
✅ What a Update & Alter key is
✅ Why it’s important in relational databases
✅ How it maintains relationships between tables
✅ Real examples and postmortem analysis for better understanding

-- Online SQL Editor to Run SQL Online.
-- Use the editor to create new tables, insert data and all other SQL operations.
/* Update table_name
set column_name = 'newvalue'
Where column_name= 'value'
*/

-- I want to update customer age to 40 for customre id 4


--Update Customers set age=40 where customer_id=4 ; -- single row updation

-- I want to update customer age to 50 for customer living in USA country
-- Multiple row updates
-- Update customers set age=50 where country = 'USA'; -- Multi row updation

--Update Customers set age=60 for all customer

-- Update customers set age=60 -- All rows, Single column

-- I want to update customer age to 50 and last name is Robinson for customer living in USA country
-- Update customers set age=50, last_name='Robinson' where country = 'USA'; -- Multiple columns, multiple rows

-- Update customer age to 30 where order id is 1

-- Updat table name

-- alter table current_name TO new_table
/*
alter table Customers to customer;
alter schema current_name to new_name ;
alter database current_name to new_name

*/

-- I want to delete customer name john in customer table

-- delete from customers where first_name='John'; //multi rows
-- i want delete the table orders
/*
CREATE TABLE Customer(customer_id INT PRIMARY KEY, name VARCHAR(100), city VARCHAR(50));

CREATE TABLE Order2 (
order_id INT PRIMARY KEY,
customer_id INT,
order_date DATE,
amount DECIMAL(10,2),
FOREIGN KEY (customer_id) REFERENCES Customer(customer_id)
);

INSERT INTO Customer (customer_id, name, city)
values
(3, 'stu1', 'tpt'),
(2, 'stud2', 'mpl') ;



INSERT INTO Order2 (order_id, customer_id, order_date, amount)
VALUES
(102, 3, '2025-09-23', 2500.50),
(103, 2, '2025-09-22', 1800.00)
; */

#sql #telugu #joins #sqldeveloper #sqljobs #dataengineering #aiintelugu #aidevelopment #aijobs2025 #dataengineering