Oracle SQL

SQL Course Content	Topic_Details
1. DB,DBMS,RDBMS,ORDMBS & DB development lifecycle	Click Here
2. About Oracle	Click Here
3. Client/Server	Click Here
4. About SQL	Click Here
5. Data, data definitions, schema, and SQL Developer tool and DB install process.	Click Here
6. Creating a User/Schema/Account in Oracle DB.	Click Here
7. Data types in Oracle.	Click Here
8. Creating,inserting a Table in Oracle DB.	Click Here
9. Operators in Oracle DB.	Click Here
10. Displaying data from Oracle DB.	Click Here
12. Where Clause	Click Here
13. In,between,Like,Is Operators	Click Here
14. Alias, All_users,User tables.	Click Here
15.Order by, Distinct,fetch clauses	Click Here
16.DDL commands(Create,Alter,Drop,Truncate,Rename,Flashback and purge)	Click Here
17. DML commands(insert, update,delete,insert all,merge)	Click Here
18.Built-in-functions(chr,number,date,conversions);special functions.	Click Here
19. How to implement loop in SQL.	Click Here
20. Analytical functions,partion by clause	Click Here
21. Group/Aggregate functions.	Click Here
22.Case Statement&Decode	Click Here
23. Group by Clause	Click Here
24. Where vs Having	Click Here
25. Rollup, Cube &Grouping ID.	Click Here
26. Integrity Constraints	Click Here
27. Relationship Types	Click Here
28.Joins	Click Here
29. Set Operators	Click Here
30. Sub-queries	Click Here
31.Any, All Operators	Click Here
32.Co-related subqueries	Click Here
33.Psuedo columns	Click Here
34. Exists, not exists operators	Click Here
35. Inline Views	Click Here
36. Controlling the Order of execution	Click Here
37. Rownum	Click Here
38.Scalar Sub-queries	Click Here
39.Pivot Operators	Click Here
40. Copying the data from one table to another	Click Here
41. Merge command.	Click Here
42.DB transactions	Click Here
43. Locking, Deadlock, table level locking & DB security.	Click Here
44. DB/Schema/Oracle Objects(Tables, Views, Synonyms,Sequences,MView,Index,Clusters)	Click Here
45. Table Partitioning	Click Here
46. SQ *Loader	Click Here
47. Decode	Click Here