SQL

SQL is a language to communicate with DataBase. Knowing SQL , you can communicate with almost all types of DataBases. There are verious types of Databases and they might have their own SQL .  But this does not mean that you have to learn each type of SQL to communicate with that particular DataBase. Unless you have to develop very high level SQL scripts, knowing one SQL will be enough to communicate with almost all DataBases. Here we are mainly dealing with Oracle SQL.

1. > Select statements in SQL
2. > CREATE TABLE and ADD DATA INTO THE TABLE
3. > Update table using SQL (UPDATE / SET)
4. > DELETE DROP and TRUNCATE in SQL.
5. > ALTER to MODIFY dataTypes, RENAME columnName / tableName in SQL
6. > ALTER to ADD / DROP columns in SQL
7. > ORDER BY IN SQL
8. > DISTINCT Clause in SQL
9. > GROUP BY , GROUP BY HAVING clauses in SQL
10. > SQL JOINS
11. > SELF JOIN in SQL
12. > EQUI ( INNER ) JOIN in SQL
13. > LEFT OUTER JOIN in SQL
14. > RIGHT OUTER JOIN in SQL
15. > FULL OUTER JOIN or FULL JOIN in SQL
16. > CROSS JOIN
17. > UNION and UNION ALL in SQL
18. > UNION ALL in SQL
19. > PRIMARY KEY AND FOREIGN KEY IN SQL
20. > SubQueries in SQL
21. > Stored Procedure in SQL
22. > Case statement in SQL  
23. > NULL values in SQL  
24. > Find Nth largest Value(Such as 3rd largest salary)  
    
25. > Search data with "Like" and "%"  
26. > Some common SQL Commands
27. > UPPER case, LOWER case, INITCAP letters/characters in SQL  
    
28. > SQL Constraints 
29. > Data Warehousing (DW)