Practical knowledge and summary notes

INDEX

SQL QUERIES
S.NO. TOPIC SIGNATURE
1 SQL queries using create,
alter, insert commands on
customer table
2 SQL queries on emp table
using create, insert, update,
delete commands
3 SQL queries on emp table
using sql aggregate
functions
4 SQL queries using DDL
commands
5 SQL queries using DML
commands
6 SQL queries using DCL
commands
7 SQL queries using TCL
commands
8 SQL queries using nested
queries
9 SQL queries using
string(text) functions
10 SQL queries using numeric
functions
11 SQL queries using date and
conversion functions
12 SQL queries using group by
clause, having clause
13 SQL queries using set
operations - union
14 SQL queries using set
operations – union all
15 SQL queries using set
operations – intersect
16 SQL queries using set
operations – minus
17 SQL queries using order by
clause
18 SQL queries using joins
(inner or self join)
19 SQL queries using joins (left
outer join)
20 SQL queries using joins