INDEX | SQL CONCEPT

INDEX
SQL CONCEPT
SNO	TOPICS
#	SQL Using Oracle
1	What is SQL ?
2	How to write Select Statement in SQL ?
3	How to use Concatenation Operator in SQL ?
4	How to use Where Clause in SQL ?
5	How to use Comparision Conditions in SQL ?
6	How to use Logical Condition in SQL ?
7	Create tables named Employee. Department, Salary, Implement all DDL commands on it.
8	On the Employee Table use the many faces of SELECT command.
9	On a table perform WHERE CLAUSE, HAVING, GROUP BY, ORDER BY, IN, NOT IN, BETWEEN.
10	Create a database implementing Primary and Foreign Key.
11	Implement I/O Constraints and Business Rule constraints on the database created above.
12	Perform Nested Queries on table STUDENT.
13	Perform different types of JOINS on any two tables.
14	Create VIEWS, SEQUENCES and SYNONYMS on a table.
15	Use of SAVEPOINT, ROLLBACK and COMMIT command.
16	Find the DepartNo and Department name for each employee.
17	Display the Name , Location , Department , of Employees whose salary > 1500.
18	Show all employee in details.
19	Show the List showing employees with their Annual Salary , Grade , DepartNo and DepartName.
20	Show Employee Details of Grade 1.
21	Show Employee Details whose salary >15000 and who are clerk.
22	Find employee name, Depart No, Depart Name.
23	Display the depatment who has no employee.
24	Find Average Salary for each Job.
25	Find all Departments that have more than 2 employees.
26	Find the employee having maximum salary in each Department.
27	Find Average salary of employee working in each Departments.
28	Find the employee name who earn Min salary.
29	Find the employee name who earn lowest salary in each department.
30	Find highest salary for each job.
31	Find the most recently hired employee in each department.
32	Which department has the highest remuneration bill.
33	Find second highest salary of employee.
34	Display EmpName like 'Amit****' and Salary like '****5000'
35	Find the Length of each Employee name
36	Create an employee table having followint attributes (Empno number type, EmpName String type, Salary decimal type,Bonus decimal type, DeptNo number type, DeptName string type) With Empno as primary Key.
37	Find the Length of each Employee name.
38	Insert 5 rows in the above Employee table.
39	Update Bonus of employee will become 10% of salary whose salary is Less than 50000.