Summary
Keywords
Full Transcript
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!
