• 17. Views.
• 18. In-Line Query.
• 19.Row ID and Row Num.
• 20.Database objects.
• 21.TNS & How to create TNS
• 22.Data source & How to create a data source
• 23.JDBC Connection using JAVA
• 24.Q&A (Interview Questions)

9 . Sub-Query.

10. Correlated Query.

11. Joins with Respect to Where Clause and On Clause.

12. Cross Join and Cartesian Join.

13. Inner Join.

14. Left Join and right Join.

15. Full Outer Join.

16. Self Join.

• 1 .Introduction.
• 2 .Scalar Functions (String ,Date,Numeric,Conversion Functions).
• 3 .DDL, DML, and TCL Statements.
• 4 .Constraints in SQL.
• 5 .Arithmetic and Logical operations on Table data.
• 6 .Order by Clause, Pattern Matching, In, Between, and Exists clause.
• 7 . Aggregate Functions and Group by Clause.
• 8. Set Operations (Union,Intersect,Minus).

• 9.Cursors (Implicit Cursors and Explicit Cursors).
• 10.Packages.
• 11.Triggers.

5.String, Date, and Conversion Functions.

6.Conditional Statement (If, If..Else, If..Else Ladder).

7.Loop Statements (Loop Exit, Loop .. Exit When, While Loop, For ..Loop).

8.Stored Procedure and Stored Functions.

• 1.Introduction.
• 2.Variables.
• 3.PL/SQL Program Blocks.
• 4.Operators.