SQL and PL-SQL Tutorial

Complete tutorial on Oracle SQL and PL-SQL covering all definitions and syntax with examples.

Below is list of SQL and PL-SQL topics covered in the app:

SQL:-

1. Create Table

2. Alter Table

3. Rename and Drop Table

4. Insert into Table

5. Update and Delete Statements

6. Transaction Control Statements

7. SELECT Statement

8. Components of SQL Statement

9. Truncate Table

10. BETWEEN Operator

11. DISTINCT/UNIQUE

12. Character Manipulation: CONCAT

13. WHERE Clause

14. INSTR Function

15. DUAL (Dummy table)

16. SQL Functions

17. Conversion Functions

18. DECODE Function

19. Implicit & Explicit Conversion

20. Using CASE in SQL

21. NVL, NVL2 & COALESCE

22. Date Functions

23. GROUP BY Clause

24. GROUP BY Clause with Filter

25. HAVING Clause

26. Group Functions

27. SQL Joins

28. Inner Vs Outer Join

29. COMMIT-ROLLBACK Data State

30. Locking in SQL

31. MERGE Statement

32. Types of Tables

33. RR & DD Date Format

34. Pseudo-coloumns

35. SQL Constraints

36. Views & Inline Views

37. WITH CHECK OPTION in Views

38. Indexes

39. Create User and Grants

40. Synonyms

PL-SQL:-

1. PL SQL Block

2. Types of Variables

3. SQL Functions in PL-SQL

4. Conditional/Selection Control

5. Loops in PL-SQL

6. Cursors in PLSQL

7. Cursors with Parameters

8. PL-SQL Reference Cursors

9. Bulk Collect and Bulk Bind

10. PL/SQL Records Data Type

11. Composite Data Type - VARRAY

12. Composite Data Type - NESTED TABLES

13. Composite Data Type - INDEX BY TABLE

14. Implicit Exceptions

15. Explicit Exceptions

16. Exception Trapping Functions

17. PL/SQL PROCEDURE

18. PL/SQL FUNCTION

19. PL/SQL PACKAGE

20. Trigger