Скачать или смотреть #28 MySQL Practice Exercises With Solutions | SQL Tutorial for Beginners | SQL Full Course in Hindi

Welcome to our SQL Full Course in Hindi using MySQL. In this video, we will do MySQL Practice Exercises With Solutions in Hindi. In this comprehensive SQL Tutorial for Beginners, we will cover all the basics of MySQL, including database management, SQL programming, and RDBMS concepts.

MySQL Practice Exercises With Solutions Chapters
00:00 Exercise 1
03:45 Exercise 2
10:48 Exercise 3
15:50 Exercise 4

Our goal is to help you master MySQL and become proficient in creating and managing databases. This tutorial is perfect for those who are new to MySQL and want to learn it in a structured and easy-to-follow manner. In this video we have covered Group By, Like, SQL functions, Order by, AVG functions and many more.

We will cover topics such as creating databases, tables, triggers, stored procedures, indexes etc, as well as querying and manipulating data using MySQL. By the end of this MySQL tutorial in hindi, you will have a solid understanding of MySQL and be able to apply your knowledge in real-world scenarios. So, let's get started and learn MySQL in Hindi!

This is Part 28 of the comprehensive MySQL course designed for students and freshers.
MySQL Full Course :    • SQL Tutorial for Beginners | SQL Full Cour...  

🎯 *What's Next?*
Subscribe for more step-by-step coding tutorials in Hindi!
Hit the bell icon 🔔 to never miss an update.

Follow Me Here : https://www.instagram.com/shet_mahesh...

🙏 Thanks for watching!

-- Dataset
CREATE TABLE product (
product_id INT PRIMARY KEY,
product_name VARCHAR(100),
category VARCHAR(50),
price DECIMAL(10, 2)
);

INSERT INTO product (product_id, product_name, category, price) VALUES
(1, 'Laptop', 'Electronics', 55000.00),
(2, 'Smartphone', 'Electronics', 20000.00),
(3, 'Table', 'Furniture', 4000.00),
(4, 'Chair', 'Furniture', 1500.00),
(5, 'Pen', 'Stationery', 10.00),
(6, 'Notebook', 'Stationery', 40.00),
(7, 'Washing Machine', 'Home Appliance', 18000.00),
(8, 'Mixer Grinder', 'Home Appliance', 3500.00),
(9, 'Shoes', 'Fashion', 2200.00),
(10, 'T-Shirt', 'Fashion', 800.00);

**********************************************
CREATE TABLE orders (
order_id INT PRIMARY KEY,
customer_name VARCHAR(100),
order_date DATE,
order_amount DECIMAL(10, 2),
product_id INT,
quantity INT,
FOREIGN KEY (product_id) REFERENCES product(product_id)
);

INSERT INTO orders (order_id, customer_name, order_date, order_amount, product_id, quantity) VALUES
(101, 'Rahul Sharma', '2025-07-10', 110000.00, 1, 2),
(102, 'Anjali Mehta', '2025-07-11', 20000.00, 2, 1),
(103, 'Vikas Rao', '2025-07-12', 8000.00, 3, 2),
(104, 'Sneha Patil', '2025-07-12', 1500.00, 4, 1),
(105, 'Ravi Verma', '2025-07-13', 100.00, 5, 10),
(106, 'Neha Singh', '2025-07-13', 400.00, 6, 10),
(107, 'Amit Joshi', '2025-07-14', 18000.00, 7, 1),
(108, 'Priya Desai', '2025-07-15', 7000.00, 8, 2),
(109, 'Karan Kapoor', '2025-07-15', 4400.00, 9, 2),
(110, 'Divya Menon', '2025-07-16', 1600.00, 10, 2);

**********************************************
CREATE TABLE employees (
employee_id INT PRIMARY KEY,
first_name VARCHAR(50),
las_name VARCHAR(50),
date_of_birth DATE,
salary DECIMAL(10, 2)
);

INSERT INTO employees (employee_id, first_name, las_name, date_of_birth, salary) VALUES
(1, 'Arjun', 'Mehra', '1990-01-15', 50000.00),
(2, 'Riya', 'Khan', '1992-03-22', 55000.00),
(3, 'Kunal', 'Patel', '1988-07-09', 60000.00),
(4, 'Sneha', 'Reddy', '1995-11-30', 48000.00),
(5, 'Vikram', 'Shah', '1991-04-05', 52000.00),
(6, 'Pooja', 'Joshi', '1993-12-18', 51000.00),
(7, 'Nikhil', 'Bhatia', '1987-05-25', 62000.00),
(8, 'Anita', 'Iyer', '1990-09-14', 53000.00),
(9, 'Rohit', 'Nair', '1994-06-10', 47000.00),
(10, 'Meera', 'Gupta', '1996-08-27', 49000.00);


#MySQL #DatabaseTutorial #MySQLBeginners