Oracle PLSQL Online Training

PL/SQL BASICS:

1. Introduction to PL/SQL
2. Advantages of PL/SQL
3. Basic Syntax
4. Data Types
5. Variables
6. Constants
7. Records
8. Operators
9. Conditions
10. Loops
11. Strings
12. Arrays
13. Procedures
14. Functions
15. Conditional Statements
16. Iterative Statements
17. Cursors
18. Explicit Cursors
19. Procedures
20. Functions
21. Parameters-Procedure, Function
22. Exception Handling
23. Triggers
24. Environment
25. Exceptions
26. Triggers
27. Views
28. Collections
29. Transactions
30. Date & Time
31. DBMS Output
32. Object Oriented

ADVANCED PL/SQL TOPICS:

1. Materialized views
2. Instead of triggers
3. Packages
4. Heap and Index organized tables
5. Table Compression
6. Table Partitioning
7. Table Analyze
8. Bulk collect and FOR ALL
9. Global temporary table.(GTT)
10. Two dimensional collections.
11. Multi-dimensional collections.
12. Advanced datatypes (TYPES)
13. Dynamic executions
14. Bulk exceptions
15. PL/SQL profiling
16. OOPs in PL/SQL
17. Java Loader- Interface with JAVA application.
18. UTL functions – Sending emails, writing to files.
19. Oracle supplied DBMS functions
20. Oracle Large Objects
21. Nested tables.
22. VARRAYS
23. Using DBMS_UTILITY.FORMAT_CALL_STACK
24. Using DBMS_UTILITY.FORMAT_BACKTRACE
25. VPD (Virtual Private Desktop) fine grained access to data.
26. Best practices