SQL Queries for Database – Beginner to Advanced Guide (With Examples)

 Learn SQL & Database Management with Real Queries | IT Planet Haldwani

Understanding SQL (Structured Query Language) is essential for working with databases. Whether you're managing records, performing data analysis, or building applications — SQL helps you interact with data efficiently.

In this guide, we’ll explore important SQL queries, from basic to advanced, with examples you can practice today.

---

🔍 What is SQL?

SQL is a standard language to store, retrieve, and manipulate data in a database. It is used in MySQL, Oracle, SQL Server, PostgreSQL, and many other database systems.

✅ If you want to learn SQL professionally, check IT Planet Haldwani Computer Courses:
👉 https://www.itpcomputer.com/courses/dca.html
👉 https://www.itpcomputer.com/courses/ccc.html
👉 https://www.itpcomputer.com/courses/python.html

---

🧱 Basic SQL Queries

Query Type	Example
Create Table	CREATE TABLE students (id INT, name VARCHAR(50));
Insert Data	INSERT INTO students VALUES (1, 'Rahul');
Select Data	SELECT * FROM students;
Update Data	UPDATE students SET name='Amit' WHERE id=1;
Delete Data	DELETE FROM students WHERE id=1;

---

📌 1. SELECT – Fetch Data

SELECT * FROM employees;
SELECT name, salary FROM employees WHERE salary > 30000;

---

📌 2. INSERT – Add New Records

INSERT INTO employees (id, name, department, salary)
VALUES (101, 'Riya', 'HR', 35000);

---

📌 3. UPDATE – Modify Records

UPDATE employees
SET salary = 40000
WHERE id = 101;

---

📌 4. DELETE – Remove Records

DELETE FROM employees WHERE id = 101;

---

🧪 Advanced SQL Queries

🔄 JOIN Query

SELECT employees.name, department.dept_name
FROM employees
INNER JOIN department
ON employees.dept_id = department.id;

📊 GROUP BY with COUNT

SELECT department, COUNT(*)
FROM employees
GROUP BY department;

🎯 LIKE Operator – Pattern Matching

SELECT name FROM students WHERE name LIKE 'R%';

---

🔐 SQL Constraints

Constraint	Description
PRIMARY KEY	Uniquely identifies a record
FOREIGN KEY	Links two tables
NOT NULL	Prevents null values
UNIQUE	Ensures unique values

---

🎓 Want to Learn SQL Practically? Join IT Planet Haldwani

IT Planet offers beginner to advanced computer courses, including Database & SQL.

🎯 Recommended Courses:
🔗 DCA Course: https://www.itpcomputer.com/courses/dca.html
🔗 CCC Course: https://www.itpcomputer.com/courses/ccc.html
🔗 Python with SQL: https://www.itpcomputer.com/courses/python.html

📞 Contact: 9456545041
🏫 IT Planet – Govt. Recognized Training Center, Haldwani (Since 2012)

---

🏁 Conclusion

SQL is the backbone of data management. Mastering SQL Queries will help you in:

✔ Database Design
✔ Data Analysis
✔ Software & Web Development

Start learning today and become job-ready with IT Planet!

---

💬 Have any SQL Query doubts? Comment below – I will reply!