Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4
Play lesson

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

5.0 (0)
13 learners

What you'll learn

This course includes

  • 4 hours of video
  • Certificate of completion
  • Access on mobile and TV

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!

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere