EmployeeID	FirstName	LastName	BirthDate	HireDate	Department	Position	Salary
1	John	Doe	1985-06-15	2010-08-01	IT	Software Engineer	75000
2	Jane	Smith	1990-02-25	2012-05-15	HR	HR Manager	65000
3	Emily	Johnson	1982-11-30	2008-09-12	Finance	Accountant	60000
4	Michael	Brown	1978-01-20	2005-03-21	Marketing	Marketing Director	90000
5	Sarah	Davis	1995-07-10	2018-07-22	IT	System Analyst	70000

SQL Statements

SQL statements are commands that perform specific actions on the database. These actions can range from querying data to modifying the structure of the database. Below are some of the most fundamental SQL statements:

1. SELECT Statement

The SELECT statement retrieves data from a database. It is one of the most commonly used SQL commands.

SELECT * FROM Employee;

2. INSERT INTO Statement

The INSERT INTO statement adds new rows to a table.

INSERT INTO Employee (EmployeeID, FirstName, LastName, BirthDate, HireDate, Department, Position, Salary)
VALUES (6, 'David', 'Wilson', '1992-03-18', '2020-09-15', 'Sales', 'Sales Manager', 68000);

3. UPDATE Statement

The UPDATE statement modifies existing records in a table.

UPDATE Employee
SET Salary = 80000
WHERE EmployeeID = 1;

4. DELETE Statement

The DELETE statement removes existing records from a table.

DELETE FROM Employee
WHERE EmployeeID = 2;

5. ALTER TABLE Statement

The ALTER TABLE statement modifies an existing table.

ALTER TABLE Employee
ADD COLUMN Email VARCHAR(255);

6. DROP TABLE Statement

The DROP TABLE statement deletes an existing table from the database.

DROP TABLE Employee;

7. WHERE Clause

The WHERE clause filters records based on specified conditions.

SELECT * FROM Employee
WHERE Department = 'IT';

8. ORDER BY Clause

The ORDER BY clause sorts the result set.

SELECT * FROM Employee
ORDER BY Salary DESC;

9. GROUP BY Clause

The GROUP BY clause groups rows that have the same values in specified columns.

SELECT Department, COUNT(*) AS EmployeeCount
FROM Employee
GROUP BY Department;

10. HAVING Clause

The HAVING clause filters groups based on conditions.

SELECT Department, AVG(Salary) AS AvgSalary
FROM Employee
GROUP BY Department
HAVING AVG(Salary) > 70000;

11. COUNT Function

The COUNT function returns the number of rows that match the criteria.

SELECT COUNT(*) AS TotalEmployees
FROM Employee;

12. SUM Function

The SUM function calculates the total sum of a numeric column.

SELECT SUM(Salary) AS TotalSalary
FROM Employee;

13. AVG Function

The AVG function calculates the average value of a numeric column.

SELECT AVG(Salary) AS AverageSalary
FROM Employee;

14. MIN and MAX Functions

The MIN and MAX functions return the smallest and largest values in a column, respectively.

SELECT MIN(Salary) AS MinimumSalary, MAX(Salary) AS MaximumSalary
FROM Employee;

Some Important SQL Commands

• JOIN Statement
• UNION Statement
• DISTINCT Keyword
• IN Clause
• BETWEEN Operator
• LIKE Operator
• IS NULL Operator
• NOT NULL Constraint
• DEFAULT Constraint
• FOREIGN KEY Constraint
• CHECK Constraint
• Describe Statement

Conclusion

SQL syntax is essential for interacting with databases, enabling users to perform a variety of operations, from querying data to modifying database structures. Understanding and mastering these SQL commands and their syntax is crucial for efficient database management. This guide provides a foundational understanding, and further practice and exploration will solidify these concepts.