filmov
tv
D3 Master Basic SQL SELECT Statement + Create Tables Using ChatGPT AI | SQL for Beginners

Показать описание
Are you new to SQL or want to understand how the SELECT statement works? 🤔
In this video, we break down the basics of SQL SELECT statements and show you how to retrieve data like a pro.
💡 Plus, learn how to create SQL tables using ChatGPT AI – an easy and smart way to accelerate your learning!
✅ What you'll learn:
How the SQL SELECT statement works
Syntax and real-time examples
How to create tables using ChatGPT
Tips to boost your SQL learning with AI assistance
🎓 Perfect for beginners and aspiring database developers.
Practice Using the table mentioned below.
"CREATE TABLE Employee (
ID INT PRIMARY KEY IDENTITY(1,1),
Name NVARCHAR(100) NOT NULL,
DateOfBirth DATE NOT NULL,
Gender NVARCHAR(10) CHECK (Gender IN ('Male', 'Female', 'Other')),
Address NVARCHAR(255),
City NVARCHAR(50),
State NVARCHAR(50),
Salary MONEY
);
INSERT INTO Employee (Name, DateOfBirth, Gender, Address, City, State, Salary) VALUES
('Rajesh Kumar', '1985-04-10', 'Male', '12 MG Road', 'Delhi', 'Delhi', 55000),
('Priya Sharma', '1990-07-22', 'Female', '101 Sector 21', 'Mumbai', 'Maharashtra', 60000),
('Amit Patel', '1982-12-11', 'Male', '56 Ring Road', 'Ahmedabad', 'Gujarat', 52000),
('Sneha Reddy', '1995-09-30', 'Female', '789 Jubilee Hills', 'Hyderabad', 'Telangana', 58000),
('Karthik Iyer', '1988-03-15', 'Male', '22 T Nagar', 'Chennai', 'Tamil Nadu', 61000),
('Neha Joshi', '1993-06-25', 'Female', '77 JM Road', 'Pune', 'Maharashtra', 57000),
('Vikram Desai', '1987-11-05', 'Male', '99 Gariahat', 'Kolkata', 'West Bengal', 63000),
('Anjali Nair', '1991-08-12', 'Female', '14 HSR Layout', 'Bengaluru', 'Karnataka', 62000),
('Rohan Mehta', '1989-02-28', 'Male', '28 Sector 18', 'Noida', 'Uttar Pradesh', 59000),
('Divya Singh', '1994-01-09', 'Female', '65 MI Road', 'Jaipur', 'Rajasthan', 56000),
('Siddharth Jain', '1986-05-19', 'Male', '33 Anna Nagar', 'Chennai', 'Tamil Nadu', 64000),
('Meera Das', '1992-10-07', 'Female', '23 Ballygunge', 'Kolkata', 'West Bengal', 61000),
('Arjun Reddy', '1983-12-24', 'Male', '78 Banjara Hills', 'Hyderabad', 'Telangana', 65000),
('Isha Kapoor', '1996-04-16', 'Female', '110 Bandra West', 'Mumbai', 'Maharashtra', 59000),
('Naveen Chandra', '1984-09-01', 'Male', '45 Koramangala', 'Bengaluru', 'Karnataka', 67000),
('Pooja Verma', '1990-03-20', 'Female', '87 Viman Nagar', 'Pune', 'Maharashtra', 60000),
('Rahul Yadav', '1987-07-11', 'Male', '11 Civil Lines', 'Delhi', 'Delhi', 56000),
('Anusha Rao', '1991-11-03', 'Female', '36 Sector 62', 'Noida', 'Uttar Pradesh', 58000),
('Harish Shah', '1985-06-08', 'Male', '20 C G Road', 'Ahmedabad', 'Gujarat', 61000),
('Simran Kaur', '1993-02-14', 'Female', '88 Malviya Nagar', 'Jaipur', 'Rajasthan', 57000);
select * from Employee;"
👉 Don’t forget to like, share, and subscribe for more SQL and tech tutorials!
#SQL #ChatGPT #DatabaseTutorial #TechLearning #SQLForBeginners
In this video, we break down the basics of SQL SELECT statements and show you how to retrieve data like a pro.
💡 Plus, learn how to create SQL tables using ChatGPT AI – an easy and smart way to accelerate your learning!
✅ What you'll learn:
How the SQL SELECT statement works
Syntax and real-time examples
How to create tables using ChatGPT
Tips to boost your SQL learning with AI assistance
🎓 Perfect for beginners and aspiring database developers.
Practice Using the table mentioned below.
"CREATE TABLE Employee (
ID INT PRIMARY KEY IDENTITY(1,1),
Name NVARCHAR(100) NOT NULL,
DateOfBirth DATE NOT NULL,
Gender NVARCHAR(10) CHECK (Gender IN ('Male', 'Female', 'Other')),
Address NVARCHAR(255),
City NVARCHAR(50),
State NVARCHAR(50),
Salary MONEY
);
INSERT INTO Employee (Name, DateOfBirth, Gender, Address, City, State, Salary) VALUES
('Rajesh Kumar', '1985-04-10', 'Male', '12 MG Road', 'Delhi', 'Delhi', 55000),
('Priya Sharma', '1990-07-22', 'Female', '101 Sector 21', 'Mumbai', 'Maharashtra', 60000),
('Amit Patel', '1982-12-11', 'Male', '56 Ring Road', 'Ahmedabad', 'Gujarat', 52000),
('Sneha Reddy', '1995-09-30', 'Female', '789 Jubilee Hills', 'Hyderabad', 'Telangana', 58000),
('Karthik Iyer', '1988-03-15', 'Male', '22 T Nagar', 'Chennai', 'Tamil Nadu', 61000),
('Neha Joshi', '1993-06-25', 'Female', '77 JM Road', 'Pune', 'Maharashtra', 57000),
('Vikram Desai', '1987-11-05', 'Male', '99 Gariahat', 'Kolkata', 'West Bengal', 63000),
('Anjali Nair', '1991-08-12', 'Female', '14 HSR Layout', 'Bengaluru', 'Karnataka', 62000),
('Rohan Mehta', '1989-02-28', 'Male', '28 Sector 18', 'Noida', 'Uttar Pradesh', 59000),
('Divya Singh', '1994-01-09', 'Female', '65 MI Road', 'Jaipur', 'Rajasthan', 56000),
('Siddharth Jain', '1986-05-19', 'Male', '33 Anna Nagar', 'Chennai', 'Tamil Nadu', 64000),
('Meera Das', '1992-10-07', 'Female', '23 Ballygunge', 'Kolkata', 'West Bengal', 61000),
('Arjun Reddy', '1983-12-24', 'Male', '78 Banjara Hills', 'Hyderabad', 'Telangana', 65000),
('Isha Kapoor', '1996-04-16', 'Female', '110 Bandra West', 'Mumbai', 'Maharashtra', 59000),
('Naveen Chandra', '1984-09-01', 'Male', '45 Koramangala', 'Bengaluru', 'Karnataka', 67000),
('Pooja Verma', '1990-03-20', 'Female', '87 Viman Nagar', 'Pune', 'Maharashtra', 60000),
('Rahul Yadav', '1987-07-11', 'Male', '11 Civil Lines', 'Delhi', 'Delhi', 56000),
('Anusha Rao', '1991-11-03', 'Female', '36 Sector 62', 'Noida', 'Uttar Pradesh', 58000),
('Harish Shah', '1985-06-08', 'Male', '20 C G Road', 'Ahmedabad', 'Gujarat', 61000),
('Simran Kaur', '1993-02-14', 'Female', '88 Malviya Nagar', 'Jaipur', 'Rajasthan', 57000);
select * from Employee;"
👉 Don’t forget to like, share, and subscribe for more SQL and tech tutorials!
#SQL #ChatGPT #DatabaseTutorial #TechLearning #SQLForBeginners